Same name Metrics within a Prompt 1

[LGMan]

Hi, bit of a wordy explaination but I'm really stuck!
My customer has several month movement metrics - local currency and 3 'reported' currencies such as the local currency translated in Euro, US£ or GB£ at the prevailing exchange rate. Currently the reported Currencies are called US$ Mth Mvmnt & GBP Mth Mvmnt while the local currency is just called Mth Mvm't

The problem I have is the customer wants all of these to be called Mth Mvmnt. I can do this by having them in seperate folders, but the problem comes when I build them into the same object prompt, as it now becomes hard to tell which ones are which.
I have a report say with only 2 prompts,
Prompt 1 has all the currencies (Element Prompt)
US Dollar
Pounds Sterling
Euro (Pan European Currency)
Local Currency

Prompt 2 has all the metrics (with current names)
US$ Mth Mvmnt
GB£ Mth Mvmnt
EUR Mth Mvmmt
Mth Mvmt

Currently I apply logic in prompt2 to search on a string of characters from the chosen answer to prompt1 such as US Dollar, this then enables the customer to only see the metric applicable to US Dollar, hence Prompt 2 would only show US$ Mvmnt, but would change to GB£ once Pound Sterling is chosen in prompt 1.

This logic will not work if all the metrics are called Mth Mvmnt.
Has anyone got any cool ideas to help, I do not want to go down the route of Prompted Templates.

 

[nlim]

Silly question maybe, but how will the customer know which currency the "Mth Mvmnt" they have selected is in?

I'm guessing that your template has one metric. In the ideal world, the user would pick US in prompt 1, and the report will just show that metric without prompt 2, and without prompted template.

You have another option which is to create a object prompt P1 with all the metrics in it. Create a new metric M1 and drag P1 onto the definition area. Now you can place M1 on the report. Only problem is the currency sign and name will be fixed and not dependent on what the user chose...

 

[LGMan]

Thanks nlim,
I will also be using Prompt1 as a column prompt so US Dollar or Pounds Sterling appears on the report above the Metrics. The main reason why the customer wants all the metrics called Mth Mvmnt is that the more letters or words in the metric name means the wider the metric column is and thus fewer can be seen on screen without scrolling. There will be 7 or 8 metrics on the report such as Mth mvmnt, Mth Budget, Mth Variance, Year to Date Mvmnt and so on. I only cited the one metric to keep my explaination as easy as I could, apologies if this made the original question seem a bit dim
The 4 types of Mth Mvmnt metric described orginally all use different facts.
Does that make any difference to your tip?
Thanks

 

[nlim]

no diff. it might be easier if you created an object prompt for the facts instead; let's call it FP1. In your metric def, it should look like this SUM(?FP1). Then place this metric on the report. You can name your facts quite descriptively independent of the column names.

The same problem will be there, the currency formatting will not change dynamically with the user selection. Leave P1 there to the get your currency text above the metrics.

 

[LGMan]

Thanks nlim, that is certainly a good way around this, which I never knew existed, I'll need to refine it a bit more to fit my actual report.
One thing that I didn't mention was there are 3 types of each of the 4 Mth Mvmnt metrics which show the figures in whole Dollars, $k and $m. The problem with these are the number of decimal places differ between Whole, thousands and millions :-(

Any further gems will be greatly appreciated.

 

[nlim]

too bad you can't pick the metric, and let the user define the formatting themselves. Sigh, users have to spoonfed every step of the way.

 

[LGMan]

Yeah, the problem with the metric rounding may have to be the price the customer pays for having everything appearing to have the same name. They can always reformat the report once they see the output if they really can't live with the decimals.
Thanks again