Skip to Content
0
Former Member
Dec 08, 2009 at 05:42 PM

No results when running SPRUNELIM for Management Eliminations

31 Views

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