Skip to Content
avatar image
Former Member

Webi last six months data using week number prompt

Hi experts,

How to get last six months data in webi using week number prompt i.e 201643.

I want to get data from 201617 to 201643.

DB is oracle and BO version is BI4.1 SP3.

Can we achieve this using user response?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 24, 2016 at 09:39 AM

    Hello Guru,

    Option 1 :

    If you want to create LOV's then simply create one Dimension in Universe with:

    Formula:

    TO_CHAR(<date object>,"YYYYIW")

    Above formula will give you Dates in ISO week format. (https://en.wikipedia.org/wiki/ISO_week_date)

    You can use same in Report Query as Prompt with Between Operator.

    Option2:

    You can create Prompt defination in Univesre with TO_CHAR function of Oracle as below.

    TO_CHAR(<date object>,"YYYYIW") >= @Prompt("Enter From Week".......)

    AND

    TO_CHAR(<date object>,"YYYYIW") <= @Prompt("Enter To Week".......)

    Regards,

    Sushil Padhye

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Guru,

      If you want to work "week number as prompt" then you need to create Object at Universe and use this at Report Query.

      Regards,

      Sushil Padhye