Skip to Content
avatar image
Former Member

how to get calweek number from 0calweek

Dear All

How to achieve calweek number (EX: 002 ) from 0calweek (002.2017) . I have requirement where user select 0calweek /year and comaparision calweek/ year ( Ex: user select 002.2017 - 005.2017 and in the comparision week they select 003.206 - 004.2016 ) In the report output they wants to see only calweek number not calweek / year .

i dont have 0WEEKDAY time character in cube .

I tried to create a text customer exist but it is not working .

Thanks

kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 21, 2017 at 01:50 PM

    Hi,

    if you got in your cube 0calweek you have all the info you need to substract the week seperatly from it. If you do it via a attritutes or directly in your transactional flow is up to you. But you can easily model it in BW.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 25, 2017 at 01:46 AM

    Hi,

    You may create a variable with REPLACEMENT PATH then just do an offset with OFFSET START = 5 and OFFSET LENGTH = 3 to get the calweek number.

    https://help.sap.com/saphelp_nw73ehp1/helpdata/en/43/565cd22fc95f6ce10000000a1553f6/content.htm

    https://help.sap.com/saphelp_nw70/helpdata/en/bd/589b3c494d8e15e10000000a114084/content.htm

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded