TM1 Forum

Posted: **Tue Aug 26, 2008 6:01 am**

I donâ€™t know which function I have to use, but below is the example.

Cube: A
Amount Currency Explanation(String)
33000 THB AAA
1000 USD (It should show â€œAAAâ€, but it doesnâ€™t)

Once I change the currency from â€œTHBâ€ to â€œUSDâ€. The amount convert from 33000 to 1000 automatically from the exchange rate by using TM1 rule. However, explanation â€œAAAâ€ doesnâ€™t show. I donâ€™t know the rule to get data. Could anyone please suggest me?

Posted: **Tue Aug 26, 2008 7:47 am**

Hi anote,
I'm not sure that you have posted enough information for us to establish what you are trying to make happen. If you could perhaps list the the dimensions in your cube and paste your rules into the post then we might be able to help you.

Cheers,
Steve

Posted: **Tue Aug 26, 2008 9:21 am**

I assume you have something like

Code: Select all

['USD', 'Amount'] = DB('cube','THB','Amount') * 0.03;

Maybe you look up the numeric value (you should do so

) or you have more elements.

Try this:

Code: Select all

['USD', 'Amount'] = DB('cube','THB','Amount') * 0.03;
['USD', 'Explanation'] = S: DB('cube','THB','Explanation');

notice the S: - this one does the trick.

Did I guess correctly?

Posted: **Wed Aug 27, 2008 4:14 am**

Thank you very much for your kindly help.
It works

TM1 Forum

Writing a rule for string element

Writing a rule for string element

Re: Writing a rule for string element

Re: Writing a rule for string element

Re: Writing a rule for string element