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.