Skip to Content
author's profile photo Former Member
Former Member

There is no data to refresh error BPC

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2013 at 03:17 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 08, 2013 at 09:04 PM

    Hi Mohan,

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

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2013 at 03:47 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2013 at 04:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.