Text Variable for 0CALWEEK: On Structure with Calweek offset

[Former Member]

Good day

Please assist? I have gone through numerous SDN threads relating to the following, but could not find a solution for my problem.

1) User wants to see 16 weeks data in columns, each week in own column. I have created a structure for each week with offsets 0 to -16, 0 to -15 and so on to display data. User wants to '0' display even if no data was loaded for a certain week, thus the structure. The data is displayed for 16 weeks. Now I want to replace it with calendar week text. (I have used week 12 to test text variable. week 12 should be displayed as 'example' 2008/42)

2) There are no calweek text variables available for selection, so I created a new one as 'replacement path', characteristic "Calendar year/week" and 'replace variable with "Name (Text)".

2.1) The following is the result 12 &0DPM_WV1&. Not what I wanted.

Where am I going wrong?

Your assistance will as always, be appreciated.

Thanks

CJ

[Former Member · Accepted solution]

You have to create 16 customer exit text variables and populate them in the RSR0001 Customer variable exit in i_step = 2.

http://help.sap.com/saphelp_bw320/helpdata/en/f1/0a56f5e09411d2acb90000e829fbfe/frameset.htm

http://help.sap.com/saphelp_bw320/helpdata/en/1d/ca10d858c2e949ba4a152c44f8128a/frameset.htm

If you always run your query as of current system date and display 16 weeks data till current date, then u can use sy-datum in variable exit to populate these 16 text varaibles. If you are using a user entered calweek in the report varaible and displaying 16 weeks prior to that week in your report, then you need to read the user entered variable inside the customer exit and populate the texts for all 16 weeeks.

Hope it helps!

[Former Member]

Good day. Thanks for your comments. This morning the correct text ie. 2008/34 (Calweek) was displayed. I realised that the cache was the problem for not displaying the information when I refreshed the query. Thus the text variable I created was working, but cache had to be cleared, log out of BEx and log in again.

Have a nice day

CJ

[Former Member]

Hi

Could you how it displays now???you want it to display as 42.2008 if it is 42nd week..

Becoz..Normally I have seen calweek displaying in report as 42.2008 ...not sure what actually you requirre??

explain in detail..

Thanks

BI Learner