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?