How do I obtain detailed reports through SSRS on an OLAP datamart?
2 posters
Page 1 of 1
How do I obtain detailed reports through SSRS on an OLAP datamart?
I am accustomed to writing detailed reports from my OLTP databases. Piece of cake and I have no problems with this.
Now we are putting in our first datamart and I am at a loss.
1. Will I be able to use the datamart dimensions and facts to produce the same 'detailed reports' as in my OLTP environment?
2. Will I be able to use the cube dimensions and facts to produce the same 'detailed reports' as in my OLTP environment?
If 'no' to the answers above please point me into a direction which will assist with adding the needed clarity in my thinking.
Now we are putting in our first datamart and I am at a loss.
1. Will I be able to use the datamart dimensions and facts to produce the same 'detailed reports' as in my OLTP environment?
2. Will I be able to use the cube dimensions and facts to produce the same 'detailed reports' as in my OLTP environment?
If 'no' to the answers above please point me into a direction which will assist with adding the needed clarity in my thinking.
dimdate- Posts : 1
Join date : 2014-07-31
Re: How do I obtain detailed reports through SSRS on an OLAP datamart?
1. If its a relational database, its SQL. If the data is there, sure.
2. Cubes (MDDB) are specifically designed to support OLAP analysis, not tabluar reporting. They are not meant to store the level of detail needed to support operational type reports. MDX, the standard query language for cubes, is not suited for such queries.
2. Cubes (MDDB) are specifically designed to support OLAP analysis, not tabluar reporting. They are not meant to store the level of detail needed to support operational type reports. MDX, the standard query language for cubes, is not suited for such queries.
Similar topics
» How to make reports against a Datamart
» Get all reports in production
» Timezone change fpr all reports
» How SSRS indicators work...
» A detailed list of 22 Business Intelligence & Big Data events that you should attend before the end of 2014
» Get all reports in production
» Timezone change fpr all reports
» How SSRS indicators work...
» A detailed list of 22 Business Intelligence & Big Data events that you should attend before the end of 2014
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum