BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member (311528)

SYMPTOMS

When you view data associated with a custom member of a parent-child dimension, the cell values may display as "#Err". When you examine the cell properties of any of the custom members, you receive the following error message:

Infinite recursion detected during execution of calculated member.

CAUSE

This behavior is due to a stack overflow, which may occur when viewing custom members from a parent-child dimension with 15 or more levels where members at the lowest level contain a custom member formula that references a member at a higher level.

WORKAROUND

Use the Image Configuration Utility (ImageCfg.exe) that ships with the Microsoft Windows 2000 Resource Kit to increase the stack size that is allocated to Msmdsrv.exe.

WARNING: The Image Configuration Utility impacts the allocation of operating system memory. This tool may reduce the amount of memory available for critical operating system functions. Refer to your application documentation before using this tool.

NOTE: Some software application manufacturers configure their applications to use application memory tuning. Refer to your application documentation before using this tool.

MORE INFORMATION

Steps to Reproduce Behavior

Open Analysis Manager and select the FoodMart 2000 sample.
Edit the Account shared dimension.
Write-enable the dimension by setting the Write-Enable advanced property to true.
Enable Custom Members and select a new column named Custom_Members.
In Microsoft Access, open FoodMart 2000.mdb and then open the Account Table.

Add the following values:

account_id	account_parent	account_description	account_type	account_rollup
6000		Test	Income	+
6001	6000	Test 1	Income	+
6002	6001	Test 2	Income	+
6003	6002	Test 3	Income	+
6004	6003	Test 4	Income	+
6005	6004	Test 5	Income	+
6006	6005	Test 6	Income	+
6007	6006	Test 7	Income	+
6008	6007	Test 8	Income	+
6009	6008	Test 9	Income	+
6010	6009	Test 10	Income	+
6011	6010	Test 11	Income	+
6012	6011	Test 12	Income	+
6013	6012	Test 13	Income	+
6014	6013	Test 14	Income	+
6015	6014	Test 15	Income	+

Incrementally process the Account dimension.
Open the Budget cube for editing.
In the Cube Editor, right-click the Account dimension and click Browse. Drill down to member Test 15 and enter the following custom member formula "[ACCOUNT].&[5000]".
Save and browse the cube.
Examine the cell properties of any of the Test members.