Problem with drill-down of ragged hierarchy

Question

 

Hi,

I created a cube with a  20 levels hierarchy. Some attributes don't reach all the levels. I set the HydeMemberIf property of the attributes of the hierarchy to noname.

I have a problem when i try to expande the members of hierarchy using the explorer of the Development studio or excel 2007:  everything works when the attribute has a child, but, when i reach the last child of the hierarchy, i still the expand character beside the description and when i try to expand it, the cpu usage of the server goes to 100% because of the analysis services.

What can I do?

Thanks

Giorgio

Answer 1

Yes, this is a known bug.

 

Microsoft cannot handle its own features.

 

If you use another browser such as Executive Viewer, you will see that it works anyway...

 

 

 

 

 

Answer 2

Hi, thank you for reply.

There is no solution to workaround this problem?

 

this is the error message that i have from BIDS after a long waiting:

 

 

===================================

Error Code = 0xC1000012, External Code = 0x00000000,  Note:  (Microsoft SQL Server 2005 Analysis Services)

------------------------------

   in Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
   in Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControlDataSource.OpenCellSet(String textOfCommand)
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControlDataSource.PopulateListWithNodesFromLevelUsingMDX(IList ilist, Int32 indexOfLevel, String mdxToGetMembers)
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControlDataSource.PopulateListWithNodesFromLevel(IList ilist, Int32 indexOfLevel, String uniqueNameOfParentMember)
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControlDataSource.PrepareExpandNode(TreeNode treeNode)
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControl.treeViewHierarchy_BeforeExpand(Object sender, TreeViewCancelEventArgs e)
   in System.Windows.Forms.TreeView.OnBeforeExpand(TreeViewCancelEventArgs e)
   in System.Windows.Forms.TreeView.TvnExpanding(NMTREEVIEW* nmtv)
   in System.Windows.Forms.TreeView.WmNotify(Message& m)
   in System.Windows.Forms.TreeView.WndProc(Message& m)
   in Microsoft.DataWarehouse.Controls.MultiSelectTreeView.WndProc(Message& m)
   in Microsoft.AnalysisServices.Browse.DimensionBrowserControl.DimensionHierarchyTreeView.WndProc(Message& m)

 

Answer 3

this is my source table...

 

--------------------------------------------------------------------------------------------

FIELD0 FIELD1   FIELD2     FIELD3    FIELD4 ... FIELD20

A0          A01        A02         NULL      NULL      ... NULL

A0          B01        NULL       NULL      NULL      ... NULL

C0          C01        C02         C03        NULL      ... NULL

D0          NULL      NULL       NULL      NULL      ... NULL

------------------------------------------------------------------------------------- 

 

and this is what i'd like to obtain

 

A0

   |---A01

        |--A02

   |---B01

C0

   |---C01

        |---C02

             |--C03

D0

Answer 4

Using a parent-child structure will solve your problem, but this implies reviewing your table ...