I have a problem with what appears to be memory shortage
in Analysis Services (AS). Hope someone can help.


My setup:
Personal data (such as name, address, zip code, age etc.)
on app. 2400 people. The dimensions specific to an
individual (such as address) - I have about 20 of them -
I've defined as a member property of a 1-level person
dimension.

Finally I have defined 1-level virtual dimensions on each
of the person properties.


My problem:
If I drag the name to the vertical axis of the AS cube
browser, my measures are displayed on the 2400 entries.
However if I then add the address, AS tells me: "There is
not enough memory to display the requested cell set."

I suspect that AS tries to combine 2400 names with 2400
addresses expecting up to 2400x2400 records in the result
set - not knowing that the result set will at most contain
2400 records.


My question:
Is there a way of making AS understand that all names
don't need to be combined with all addresses?

Thanks in advance, Rolf Nielsen, Maersk Data

Rolf:
I'm wondering... why did you build virtual dimensions on
all properties? Have you created aggregated levels?
If you only want to display addresses side-by-side with
names, you can do that in most client tools without a
virtual dimension.
Regards,
Brian
www.geocities.com/brianaltmann/olap.html

Thank you all for your replies!

In answer to your questions/comments:

Sean, I am using a different user interface where I
experience the same. It just seemed simpler to explain the
problem this way.

Brian, actually the client side software I'm using, does
not support member properties in the version I'm planning
on using. However, very recently a new version has been
launched, that does.

I guess I'll have to check wether the new version is
stable enough to use.

/Rolf