Building a reporting cube with dummy measures

• Orion Pax

  SSC Eights!

  Points: 824

  More actions

  September 18, 2007 at 10:08 am

  #374304

  Hi Guys,

  I currently attempting to build a cube for reporting purposes. The only problem is that the reporing model does not contain any measures. It purely for data reporting purposes. I thought of using the default model functionality of SSRS but this will not offer the greatest performance as majority of the tables contain millions of records.

  Is it possible to create a cube that does not use "real" measures. E.g. Create one big fact table with a column "Cnt". "Cnt" being the records count to be used as a dummy measure.

  Thus allowing user to do ad hoc reporting based on a cube. Surely this will provide quite some performance advantage...

  Let me know what you guys think (or suggest)

  Hank

• sm

  SSC Rookie

  Points: 39

  More actions

  September 19, 2007 at 4:27 am

  #734514

  Yep, you could that.

   

  Or, why dont you use the data mart to report off, or create an aggregate table to report off?  Why do you need the cube?

  Cheers