Skip to Content
avatar image
Former Member

Issue in ISOWEEK in IDT

Hi All

I have requirement that I should display past 6 weeks of
data from the User Week input (Prompt)

We are using SAP HANA as a backend and I am not able to do
Minus on ISOWEEK in IDT Universe(SAP BO 4.1).

    I would like to acheive below thing

      

WEEK

BETWEEN

USER ENTERED WEEK

AND

(USER ENTERED WEEK)-6

Pleasse let me know how to acheive this

    

Thanks

Ajith

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 14, 2015 at 12:22 PM

    Hi Support Admin,

    Your requirement can met by using the function ADD_DAYS() in conjunction with ISOWEEK() and TO_DATE all in one expression. The n paramenter (see syntax below) in your case would be -42 (6*7) .

    Syntax of ADD_DAYS:

    ADD_DAYS (d, n)

    Add comment
    10|10000 characters needed characters exceeded