on 09-06-2013 2:49 PM
Hi everyone,
I have posted some values in a input template and that value in successfully updated in backend. When I try to delete the same value which I posted previously I get an error 'There is no data to refresh'.
Kindly suggest me some solutions.
Thanks in advance,
Mohan
Hi all,
The issue is solved, actually in the Template's EVDRE formula there is a condition maintained. If the value comes as blank it will show this error. Now I have changed that and Its working fine.
Thank you all for your suggestions
Thanks,
Mohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohan,
There is a difference between blank and zero.
BPC behavior can be explained as below. Consider a particular intersection of dimensions.
a. If that intersection does not exist in the backend BPC excel will show blank (if suppress zero is not opted)
b. If that intersection has more than one record and sum of the records is zero then BPC excel will show zero (if suppress zero is not opted.
Deleting can be done in multiple ways.
1. If you are clearing data from back end (go to RSA1, Set planning not allowed, go to Deletion Selection and select the dimension values which need to be deleted) then the intersection will get cleared. This is the case of (a) explained above
2. If you use excel to delete you will have to enter 0 in the input template where you want to delete. Then backend will create an opposite sign entry. This is case (b) explained above
In the excel if you hit DELETE, the excel shows blank. Blank cannot be sent to server and then you will get an error 'there is no data to refresh'. You need to enter 0 rather than delete in the front end if you want to clear a value of an intersection.
Hope this helps
Udath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Udath,
The statement "In the excel if you hit DELETE, the excel shows blank. Blank cannot be sent to server and then you will get an error 'there is no data to refresh'. You need to enter 0 rather than delete in the front end if you want to clear a value of an intersection." is incorrect!
Just make test and you will see that clearing some value in the EVDRE will send zero to the cube.
Vadim
Hi Mohan,
You are talking about BPC 7.5? Please, ensure that you don't have #REF! errors in the EVDRE data range...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
yes, the current system in BPC 7.5 and there is no #REF! errors in the EVDRE data range. Actually now when I reduce a particular value or when I increase a particular value that is successfully updating.
But when I try to delete the value or if I give '0' for that. Its is not getting updated and when I click submit in the input template its saying the error 'There is no data to refresh'.
For e.g. There is a value 5000 for a customer, if I make it as 3000 (reducing) or 7000 (increasing) its successful. when I delete or give 0 its showing the error.
Regards,
Mohan Kumar M
Hi Mohan,
How r u trying to delete the values, using clear package, posting zeros against those account or from the backend?
If you are trying to delete them from backend, please ensure that the rquest ID is closed and only then you will be able to delete them.
Regards,
Kalyan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.