Avoiding Refresh every time for filter bar selection ?

[Former Member]

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.  

[sateesh_kumar1]

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.

[Former Member]

Yes i am using OLAP connections.

Regarding query stripping..it is enabled and it is not allowing me to disable it. How can i be able to disable it ?

[Former Member]

Check if you have rights to change the property.

[sateesh_kumar1]

You need to uncheck query stripping in two places.

1.At webi query panel level . Edit query , properties ,uncheck query stripping

2.In documnet.Documnet properties , uncheck query stripping

[Former Member]

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..

[Former Member]

I will try defining the functions on measure from universe level.

I also came across one thread were the person have a solution for this issue as in 4.0 SP4, were he asked to refer a note, applying that note he got an option to avoid #refresh...i tried opening that note but is giving message that note not released yet...plus i checked in CMC > application > web i, that option to avoid refresh is not available...

http://scn.sap.com/thread/2147021

[Former Member]

Hi Nayab,

the auto-refresh feature available in BI 4.1 simply refreshes the document for you when needed, meaning that after your initial 50 seconds wait, another 50 seconds will come after a change of the filter.

I would rather not change the aggregation of key figures in the universe away from database delegated, while it seems to make the #torefresh go away, your data will probably not match anymore (as there is a reason why database delegated exist).

Best regards,

Victor

[Former Member]

Hi Victor,

as per your previous thread, you have mentioned that there is some note needs to be implemented, after which there will be an option were we can avoid #refresh thing. this scenario you have mentioned for BO4.0 SP4 ?

here is the link for your thread  http://scn.sap.com/thread/2147021

Also i tried opening that note..but the message displayed that it has not been released yet.

[Former Member]

Hi Nayab,

that auto-refresh option is not available anymore for BI4.0 SP04, it is only available for BI 4.1.

I have summarized all my knowledge about this topic in following document:

Read it carefully and check how can it help you.

Best regards,

Victor