No results when running SPRUNELIM for Management Eliminations

[Former Member]

Greetings Experts,

I would greatly appreciate any thoghts on the following issue that I am having.

Running on BPC v7 for MS sp 5

One App/Web server, one Database Server

I have configured the application as follows:

1. Added ELIMACC property to Account DIM (checked INAPP flag)

2. Populated ELIMACC property with valid Account members (where I want the elimination to go)

3. Added ELIM property to Entity dimension (checked INAPP property)

4. Added Entity members as children of each parent member

5. Added u201CYu201D to the ELIM property of those Entity members

6. Added US Elimination Business Rules (identifying the Source DataSrc and Destination DataSrc u2013 Source is a parent, destination is a base level member)

7. Created a script to run the SPRUNELIM stored procedure

8. Mapped a DM package to that script

9. Executed the script

*RUN_STORED_PROCEDURE = SPRUNELIM( [%APP%], [%CATEGORY_SET%],[%TIME_SET%], [%CONSOLVIEW_SET%],'%SCOPETABLE%','%LOGTABLE%')

*COMMIT

Results:

1. Debug Log shows no records written (that appears to be a known issue with writing to the log, results should still be written to the database)

2. No records are written to the database.

Thanks in advance for your help!

Regards,

Craig

[Former Member]

Hi Craig,

You didn't mention whether or not the INTCO property was inserted in the Entity dimension. Please try adding that and applying it to whatever members are applicable.

Let us know if it works.

Regards,

Jason

[Former Member]

Hi Craig,

I would suggest you to do the following:

1. Add an IntCo type dimension if dont have it already and maintain it with the "ENTITY" property

2. Maintain currency type dimension with "REPORTING" property

3. Try using the following script

*INCLUDE SYSTEM_CONSTANTS.LGL

*SYSLIB ICELIMWITHCURR.LGL

*INITIALIZE_ELIM()

*ELIMINATE_ORG(H1)

*COMMIT

The above logic performs intercompany elimination without using business rules.

Hope this helps.

Regards,

Shoba

[Former Member]

Hi Shoba,

Thank you very much for your input. I forgot to add that I have an INTCO dimension and it is populated appropriately with "I_" members of the Entity dimension.

I know that I can use the traditional logic to accomplish what we are trying to do (useing the CPE function via ELIMINATE_ORG), but this client wants to leverage business rules in all cases.

Thank you again for your input!

Regards,

Craig

[Former Member]

Craig,

I'm not sure if you got it working, but I had some problems with the MonthNum property in the time dimension not updating in the member table. I just processed it again and things started working as expected.

Here's what I called in the logic file:

*RUN_STORED_PROCEDURE=SPRUNELIM([FINANCE],[%CATEGORY_SET%],[%TIME_SET%],[],[],[%LOGTABLE%],[%SCOPETABLE%])

Hope this helps all who may be struggling with using business rules for interco elims

Jason

407-283-7939

[former_member281223]

>

> Hi Craig,
> 
> I would suggest you to do the following:
> 
> 1. Add an IntCo type dimension if dont have it already and maintain it with the "ENTITY" property
> 2. Maintain currency type dimension with "REPORTING" property
> 3. Try using the following script
> 
> *INCLUDE SYSTEM_CONSTANTS.LGL
> *SYSLIB ICELIMWITHCURR.LGL
> 
> *INITIALIZE_ELIM()
> *ELIMINATE_ORG(H1)
> *COMMIT
> 
> The above logic performs intercompany elimination without using business rules. 
> 
> Hope this helps.
> 
> Regards,
> Shoba

Hi Shoba,

will you be able to give some information on the code of "ICELIMWITHCURR.LGL"? When I try to use this syslib, I got an error message saying that the mentioned file is missing.

Thanks for further information,

Sebastian

[Former Member]

Hi Sebastian,

This is delivered with BPC. It is available in

C:\BPC\Data\Webfolders\<AppSet>\SystemLibrary\Logic Library

If you are not able to find it in your AppSet, try checking for the same in ApShell. Copy the same and place it your application set (as per the path above).

Regards,

Shoba

[former_member281223]

Hi Shoba,

unfortunately I don not have this file. I searched the whole Server, but this file does not exist.

I recently send an OSS message to the SAP support to get the missing file.

Thanks for your reply,

Sebastian

[Former Member]

Hi Sebastian,

How did you figure out the solution.

I have a similar situation.. I've made sure all the prequisites are met.Yet the system does not calculate the eliminations..

Any help would be appreicated..