I have transaction fact table with approx. 200 million rows. It has date , product , region dimension which the users wishes to slice and dice by. The fact table has over 20 other degenerate / junk dimensions which the users only want to see when they do a drill down.
I am using sql 2008 r2. and using molap cube. I have only created 3 dimensions for my cube (date , region and product ) but want the user to see the detail rows of the fact table all columns How can this be done ?
asked Sep 11, 2017 at 10:59 PM in Default