How do I obtain detailed reports through SSRS on an OLAP datamart?

View previous topic View next topic Go down

How do I obtain detailed reports through SSRS on an OLAP datamart?

Post  dimdate on Thu Jul 31, 2014 8:53 am

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.

dimdate

Posts : 1
Join date : 2014-07-31

View user profile

Back to top Go down

Re: How do I obtain detailed reports through SSRS on an OLAP datamart?

Post  ngalemmo on Thu Jul 31, 2014 2:52 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum