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

Can a Shared member point to a Never Share Member?

in Financial Consolidation and Close 1 comment

General question: If I have a Shared member, which points at a base level member with data storage Never Share, will this cause me issues?

In my Entity dimension, all the bottom-level members have data storage of Never Share (I'm not sure why, this was set up at implementation). I have a primary entity hierarchy and a secondary entity hierarchy. In the secondary entity hierarchy, there are Shared members, which are all pointing at the base level Never Share members in the primary hierarchy.

I am comparing the values I get when I pull data from [Primary].[100] versus from [Secondary].[100]. The POV for all other dimensions is the same. The values I am getting are not the same. I am wondering if this is because the Shared members are pointing at Never Share members. Will this prevent the data from flowing to the Shared Member?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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