Variable and Formulas Question

17 Views

Hi folks,

I use BOXI r2 sp 4 and I have a general question re: variables and formulas in Webi reports.

Billing Year Month and Cost of Service are standard time dimensions and measures that I use in my Webi reports and they were created at the semantic level.

Normally, I create cross tab reports with the Billing Year Month along the horizontal axis and the Cost of Service in the Body (Business Unit or Department would be placed along the vertical axis).

For some reason, when I use formulas/variables to modify the standard time dimensions (like changing Billing Year Month to Year), the values for the Cost of Service are returned incorrectly.

Example.

Semantic object: Billing Year Month = (yyyy-MM) returns correct values

Report variable: Substr([Billing Year Month;1;4) returns incorrect values

Can anyone please explain this problem?

Thanks,

Wannetta