variable code in webi report XI R3 from BO object metadata

[padupadu]

Hi All,
I have a little issue and I hope someone can help me.

For example in BO universe I have this table with 2 fields filled by "classic" value and 1 filled by "metadata code" like this:
f.e.
Field1 Field2 Field3
1 100 'if Field2=100 then 1 else 0'
2 200 'if Field2=200 then 1 else 0'
.......

after I mapped the fields in related BO Object Dimensions.

then in a report I would you like to use Field3 Dimension as a result and not as a string

f.e.
is it possibile to obtain the following result in a report?

1 100 1 <-- if result and non the string
2 200 1 <-- if result and non the string

thanks a lot for your cooperation
Best regard

ap

 

[hilfy]

There is no way to get Webi to evaluate a text "formula" that is stored in the database.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[padupadu]

Hi Dell
I had supposed :-( , anyway thanks for the help.