You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Delete data except shared member

Accepted answer
31
Views
3
Comments

Hello experts,

I have an account dimension (dense dimension) that I have a hierarchy with 1000 members, this hierarchy has shared members and store members.

I would like to know if I can do a FIX to delete data of this members EXCEPT "Shared members", just store members.

The code should be like this in FIX:

FIX (@RELATIVE("NetProfit", 0) -> Except shared members)

CLEARBLOCK ALL;

ENDFIX

Is it possible?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!