well, not really 'auto-exists'...
but, suppose for one company I have 2 dimensions amongst others in a star schema:
1. business locations
2. customers, including a user-hierarchy 'location - customer'
I often need this user-hierarchy but only for the location selected in the business location dimension. How can I narrow the user-hierarchy?
It sounds simple, but there are some pitfalls that bother me when taken all together:
a. The locationID in the customer dimension is not the key of the location in the location dimension.
b. I can't use (as far as I know) common functions like non empty, nonempty(), filter-expressions with measure=0,
because the customers are usually crossjoined with some sets like products, they *do not* have bought
- e.g. tell me the customers of my location X that have bought more than 1000 in product category A but nothing in product subcategory B2.
When I use non empty & Co then customers of all locations came up.
c. I must use the location dimension, because the cube security roles use it to show the responsible persons for one location just the customers of their location.
d. I need a parameterized mdx solution for Reporting Services 2008 reports.
Thanks in advance
View Complete Post