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
Drilldown SSRS Report
Right Click on the Group properties-> Choose Visibility -> Hide
What is the Property to set the Drilldown SSRS Report ? was last modified: October 1st, 2017 by
simple SSRS report
New -> Project -> Report Server Project -> Right click on Shared DataSet -> Add New Data Source
Right click on Report Folder -> Add New Item
In the Report Data Tool Bar -> Right Click on the Data Sources -> Select the shared Data Source which we created already
Right Click on the Data Set -> Add DataSet -> Define your query here
Drag and Drop a table
Pick the Data fields from dataset and place it on the table.
Align and format the Table Accordingly
Add header to your Report.
Save and Run the Report.
How to create a simple report ? was last modified: October 1st, 2017 by
Reports that gets parameters from user to fetch data based on the parameter input are called parameterized reports.
What are parameterized reports? was last modified: October 1st, 2017 by