Text variable replacement not working in Web-Intelligence report?

[Former Member]

Hi All,

I have created a bex query where i provide cal . yr/quarter as input and in return i get past four quarter revenue along with present quarter revenue.

Now i have created a text variable(zcalquat) which replaces cal yr./quarter with its text for 5 quarter dynamically at runtime.

Now i have created a universe and webi report on top of that query.

But my webi report shows heading for all five quarters as &zcalquat& instead of its quarter text .

I mean to say that my text variable is not getting replaced dynamically in web -intelligence report .though its working in bi.

please provide a solution that i need to do in universe designer so that i get dynamic variable replacement according to inputs entered.

Need help from you all.

Hope my issue get solved.

PRIORITY !!!!!

With Regards,

Montz

[Former Member]

Hi All,

I expect some more reply friends!!!!

[Former Member]

Text variable replacement does not currently work. You must use WEBI functionality instead.

[Former Member]

HI,

i want to know then if user enters a single quarter value then he should get data of current quarter in addition to previous four quarter.If i design this in bex that den i cant use text variable via replacement path in webi. So plz provide me a solution via which i can achieve my query in webi by just entering single quarter value.

With regards,

Montz

[former_member760545]

Hi Montz,

I just heard from SAP support that replacement path text variables in restricted key figures does not work in XI3.1 SP3. This is logged as a bug and is to be fixed in XI3.1 SP4.

However, replacement path text variables work in selections in structures. You could make a structure with 5 selections in it. Each selection should filter on the specified quarter. You can use the basic offset function in BEx Query designer on the 0calquarter infoobject.

Then the BEx structure becomes a dimension in your universe and you will be able to drag this dimension into your webi report and you will see the 5 selections representing the quarters.

Let me know if it works:-)

Best regards,

Morten