Prompt Issue in Infoview

building reports desktopintelligence
1

Hi Friends,

I am facing an issue with a report prompt window in infoview. I created a Desk I report which contains a universe based prompt retrieves 200 thousand rows from database. In DeskI when I clicked on values it shows all 200 thousand rows in a minute, but after publishing the report to BO repository when I open the report in Infoview it is not showing the prompt window. It keep on saing that “Please wait Open Document”. How do I handle this situation.

I have to show this 200 thousand rows from that LOV object, the LOV object SQL is very simple and it run in 3 secs in toad.

Any suggestions will be a great help.

Thanks in advance.
Santhano

santhano :india: (BOB member since 2004-10-12)

2

Hello All,

I tried with a different approach this time (still facing the issue). I created a new LOV object and unchecked the “Automatic refresh before use” from the object properties and cheked the “Export with universe” option. Now I pointed the universe prompt object to the newly created LOV object in @Prompt.

This time when I open the report in Infoview, I am getting the blank prompt screen which is expected and allowing to click on Refresh values button. I am getting all 200thousand values in a minute when I click on Refresh values. But the problem which I am facing still is that… After refreshing the report with few values from prompt… If I click on Refresh data button in right corner of report, the prompt is not appearing it says “Please wait refreshing Data”… this windows is showing up continusly.

Any workaround or thoughts on this ?

santhano :india: (BOB member since 2004-10-12)

3

200 Thousand values in LOV?

I think there is a limit of 999 values for LOV’s.

Rakesh_K :india: (BOB member since 2007-12-11)

4

Rakesh,

200 thousand values will appear in LOV when we click on values button in Desk I and in Infoview when we click on Refresh Values.
It is not the values what you enter as a input to prompt.

I hope this is clear.

santhano :india: (BOB member since 2004-10-12)

5

May be this will give you a clear idea.

https://bobj-board.org/t/73245

Rakesh_K :india: (BOB member since 2007-12-11)

6

This is not a WebI issue… infact I create a test WebI reports based on the prompt which I using works fine in WebI… It shows all 200 thousand rows.
My main problem is that the original report which I have is based on DeskI and the prompt works fine in DeskI but if I run the same report through Infoview(thats where users will running), the prompt window getting stuck.

is it because Infoview is in 3 tier, why the LOV is getting stuck at infoview ?

santhano :india: (BOB member since 2004-10-12)

7

Hi Friends,

Any suggestions ?
I am still facing this issue. The universe prompt works fine in DeskI and works perfectly if I add the prompt in a WebI report, I am facing the problem if it is in a DeskI report and try to refresh the report through Infoview.

Is it any service pack issue ? I have BO XIR2 with SP2.

santhano :india: (BOB member since 2004-10-12)