MS SQL Server OLAP - Help: Question

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Help: Question

XXX

2005-09-20, 11:23 am

I am building a cube which will needs to count on it's membership by various
dimenisions like gender, income, education, age, country, etc.

What is a good way to go about it? Build separate dimensions for each or
Create virtual dimensions by creating a Membership dimension with Member
properties.

What is the benefit of one over the other?

The membership table has over 50 million rows currently.

Thanks.

Sponsored Links