Ancestors for multiple members selected by a prompt

[surgents]

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

[jahnavi]

can you pls expain us clearly wat you are going to fetch

[rockytopmark]

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?