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

Write on a null cell

Hye Sirs.

I'm in BPC 7.0NW and I'm having severals problems in my scriptlogics about an issue and I would like to explain you using a simple example because I don´t find a solution.

I'm trying to do a simple Scriptlogic running by Package. The idea is to write on a amount in a null cell.

For example, I have 4 dimensions (ACCOUNT, TIME, CATEGORY and ENTITY) and I want to write 100 EUR.

My Script is similar than:

*XDIM_MEMBERSET ACCOUNT=6300

*XDIM_MEMBERSET TIME =2010.MAY

*XDIM_MEMBERSET CATEGORY=ACTUAL

*XDIM_MEMBERSET ENTITY=0001

*WHEN CATEGORY

*IS ACTUAL

*REC(EXPRESSION=100)

*ENDWHEN

*COMMIT

In my EVDRE, for this dimensions data, the amount is empty ( it's NULL, no Cero ).

,[2010.MAY],[ACTUAL],[0001] -

-


NULL

If I run my package with my logic and It was ok, It seems that the logics didn´t run and I refresh my EVDRE , I don't get the result in that cell.

However, If I write an amount in that cell (for example "1") before I execute muy package, and I execute it, I get the result correctly and If I refresh my EVDRE I can see "100" in this cell.

It's like BPC consider that the amount of that cell is empty, and It doesn´t execute over this dimesions combination.

Any solution?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 07, 2010 at 07:35 PM

    It could depend on what SP in NW 7.0 you are. SAP recently changed how such construction works and now default is based on Transaction data.

    To make it run on Master Data as you need it this example try putting

    *WHEN_REF_DATA=MASTER_DATA

    at the beginning of your script.

    Regards,

    Gersh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 08:24 AM

    Hye Gersh.

    I tried it and It doesn´t work. I'm in 7.0NW SP03

    *WHEN_REF_DATA=MASTER_DATA

    *XDIM_MEMBERSET ACCOUNT=6300

    *XDIM_MEMBERSET TIME =2010.MAY

    *XDIM_MEMBERSET CATEGORY=ACTUAL

    *XDIM_MEMBERSET ENTITY=0001

    *WHEN CATEGORY

    *IS ACTUAL

    *REC(EXPRESSION=100)

    *ENDWHEN

    *ENDWHEN

    *COMMIT

    Thanks for your help.

    any idea?

    Add a comment
    10|10000 characters needed characters exceeded

    • I think that the BPC NW WHEN/IS/*REC statement behavior with regards to null values went something like this:

      SP00 - SP03 -- Ignore null values

      SP04 - SP07 -- Calculate for null values

      SP08 and on -- Ignore null values but provide the override that Gersh mentioned

      On SP03, I don't believe there is any way to force calculation for null values. Your best bet is to run your WHEN/IS statement on a data intersection you know will have values and then update the intersection that is currently null.

      I believe MDX statements should work in SP03 and will calculate on null values as well, but they were very inefficient until SP05 or SP06, so you may run into some performance problems if you go this route without upgrading.

      Ethan

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.