Hello,
I have used the concept of "shared members" with Oracle Hyperion Essbase OLAP and wonder how I can apply this concept to SAS OLAP.
We have a dimension that contains bottom level members that occur under multiple levels and parents and their siblings. The concept of "shared members" means that the data values associated with a shared member comes from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once. To define a member as shared, an actual nonshared member of the same name must exist.
For example, the 100-20 member under 100 stores the data for that member. The 100-20 member under Diet points to that value.
Shared members typically are used to calculate the same member across multiple parents; for example, to calculate a Diet Cola member in both the 100 and Diet parents.
Is there a similar concept in SAS or would I have to ensure members have unique names and are hence stored multiple times in the cube?