Question Re: Text variable replacement not working in Web-Intelligence report? in Technology Q&A

Text variable replacement not working in Web-Intelligence report?

Former Member — Tue, 13 Jul 2010 12:36:34 GMT

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

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Tue, 13 Jul 2010 12:58:43 GMT

My experience is that text variables in the descriptions for the calculated/restricted key figures does not work. This is because this is considered as metadata for the CKF/RKF and this is not loaded when running the Webi query. I am not happy with this - I consider it an SAP BI to BO integration defect - so if you find a solution I would be very interested.

Re: Text variable replacement not working in Web-Intelligence report?

former_member793810 — Tue, 13 Jul 2010 13:27:02 GMT

Hi,

Functionalities that can be done in BW and BO WEBI in different ways, but cannot be transferred from BW to BO in current BO version (BO 3.0/3.1) like Text Variables.

There are steps to help you create one in WebI

Create a prompt variable in BO based on which you want to change column name. In this example letu2019s assume it is Calendar Month.

Select Prompt. Define text for the prompt. In this case it is u2018Calendar Monthu2019

Refresh the report. Enter the desired selected month. Define the properties of the prompt like single, range, in between, etc., as required.

Define USERRESPONSE function for column whose label has to be dynamically replaced by selected month. Define the text of the prompt inside the USERRESPONSE function.

You can use some advanced functionalities for USERRESPONSE functions. Please click InfoView Help for more details.

The column label will be replaced by Dec 2009, the selected month in this case.

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Wed, 14 Jul 2010 04:36:37 GMT

Hi All,

I expect some more reply friends!!!!

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Wed, 14 Jul 2010 11:25:10 GMT

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

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Thu, 15 Jul 2010 04:26:42 GMT

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

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Thu, 15 Jul 2010 11:34:34 GMT

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

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Mon, 19 Jul 2010 13:06:35 GMT

Can you please explain with a example in detail on how will i get previous quarter text?

With regards,

Montz

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Mon, 19 Jul 2010 13:34:34 GMT

Hi Montz,

You need a variable (manual user entry) built on 0calquarter that will be run when the report starts. You can set the variable to mandatory input so the user always has to fill out this variable when the report is executed. Did you already create this variable??

Then you create a structure in your query. Make 5 selections and in each selection you drag the infoobject 0calquarter into the selection. Restrict the 0calquarter infoobject in your selection by choosing the variable on 0calquarter you just created. On the first selection you do not make an offset. On the second selection you make an offset on the variable that is "-1". On the third selection you make an offset that is "-2" and so on.

Now you should have the correct data in your structure. Now you will need a text variable that can be dynamically updated depending on the user input. Create a new text variable on the 0calquarter infobjects that uses "replacement path". Set the text to "label" and check the "from value" box. Now this text variable will show the correct quarter text dynamically.

If you need more details, then just ask:-)

Best regards,

Morten

Re: Text variable replacement not working in Web-Intelligence report?

former_member793810 — Mon, 19 Jul 2010 13:51:09 GMT

Since Text Variable cannot be imported into WebI from Bex yo uneed to create in WebI.

Follow following syntax pattern to achieve this task...

=If(UserResponse("Quarter"))="0calQuarter" Then "XYZ"

Regards,

Bashir Awan

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Mon, 19 Jul 2010 13:56:21 GMT

Hi Bashir,

The userrepsonse function is also an okay solution. However, text variables do indeed work when using them in structures in BEx.

The text variables will not work when used in restricted key figures.

Best regards,

Morten

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Mon, 19 Jul 2010 14:18:22 GMT

Hi Bashir,

If i give cal/quat = 20101

Then what formula i should write to get text for current quarter in addition to past four quarters.

With Regards,

Montz

Re: Text variable replacement not working in Web-Intelligence report?

Former Member — Tue, 20 Jul 2010 20:48:50 GMT

Hi Montz,

The formula to get the user input could be something like this:

=UserResponse("Calendar year / quarter")

You may have to change the "Calendar year / quarter" text. This text should be the same as the text you see in the top of the prompt window when you have to enter the quarter prompt.

You should use different formulas for the other quarters. The formulas will be long and you probably have to split the result from the UserResponse function and concatenate it with other strings to get your desired text. Be aware that the result from the UserResponse formula is a string and you may need to turn it into a date before changing the format.

If you have problems making the quarter texts, then write back and tell us the exact format you need.

Best regards,

Morten