Hi All,
we are using dimensional model for our report where -
1)
Dimension - Country_company
Level - Country_company
Members - All_company
2)
dimension - Currency
Level - Currency
Member - All Currency (it has 30 different currency including USA currency)
Member - Country Currency (it has 29 currency except USA currency)
Requirement-
We have already created a prompt for 'Country_company'. Now we need to create a currency prompt where it should have only two choices-
1) USA Currency 2)Country_Currency.
Please help can I achieve this.Much appreciate your help on this.
P
Isn't this the same thing you asked about in the post below? You left an unanswered question in the prior post. Why start all over again when all the same questions are going to be asked. I don't see anything in this new post that answers the important question from the last series of responses. You need to explain how your cube knows which currency is the local currency for a particular country.
Big waste of time double posting like this when people took time to look at your problem and ask questions attempting to assist you.
http://www.cognoise.com/index.php/topic,23616.0.html