on 02-22-2013 12:38 PM
Hello,
We have created webi report on BEx using BICS connection. We have Region and country input controls. Initial display of all the Key Figures coming from BEx are fine. But when we select few countries using inputcontrol then all KF's are displaying #TOREFRESH error then we need to refresh again.
Because of high volume data, report was taking long time to execute so we are scheduling report. But we need to refresh report again because of above error. So again it will take long time and no use of scheduling...
I know these are smart measures but any workaround for #TOREFRESH for KFs instead of refresh option????
Version using: BI4.0 SP4 Patch3.
Hi Suri,
In fact, "#TOREFRESH" is shown for measures whose values are calculated by the BEx datasource on which the Webi report is based when the measure has changed.
When an input control changes the data that needs to be shown, Webi is not able to display the data for those measures without going back to the BEx data source to get the updated value being shown in the measure.
An Enhancement Request about refreshing data automatically when "#TOREFRESH" has been posted in "Idea Place" .
The link for this is as follows: https://cw.sdn.sap.com/cw/ideas/4104
The title of the idea was "Provide option to automatically refresh data if "#TOREFRESH" is displayed". Since this is an idea for a future product enhancement, it is not something that is currently available for the Webi product.
In the comments for this thread, somebody had brought up input controls and "#TOREFRESH". and I noticed that a separate idea had been made for that. The link for that idea is as follows:
https://cw.sdn.sap.com/cw/ideas/9226
Otherwise I suggest that you follow the reply of sunil kumar.
Regards,
Amine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil kumar,
I am in bit confusion with your below comment in your post......
"""yes it is possible either using IDT or UDT in 4.0 on top of bex queries there you have to change the aggregation to sum instead of data base delegated"""
how can we create Universe on top of BEx query using IDT. Could you please provide some steps..
This was already discussed in many posts and confirmed that we can access BEx query only with BICS connection, but we can't create universe on BEx using IDT..
hi
sorry for above comments ,
1)You can create BICS connection in IDT and can be accessed directly using webi(no business layer ;It is said in docs that we can create BL in IDT but we cant)
2)we can connect to Bex Query Using UDT only !!
3)Using Jco connector we can create a Bex query universe in multi source enabled environment but it is not recommended it degrades your performance
And finally for your problem
you can create UDT unverse on top of bex and make the KF from Db delegated to Sum
Please close the thread if you found the answers to your questions
Regards
sunil
Hello Suri,
This issue is fixed with BO 4.0 SP4 and above for aggregation type SUM key figures. If you are concerned about performance of your report, you should go with BICS connection instead of OLAP universe or multi source enabled universe.
Using OLAP universes (created in UDT) is an old way and performance will not be good.
Check the link below about the differences of connections you can use in BO 4.0 and pros and cons ıf these connection types.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of directly using the KF in your report did you try using a formula instead SUM(KF)??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
there is a fix delivered in SP04 Patch 4.5 for the #torefresh message when scheduling a report, see following SAP Note:
1759831 - When a Webi report is scheduled to "PDF" or "Webi" format, some of the
information that is returned shows up in the resulting document as
"#TOREFRESH".
Best regards,
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Victor,
My issue is not related to scheduling.....
When we select few countries from inputcontrol then instead of aggregate and show the results for those countries it is displaying #TOREFRESH for all the measure coming from BEx.
So in above case, user needs to refresh again. I am looking for any workaround to avoid #TOREFRESH and avoid re refresh report....
Thank you...
Hi
#Torefresh error occurs when the key figures are database detlegated
what you have to do is
1) aggregate the key figures at bex query level by using sum function
or
2)install the latest sevice pack sp05
or
3) create universe on top of bex query and change the key figure database delegated to sum function and use this universe to develop reports
hope this helps u
Regards
sunil
Hi sunil,
By default it is sum only in Bex query level. Could you please specify where exactly we need to change it to sum in BEx?
Will it be resolved with SP5? I mean we have any document in which it was mentioned?
Hi Victor,
It is not clear to me about including different hidden tables. Could you please more specific in below scenario.
We have the data with KFs and object Category, We have input controls on Country. When we select few countries using input control Country then all the KFs are displaying #TOREFRESH. If we include Country and hide it then report data is not aggregating at Category level.
Hi Rakesh,
If we use SUM(KF) also no effect...
note: All KFs are Calculated and Restricted KFs
As an example start with an example by inserting ony two characteristics (Category, Country) and one key figure (KF1) in the webi query.
-Insert a table with category, KF1
-Insert Input Control on Category.
-Insert one table with category, country and KF1->hide it
-Insert one table with country and KF1->hide it
-Insert one table with category and KF1->hide it
-Can you use the input control now without seeing #torefresh?
Then post the results of your test.
hi
yes it is possible either using IDT or UDT in 4.0 on top of bex queries there you have to change the aggregation to sum instead of data base delegated
and for the service pack
one of the moderator says it is possible in sp4 FP3 so finaally if you are in latest patch level SP5 patch 4 some of the issues will be solved right ?
Hope this helps you
Regards
sunil
Hi,
unfortunately you cannot create a universe on top of a BEx query with IDT.
Auto-Refresh: The plan is to include this option in a future release, unfortunately you cannot use this today.
The screenshots shared above are from a time when this functionality was available for a short time:
http://scn.sap.com/message/13500951
Best regards,
Hi Victor,
I just tried with few objects but we do not have any issues with three objects (Country, Category, KF1) and it is working without #torefresh even if we use inputcontrol on country.
But I added one more dimension object 'Type' (which has two values) then it is displaying #torefresh with inputcontrol on country.
I followed all your steps but still it is displaying same..
In my scenario, when we execute report, KF is displaying fine with all 3 dimensions are in table. but it is displaying #torefresh with any combination of one dimension.
So initially, input control is selected 'All values' so I re refreshed report then all combinations are working fine. If we select 1 country then #torefresh displaying. Re refresh again.. now if you select any country... all combinations are working fine, but if you select all values then again #torefresh..
I am not sure if you can get away with this workaround using multiple input controls, you are welcomed to try with all possible characteristic combinations (if you are eager, you can take into account characteristic sorting order too).
Normally the answer to your question is a simple no: You cannot do all the filtering in the front-end side without hitting the database again.
Why? -> Because the definition of your key figures are inside the BEx query (Calculated and Restricted KF), not in the front end, so webi doesnt really know how to filter without the definition (e.g. Formula) done in BEx.
Best regards,
Victor
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.