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?

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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