Skip to Content
0

Webi last six months data using week number prompt

Nov 24, 2016 at 02:42 AM

104

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the update Sushil,

However, i do not want to touch my Universe.

I want this to achieve in report level.

Thanks

Guruprasad G

0
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

0