# Rules with attributes

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• # Rules with attributes

Hello,

I'm in fight with an numeric attribute, which I want to use as exchange rate for a foreign currency.

Given Dimensions:

Division (here is define the currency, named "exchange rate", as attribute),
Account (e.g. 0678663, 0893341)
Datainfo (Elements: Budget, Budget EUR, Ist, Ist EUR)
Measure (Elements: value, text)

What I define as rule and doesn't function:

['Ist EUR'] = ['Ist'] / PALO.DATA("Host/Cube", "#_Division", "exchange rate", !'Division'). If I substitute the function PALO.DATA with an constant value, all is fine!

Where is my thinking error or what is the right syntax for PALO.DATA?

Thanks, for Help!
• # RE: Rules with attributes

Hi,
maybe your exchange rate doesn't get recognized as a number, why not trying to convert it to a number using the VALUE() function:

['Ist EUR'] = ['Ist'] / VALUE(PALO.DATA("Host/Cube", "#_Division", "exchange rate", !'Division'))

And you have to ensure your exchange rate is always present in order to avoid the VALUE function to return 0 (when conversion fails) and in turn the ratio to return an overflow.

Hope it helps,
cheers,
RQ

The post was edited 1 time, last by realquo ().

• Hi realqo,

attribute "exchange rate" is defined as numeric.

I have try it with value(... , but no result.

I believe, it is only a stupid mistake, but I don't know, how to solve it!

Every basic data entry contents the information division. So I think,
that automatically "exange rate" is available. But: Think I right?

The post was edited 2 times, last by Momo ().

• # RE: Rules with attributes

Hi,

PALO.DATA("Host/Cube","#_Division",.... seems strange...
The Syntax should be like
PALO.DATA("DBName","#_Division",...

"#_Division" is the Cube.

May be thats it?

Holger
• Hi Holger,

Yes, Sir! That's it. Wonderful! Many thanks!

And let us hope, that the FC makes a very good play in Freiburg.

Nice weekend,

Erich
• Hi Erich,
nice to hear.

>>And let us hope, that the FC makes a very good play in Freiburg.

Well, they are always good for surprises in both negative and positive way.

Have a nice weekend, too.

Holger
• Well, I didn't consider the syntax, I was supposing the rule was written using the editor...
Anyway, ok, that's the value of the community
Have a nice weekend,
RQ