Post reply

Dynamic reports using OLAP Cubes

  • March 3, 2011 at 10:01 am

    #234607

    Hi

    Can you explain how , when and why Dynamic reports are using OLAP Cubes with example?

    Regards

  • March 3, 2011 at 12:07 pm

    #1294220

    Again, is this an interview question?

    What do you mean with dynamic reports?

    OLAP cubes, such as SSAS, are just a datasource for a report.

    You can report on many sources, such as every OLE DB compliant data source.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 3, 2011 at 12:22 pm

    #1294237

    No, its not an interview question , i just got started with this concept so would like to know what kind of dynamic reports can be created using OLAP and why dynamic reports need to be created by OLAP and is there any other alternative for it?

    Can you please guide?

  • March 3, 2011 at 12:34 pm

    #1294251

    Again, what do you mean with dynamic reports?

    Drill down/up, drill through, active filtering (such as in Project Crescent), ... ?

    Your question is quite general, so it is not easy to give an exact detailed and correct answer.

    Maybe you can read up on the subject and ask specific detailed questions later...

    (one tip: reports on OLAP cubes are usually crosstabs - or matrix reports in SSRS terminology - based on aggregate data)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 3, 2011 at 2:17 pm

    #1294333

    thanks , this helps.

    Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply