I have a dimension containing a string as the member column. Each member is
associated with a member property containing a numeric ID. The ID in essence
identifies the member uniquely.

I need to select a subset of the members in the dimension based on the ID
(which is defined as a member property). However, I am using a front end
application, which does not support selecting members based on member
properties, so I have created a virtual dimension containing the member
property "ID" from the regular dimension. When I select the members of the
virtual dimension that I need, the correct members of the regular dimension
are displayed. The problem is that the query is VERY slow - much slower
than if I just selected the members from the regular dimension directly
(this can for various reasons not be done in general, which is why I use the
other approach). Why is that and is there any way to speed up a selection
like this? Do I have a design issue which needs to be resolved?

If I need to be more specific, please let me know.

Thanx a lot in advance for any help!

--
Michael Barrett

If this ID identifies each member uniquely - why not use that column as a
member name directly ? This way you won't need virtual dimension. Virtual
dimensions are great when you have many to one relationships (alternative to
the normal hierarchy), but here you have one to one.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Michael Barrett" <mbiwj001 (AT) sneakemail (DOT) com> wrote

"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote

Thanks for your answer.

Well.... I must admit that I might have been a bit too quick about my
ability to uniquely identify the member name by the property "ID". It turns
out that I have a one-to-many relationship between the "ID" (the member
property) and the member name. I.e. each ID can relate to multiple member
names. Apart from that I do not want the users of my application to see the
ID, because it would not make any sense to them. I just need to filter on
the ID, and it is really my main problem to do this in the most efficient
way.

--
Michael Barrett

Micheal,

Sounds like your front end app is letting you down here. There are
clients that allow you to select members from a dimension based on
their member properties.

Which front end are you using?

Post me a mail if you prefer.

Gabhan Berry
AI Prediction and Forecasting in Excel
http://www.pececillo.com



"Michael Barrett" <mbiwj001 (AT) sneakemail (DOT) com> wrote

Hey Gabhan

Thanks for your answer. We are using the danish product TARGIT Analysis
Suite (www.targit.com) as our front end, and as mentioned it does not
currently support filtering members based on member properties.

--
Michael

Gabhan Berry wrote: