Shared Members

Shared member data can be included in a query, or their totals can be excluded. Each shared member column in the Results set corresponds to an Essbase Generation/Field in the Results set and query. For Shared Members, the parent context must exist in the query. In other words, if the parent of a shared member is not in the query, the Download to Results feature does not recognize that it is a shared member and determines the parent . That is, the parents of a shared member must exist in the query in order to determine that they are shared for the results set. For example, in the Sample Basic Product dimension, for the second instance of “100-20” (shared member) to be properly accounted for in the Download to Results, its parent “Diet” must be included in the query such as “Diet (Children)”.

Note:

Shared members are in bold below.

Table 60. Shared Members in CubeQuery Section

	Qtr1
100–10	5096
100–20	1359
100–30	593
100	7048
200–10	1697
200–20	2963
200–30	1153
200–40	908
200	6721
300–10	2544
300–20	690
300–30	2695
300	5929
400–10	2838
400–20	2283
400–30	–116
400	5005
100–20	1359
200–20	2963
300–30	2695
Diet	7017
Product	24703

Table 61. Shared Members in Results Set

Product SKU, Shared	Gen1, Product	Category	Product SKU	Quarter	Value
	Product	100	100–10	Qtr1	5096
	Product	100	100–20	Qtr1	1359
	Product	100	100–30	Qtr1	593
	Product	200	200–10	Qtr1	1697
	Product	200	200–20	Qtr1	2963
	Product	200	200–30	Qtr1	1153
	Product	200	200–40	Qtr1	908
	Product	300	300–10	Qtr1	2544
	Product	300	300–20	Qtr1	690
	Product	300	300–30	Qtr1	2695
	Product	400	400–10	Qtr1	2838
	Product	400	400–20	Qtr1	2283
	Product	400	400–30	Qtr1	–116
100–20	Product	Diet	100–20	Qtr1	1359
200–20	Product	Diet	200–20	Qtr1	2963
300–30	Product	Diet	300–30	Qtr1	2695

If multiple generation dimensions have shared members, one “shared” indication per dimension is created:

Note:

Shared members are in bold below.

Table 62. Multiple Dimensions with Shared Members in CubeQuery Section

		Qtr1
Actual	100–10	5096
	100–20	1359
	100	7048
	100–20	1359
	Diet	7017
Budget	100–10	6510
	100–20	2240
	100	9790
	100–20	2240
	100	9790
	100–20	2240
	Diet	8910
Actual	100–10	5096
	100–20	1359
	100	7048
	100–20	1359
	Diet	7017

Table 63. Multiple Dimensions with Shared Members in Results set

Scenario, Gen2, Shared	Scenario, Gen2	Product SKU, Shared	Category	Product SKU	Quarter	Value
	Actual		100	100–10	Qtr1	5096
	Actual		100	100–20	Qtr1	1359
	Actual	100–20	Diet	100–20	Qtr1	1359
	Budget		100	100–10	Qtr1	6510
	Budget		100	100–20	Qtr1	2240
	Budget	100–20	Diet	100–20	Qtr1	2240
Actual	Actual		100	100–10	Qtr1	5096
Actual	Actual		100	100–20	Qtr1	1359
Actual	Actual	100–20	Diet	100–20	Qtr1	1359

If a dimension contains shared members at multiple generations, a column is added to the Results set for each CubeQuery generation and Results set column:

Note:

Shared members are in bold below.

Table 64. Shared Members At Multiple Generation Level in the CubeQuery Section

	Qtr1
100–10	5096
100–20	1359
100–30	593
100	7048
...
400–10	2838
400–20	2283
400–30	–116
400	5005
100–20	1359
200–20	2963
300–30	2695
Diet	7017
400	5005
Product	24703

Table 65. Shared Members at Multiple Generation Level in the Results Set

Category, Shared	Product SKU, Shared	Gen1, Product	Category	Product SKU	Quarter	Value
		Product	100	100–10	Qtr1	5096
		Product	100	100–20	Qtr1	1359
		Product	100	100–30	Qtr1	593
...
		Product	400	400–10	Qtr1	2838
		Product	400	400–20	Qtr1	2283
		Product	400	400–30	Qtr1	–116
	100–20	Product	Diet	100–20	Qtr1	1359
	200–20	Product	Diet	200–20	Qtr1	2963
	300–30	Product	Diet	300–30	Qtr1	2695
400		Product	400		Qtr1	5005