Skip to Content
author's profile photo Former Member
Former Member

Text Variable for 0CALWEEK: On Structure with Calweek offset

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 04:03 PM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 03:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.