Skip to Content
author's profile photo Former Member
Former Member

Avoiding Refresh every time for filter bar selection ?

Hi Everyone,

I wanted to ask a question...don't know whether is it possible or not.

i have a report in web i,which i have published in launch pad. the report usually takes 50+ seconds to refresh (big report).The report have some dimensions on filter bar, now when ever i am selecting any values from the filter bars in order to filter it in the output...all the key figures needs #refresh ; making me to refresh the report again for 50+ seconds...is there any way it can be flexible enough so when i select any options from filter bar and the key figures should appear..?

Because i cannot forward it to my directors or managers as they will not wait 50+ seconds every time they are selecting any option from filter bar.

My BO version is 4.0 SP6.

Please Advise. 😊

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 07:35 PM

    Do you mean Input control when you mention filter bat?

    Please make sure you do not use database delegated measure rather use a regular aggregation with a valid project function defined in universe for the measure..

    This issue happens when the measures are defined as database delegated..

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 07, 2014 at 11:29 AM

    Hi Nayab ,

    I assume you are using the OLAP connections?

    if yes , can you check by adding the same objects in the filter in table .

    Check query stripping is enable ,if yes deactivate and check.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.