Skip to Content

Prompt LOV Load Issue


   I tried to create an fiscal period prompt at the universe level like condition on custom dimension obj like below in steps:

Universe prompt Fiscal Period LOV's:

After 2-3 mnts, I get the LOV populated for the prompt with count of members as below:

Slow prompt response on populating LOV's is the actual issue..

Is the time taken up when generating the list of values for the prompt  --- 2-3 Mnts

Can this be built with a 'SELECT DISTINCT' on the values in the underlying table

The custom object at business layer for fiscal month and year are If then else statements used..

This is an multisource having independent derived tables with each fiscal period object.



Capture.JPG (58.1 kB)
Capture.JPG (21.0 kB)
Capture.JPG (40.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 22, 2015 at 12:00 PM


    try with some optimization tips and see if performance improve.

    In the Business layer -> click on the Parameters tab and change the setting DISABLE_ARRAY_FETCH_SIZE_OPTIMIZATION from the default of "No", to "Yes" and click Ok.Export the universe and check the LOV's.

    In the BO client tools open the Data Federation Admin Tool and login on the system.Same server name  and user details which you are using to connect IDT.

    In the query monitoring tab check the run times of your query when you refreshing the LOV's or webi reports.See if some difference will come or not.

    You needs click on the refresh icon on the right side to see the latest query running status.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      click on the details icon and share the error message details.

      one qns is it mandatory requirement to display the Lov's and user should select from the list.if it is not working then might  you can go for manually enter the value in the prompt or search the particular value.

      like  *009* in the search.


  • Oct 26, 2015 at 04:59 PM

    Hi Din,

    I strongly believe that some of these complex logics shouldn't be created in the Universe, when DBA's can do this in a Date Dimension table. DBA' should have a Stored Procedure which populates the Period values in that column. So, you don't have to go through any of this hassle.

    Why don't you talk to your Manager first and let him talk to the DBAs?


    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded