Skip to Content
avatar image
Former Member

Complex Sap text variable in WEBI with replacement path

Hi Gurus,

Variables in Bex

Present Fiscal Qtr : 2012Q4

Fiscal Qtr-8 : 2010Q4

My Output header(TEXT) in Bex as follows.

2010Q4_ ACT 2011Q1_ ACT 2011Q2_ ACT 2011Q3_ ACT 2011Q4_ ACT

2012Q1_ ACT 2012Q2_ ACT 2012Q3_ ACT 2012Q4 BOQ 2012Q4CONS

2012Q4_ACT 2013Q1 BOQ 2013Q1CONS

It's Completly working in Bex. I have used text variable and used replacement path to calculate the above texts.

WEBI : Even though the document from SAP says that the variables will work when it's derived through replacement path,

it's not working.

Question1 :

How can i achive this in webi . I saw some of the posts in SDN . They suggested to use 'USER RESPONSE' command.

Question 2 :

Assume we are using USER RESPONCE , when the current QTR = 2013Q1 . How can we derive the previous 8 Qtr 's , because

every Qtr the values are changing .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 04, 2012 at 01:59 AM

    i have a same situation, plase any help, any comments

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2012 at 07:31 AM

    Hi,

    let say you have passed one value in QTR object it means you are calculating measures for  perious 8 QTR values.if yuou simple drag the OTR object in the webi then  how many values are coming in the QTR object single or eight?.if eight values are coming  then you can use this object in the webi under the cross tab.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2012 at 11:30 AM

    Hi,

    In which way is it not working?  What's your SP and Patch level ?

    the webi pre-defined cell you are enquiring about is  either =PromptSummary()   or =UserResponse()

    Regards,

    H

    Add comment
    10|10000 characters needed characters exceeded