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

Problem with CALC_DUMMY_ORG

I can't get CALC_DUMMY_ORG to work on rollup members and I would like suggestions on how I can debug the problem.

My logic looks like this (thanks Joost). Note: DEPARTMENT is of type ENTITY:

*XDIM_MEMBERSET ACCOUNT=<ALL>
*XDIM_MEMBERSET DEPARTMENT=<ALL>
CALC_DUMMY_ORG ACCOUNT=PARENTH1
CALC_DUMMY_ORG DEPARTMENT=PARENTH1

*WHEN ACCOUNT
*IS #IncomeBeforeTaxes
*WHEN DEPARTMENT
*IS #AllDepartments
*REC(EXPRESSION=555,DEPARTMENT="99992", ACCOUNT="900000")
*ENDWHEN
*ENDWHEN
*COMMIT

Eventually the *REC expressions will be a *REC factor, but I am trying to keep it simple for now.

When I check DebugLogic.log there are lots of records in source data.

In the destination region there is 1 record, and I think that is correct.

Then the log describes:

5520 scanned records

5520 skipped records

0 processed records

0 records generated

If I replace the #memory rollups with leaf members, the logic works fine. It seems it is unable to locate #IncomeBeforeTaxes and #AllDepartments in the dataset. Those members are part of PARENTH1, but they have several layers of rollups below them.

Any suggestions on how I can figure where I am going wrong?

Thanks...Marv

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 08:17 PM

    I think you need a " * " before the CALC_DUMMY_ORG instruction, and I am not sure but you may need quotes around your calculated member *IS "#ACCOUNT"

    Is your logic validating?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I found an example of *CALC_DUMMY_ORG that I wrote for a customer, but in there I use

      *XDIM_MEMBERSET ACCOUNT <_> INVALID
      *XDIM_MEMBERSET ENTITY <_> INVALID

      Instead of =<ALL>

      Maybe that might help too! and I always use the double quotes both in the *WHEN *IS lines as well as in the *REC lines, so this should not be a problem.

      -Joost

      Edited by: Joost Hoppenbrouwers on Aug 12, 2008 11:03 PM

      I had to use <_> with underscore, but the real code is without underscore, but otherwise the forum makes it blank....

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 08:57 PM

    Marv,

    I believe *CALC_DUMMY_ORG is working also based on the ACCTYPE property of the Account dimension. Is this property filled correct for all the P&L accounts?

    -Joost

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 10:09 PM

    Joost --

    Thanks very much! It seems substituting <>INVALID for =<ALL> made all the difference.

    Note: I also had to add a *CALCULATE_DIFFERENCE 0 to make the code work. Possibly I should include NOADD to the REC statement?

    *CALCULATE_DIFFERENCE 0
    *XDIM_MEMBERSET ACCOUNT<>INVALID
    *XDIM_MEMBERSET DEPARTMENT<>INVALID
    *CALC_DUMMY_ORG ACCOUNT=PARENTH1
    *CALC_DUMMY_ORG DEPARTMENT=PARENTH1
     
    *WHEN ACCOUNT
    *IS "#IncomeBeforeTaxes"
    *WHEN DEPARTMENT
    *IS "#AllDepartments"
    *REC(EXPRESSION=555,DEPARTMENT="99992", ACCOUNT="900000")
    *ENDWHEN
    *ENDWHEN
    *COMMIT
    

    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.