Hello richykong ,

Thanks a lot for your reply

I have looked up on ASSP you were talking about and It has Solved my problem in obtaining detail level information for the Dimension Values.:-)

Other than that,

1. The dimension with 5 million rows will not be growing. It will be fixed. All my measures are aggregated at this dimension level. So i need to include this dimension whenever User hits the Cube.

2. The row count user tries to access from Cube varies approx from 1 row - 1 million rows. Here, We use both the aggregated values and details for analysis.Since the aggregated values are based on this huge dimension, We have bigger data sets returned back depending on the user criteria.

So, Will it Still be a good idea to go for a cube for my scenario?

Can HOLAP storage be of any help?

Thankyou