Skip to Content
0

Webi last six months data using week number prompt

Nov 24, 2016 at 02:42 AM

97

avatar image

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

Sushil Padhye 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

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

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