[Solved] Building Logic/ Grouping filter in FM

[charon]

Hi cognoisers  ;D

I have tried today to build some logic in FM 10 as im used in RS.
Imagine following example:

i have countries like Germany, Australia, USA, France and Japan.
i want to group them for regions, example germany, australie and france are region europe. on these regions (query suject) il want to build a dimension for a dmr modell later on.

in rs, i would create a new data item and use a case syntax, sth. like
case [country]
when  'USA' then 'North america'
when 'Japan' then 'Asia'
Else ' Europe'
end

[But this wont work, im getin an error message (im 2 tired, forgot which one exaclty, i think it was qe-def-0045 or sth? kind like wrong data types ...il check tomorro again).]

EROR: RPQ-DEF-0058 can not....

Anybody an idea how to model this kind of grouping logic in FM?
Any suggestions are welcome as always...have agreat night
cheerzs :P



Hi...the answer is, to use the datapath from the data import layer. Means, using [business layer].[country id] gives me an error, using [data import layer].[country id] works for me with a simple case when structure. Have a nice day and cheerz :P