Prompt selection help

[pooja]

Hi there.
I have a report with 2-prompts- 1) Company_location & 2)Currency.
We have around 40 different currencies for different locations around the world. Example USA- 'USD', Dublin - 'EUR', UK - 'GBP'.........and so on.

Now how can I make the prompt selection like- If I select UK_Company then 'Currency' prompt should only display 'GBP' AND If I select USA_Company then 'Currency' prompt only display 'USD'....and so on.

Much appreciate you help on this.

P

[MFGF]

Hi there.
I have a report with 2-prompts- 1) Company_location & 2)Currency.
We have around 40 different currencies for different locations around the world. Example USA- 'USD', Dublin - 'EUR', UK - 'GBP'.........and so on.

Now how can I make the prompt selection like- If I select UK_Company then 'Currency' prompt should only display 'GBP' AND If I select USA_Company then 'Currency' prompt only display 'USD'....and so on.

Much appreciate you help on this.

P

Hi Pooja,

Where in the data is the link between company location and currency? If you have this in a query subject somewhere you can add a filter to the query driving the Currency prompt to retrieve only currencies for the chosen company location parameter value.

Cheers!

MF.

[pooja]

Thank you MF,

These two company location and currency are dimension. We are using Cube for this report.

[MFGF]

Are they in the same dimension? If so, is currency an attribute of company location or a child of company location or something different?

If they are in different dimensions how does the data determine which currencies belong to which locations?

Can you advise - once we know how the dimensions are structures we will hopefully be able to suggest the best solution.

Cheers!

MF.

[pooja]

so much for quick response.

these two are coming from two different dimensions.

[MFGF]

so much for quick response.

these two are coming from two different dimensions.

Ok - so how (in the data) can your report determine which currencies relate to which locations? If they are in separate dimensions it sounds like there is no inherent link?

MF.

[pooja]

they do not have any inherent link.

[MFGF]

they do not have any inherent link.

In that case I have a question for you, Pooja my old friend...

How can your report display only the "relevant" currency for each location when you have nothing in the data that links currencies to locations?

How can it know?

Somehow, somewhere you will need this link if you want to do what you are requesting. Can location perhaps be added as an attribute of the Currency level so you can filter on it with a filter() function? Even if you could do this, how would you handle currencies belonging to multiple locations?

Oh - that was more than one question - sorry! :)

Cheers!

MF.

[pooja]

OK..here is the updates...

Actually these both 1)Company_location & 2)Currency under same dimension. see attachment.
Much appreciate you help on this.

[Francis aka khayman]

you changed your package or you just made a mistake in your last statement?

they do not have any inherent link.