What are types of storage modes in OLAP?

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 Justin Antony

What is the Property to set the Drillthrough or Linked SSRS Report ?

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 Justin Antony

How to create a simple report ?

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 Justin Antony