When a parent child hierarchy, which is essentially a unbalanced hierarchy is converted to level based hierarchy, it becomes a ragged hierarchy.
In the hierarchy, for many members, the parent members are not present in the immediate above level and we need to put placeholder members as parent in those levels. The HideMemberIf property of a level in a hierarchy is set appropriately to hide these placeholder or missing members from end users.
However, in the client applications, these placeholder members do not show properly as below:
The hierarchy in the client application can be displayed properly by using the MDX Compatibility property in the connection string the instance of Analysis Services which must be set to 2 to display ragged hierarchies correctly.
The MDX Compatibility property determines how placeholder members in a ragged or unbalanced hierarchy are treated. If you set the MDX Compatibility property value to 1, you expose a placeholder member in a ragged hierarchy.
Now the same hierarchy is displayed correctly:
Posts
6 comments:
It is certainly interesting for me to read this article. Thanx for it. I like such themes and everything connected to this matter. I definitely want to read more on that blog soon.
Can anyone recommend the best Managed Service program for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: [url=http://www.n-able.com] N-able N-central internet security software
[/url] ? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!
It is rather interesting for me to read the blog. Thanks for it. I like such topics and anything that is connected to this matter. I would like to read a bit more soon.
thanks !! very helpful post!
Brim over I acquiesce in but I about the brief should prepare more info then it has.
Ihre Phrase ist unvergleichlich...:) viagra ohne rezept aus deutschland cialis kaufen [url=http//t7-isis.org]viagra ohne rezept legal[/url]
Post a Comment