The data in the fact table has columns which are precalculated ranks for the products based on sales.
How to create them as measures in the cube without any aggregations. I selected the properties for measure as "No Aggregations" while creating. But I dont see any data.
Then I tried to create those columns as seperate dimensions by doing self join to the fact table.In this way I get the correct data,but the performance is slow.
Is there any other way to try out which has both data and performance.
Please help me out.
View Complete Post