Factless Fact Table
Fact table will not have a measure they will have only the key values refered to the dimension are called factless fact table.
What is a Factless Fact Table ? was last modified: October 18th, 2017 by
The table which contains METRICS. This table will store only the measure values.The primary key of a fact table is usually a composite key made up of all of its foreign keys. This Fact table will locate at the center of the Star and snowflake schema
What is a Fact Table ? was last modified: October 1st, 2017 by
A data mart is a subset of an organizational data store. Datamart focus on specific business functions for a specific organization.
What is a DataMart? was last modified: October 1st, 2017 by
OLAP storage modes
There are three standard storage modes in OLAP they are
1.MOLAP — the data and aggregations are stored in a multidimensional format
2.ROLAP — data and aggregations are kept in the relational database instead of on the OLAP server
3.HOLAP — HOLAP is a combination of MOLAP and ROLAP HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format
What are types of storage modes in OLAP? was last modified: October 1st, 2017 by
1. Star Schema
2. SnowFlake Schema
3. StarFlake Schema : A hybrid structure that contains a mixture of star(denormalized) and snowflake(normalized) schema.
What are the Types of Schema Structure in SSAS? was last modified: October 1st, 2017 by
embedded code SSRS
Code which wrote on the report can be reused in any expression of the report.
What is embedded code in a report? was last modified: October 1st, 2017 by
Drillthrough SSRS Report
Right Click on the field -> Choose Series Properties -> Action -> Go To Report -> Specify a Report -> Provide the necessary parameter input below
What is the Property to set the Drillthrough or Linked SSRS Report ? was last modified: October 1st, 2017 by