There is no data to refresh error BPC

[Former Member]

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 

[Former Member]

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

[Former Member]

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

[former_member186338]

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

[former_member186338]

Hi Mohan,

You are talking about BPC 7.5? Please, ensure that you don't have #REF! errors in the EVDRE data range...

Vadim

[Former Member]

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

[Former Member]

Hi Mohan,

After updating the value in input schedule press F9 and then try to submit the value.

Regards,

Kalyan.

[former_member186338]

Please create a new input schedule (very simple!) and test this issue! Is it template related?

Vadim

[Former Member]

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.