Parameters of a document taking long time in BI 4.2 sp2 patch 3

[Former Member]

Hi Everyone,

My requirement is to create a webi report based on the inputs provided by the user from the portal.

When I hit the rest service call to fetch prompts details using biprws/raylight/v1/documents/documents/<documentID>/parameters , it is taking some considerable amount of time

between 2 to 3 minutes .

Even when we hit the service url from postman , it is taking time.

Is there any way to improve the performance for this.

Thanks,

Nirmal

[daniel_paulsen · Accepted solution]

Hi Nirmalkumar,

The time taken is most likely due to the number of parameter values being fetched.  You can prevent this by adding ?lovInfo=false to the URL:

biprws/raylight/v1/documents/documents/<documentID>/parameters?lovInfo=false

Dan

[Former Member · Accepted solution]

It worked.Thanks Daniel