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?
Quote from: dxwallace on 17 Mar 2008 09:16:33 AM
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 :)
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.
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