Where is the "Wide Member Tree" Property

[dxwallace]

in FM 8.2 I have modeled a Regular Dimension which has a certain level, UPC Numbers, and there about 14 million of them. If I try to drag and drop a UPC # in Analysis Studio, it goes on "Forever" and I have to cancel

FM Documentation says "If a hierarchy in a dimension contains a large number of members, running a query in one of the Cognos 8 studios may be slow because the Cognos 8 engine is generating one large query for a locally-built cube. To resolve this issue, set the Wide Member Tree property in the Properties pane to true. The engine will then generate multiple smaller queries for the locally-built cube."

However when I click on the Dimension and look at its properties, I don't see the Wide Member Tree Property. Can anyone tell me where it is?

[delight]

Can anyone tell me where it is?

Hello

Using "Project Viewer" Window you can see NameSpaces/DataSourses/Parameter Maps/Packages, so try to select the hierarchy of your regular dimension and look the "Properties" window.
The result must be as follows:

- Name
- Description
- Last Changed
- Screen Tip
- Balanced
- Ragged
- Root Business Key
- Parent Child
- Wide Member Tree                   :)

[rockytopmark]

Bigger situation is the design of your dimension.  14 million children from one parent?!?!  I suggest further modeling to add a level or 2 between the 14 million.  Your performance will not improve much, if any, with your Wide Member Tree setting change, since you have such a flat hierarchy.

[dxwallace]

The 14 million UPCs is only temporary in that I have yet to put the higher level hierarchies into the model. I did find the wide member tree option. I was clicking on the Dimension Name as opposed to the Hierarchy within the dimension to fins the property.

Thanks