Extensibility Question

[vmanojrc30]

I have  a Summary & Detailed Account dimension. The Detailed Account dimension extends from Summary dimension.Ex

			Account Dimension
Cash			Summary
	A		Detailed
	B		Detailed
	C		Detailed

I have a Cube where I have set the Cube dimension Properties of a Scenario to use the Summary Account dimension. I was able to load the data at Cash account level as shown above.

However when I retrieve the data with BalSheet.Base , OS still treats A,B,C as base member instead of Cash and show up no balances. When I specifically identify A#Cash I get the balances I loaded.

Is this expected behavior that OS doesn't treat "Cash" as Base member from Summary Account Dimension? If so is there a solution to retrieve the Cash account as Base.

Thanks

Manoj

[JoakimK]

Not sure this is exactly what you are after, but it works. Try using this member filter:

A#BalSheet.Base.Where(MemberDim = SummaryDimensionName)

[SWilyums]

Try this as you member selection.

A#BalSheet.Base.options(cube=|WFcube|, scenariotype=Budget, MergeMembersFromReferencedCubes=False)

You may have to update the cube and scenario type.  The scenario type identifies the dimension used.