Skip to Content

Webi last six months data using week number prompt

Nov 24, 2016 at 02:42 AM


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

Hello Guru,

Option 1 :

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


TO_CHAR(<date object>,"YYYYIW")

Above formula will give you Dates in ISO week format. (

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


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

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


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


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.


Guruprasad G


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.


Sushil Padhye