Hi,
i want a multiselect prompt on Products and a simple list with two columns:
Product-------Product Line
Product column is defined like set([sales_and_marketing].[Products].[Products].[Product]->?pProduct?)
How to define Product Line column?
Using currentMember([sales_and_marketing].[Products].[Products]) gives me the member i have in Product column, but when i use it in an ancestor function, it is not working...
Thanks
can you pls expain us clearly wat you are going to fetch
How about simply:
[sales_and_marketing].[Products].[Product].[Product line]
Does this not give you what you need? Seems to work in my replication of your test... What does your desired resultset look like?