on 09-19-2013 1:17 PM
Hi All,
PFA..Error Screenshot
For some of my reports am getting #To Refresh error in some columns(Measures)
1) when i click on Refresh button am not getting #To Refresh Error therefore am getting the values
2) when i Drag any objects in to report am getting the same error and similarly if i delete any column from the report am getting the same error.
Kindly help me to overcome from this error.
Thanks in Advance.
Thanks & Regards,
Bharatkumar V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check below thread:
https://scn.sap.com/thread/2075950
Here same issue has been discussed. Usually this error comes when measures have database delegated in universe.
Thanks,
Richa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
If you are having any Input controls, filter bars or Block filters drag the same object in to the layout, this will solve your issue.
Regards,
G.SaiNath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
Change the measure aggregation from database delegated to sum in universe
same problem comes with bics connection also.
Thanks,
G Sampath Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a result of the Measure Aggregation property set to "Delegated", which means that the measure value has to be computed by the datasource. As a result any drill down actions require the measure to be recomputed by the datasource resulting in #TOREFRESH which requires a manual refresh.
If you have generated a universe (.unv) from a BEx query, you can change the aggregation property in the generated universe.
For a BEx query based WEBI using BICS connection, I think key figures with Exception aggregation defined in BEx query might give you the same issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vineet,
I am having the same problem.
I changed the key figure properties and kept an exception aggregation on average.
And I can see #### Symbols in my report in webi,which is built on BICS connection.
Can I change the properties of my corresponding measure in webi?
When I go to that particular measure,its showing,number aggregation,and data base delegated.
but I want to change the object property to function sum,instead of data base delegated.
How can I do that?
Any help is highly appreciated.
Thanks.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.