Delete members of dimension in Workforce

Delete members of dimension in Workforce

Joined: July 5th, 2012, 4:36 pm

July 5th, 2012, 4:37 pm #1

Is it possible to delete several members in an employee dimension in Workforce using a business rule from EAS?
Quote
Like
Share

Joined: April 4th, 2008, 8:06 pm

July 5th, 2012, 4:43 pm #2

Without using custom defined functions a business rule would have no way too delete metadata.

Even with a custom defined function this type of ability probably falls out side of "best practices".

This being said what is the end goal? Why are you trying to delete members from a business rule?

Regards,

John A. Booth
http://www.metavero.com
Quote
Like
Share

Anonymous
Anonymous

July 6th, 2012, 6:48 pm #3

currently trying to use this calc script from EAS......it runs successfully - but it does not clear the New Employees from the dimension......




SET UPDATECALC OFF;
SET CACHE HIGH;


FIX (Periods, Currency, Entity, Version, Scenario, Input_Region, Years, Accounts, @children("New Employees"))

CLEARBLOCK ALL;

ENDFIX
Quote
Share

Jake Turrell
Jake Turrell

July 6th, 2012, 7:30 pm #4

It looks like you're FIXing at the top of several dimensions. I would recommend including more specific members from these dimensions (or functions that include multiple members) in your FIX.

For example, don't fix on "Scenario". Instead fix on "Actual", or @IDESCENDANTS("Scenario");.

- Jake
Quote
Share

Jake Turrell
Jake Turrell

July 6th, 2012, 7:31 pm #5

And just to be clear . . . this will remove data from the new employees, but will not remove the new employees from the hierarchy. You probably knew that, but just in case . . .
Quote
Share


Confirmation of reply: