Webi RelativeValue with BEx query universe

[Former Member]

Hi,

I'm new in webi and I have some problems with RelativeValue function.

I'm working with BEx query universe and I want to calculate real amount of the previous fiscal year.

=RelativeValue([Real];([Ejercicio - Clave]);-1) where [Ejercicio - Clave] is, for example, K2/2012 (fiscal year depends of fiscal variant).

Format table:

Rows = [Ejercicio - Clave]

Column1 = P&L Structure

Column2 =RelativeValue([Real];([Ejercicio - Clave]);-1)

And it doesn't work. Anybody knows if format of fiscal year is the cause of the problem?

Thanks.

[Former Member]

Hi,

I've resolved the problem. I must put all de fiscal years in the block. But that's what I don't want. I only want to see the real amount of de previous fiscal year of the selection, like this:

Column 1 = Previous fiscal year amount

Column 2 = difference between actual and previous fiscal year amount.

Rows = P&L Estructure.

Any ideas?

[Henry_Banks]

Hi,

You might have to overlay some "Hide when" formulae.

FWIW - i would discourage the use of characteristic structures as these can be troublesome when consumed in webi.

Regards.

H

[Former Member]

Hi,

I've tried this formula in format table "hide when following formula is true", but it doesn't work:

="[Fiscal year] <> ReportFilter([Fiscal year])"

I supose that ReportFilter([Fiscal year] is the value of the input control [Fiscal year], it isn't? In my case is K2/2012, but the values of the table doesn't change.

Can anybody help me, please?