Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Teemu
105
Showing only leaf level members of dimension hierarchies on rows and/or columns
posted

Hi,

Right now, if you select a few leaf level members from a dimension hierarchy, all the parent levels will get implicitly selected as well.

This will make the pivot grid show the information as follows:

As you can see, showing all the different levels of the hierarchy will consume a considerable amount of screen estate. Have you considered allowing users to view only the selected leaf level members in the grid?

One option would be hiding the unwanted levels from the grid. However, I'm not really happy with this approach as it means the generated MDX query still includes them and Analysis Services has to do some extra work.

Another option would be having flat hierarchies in the dimensions. This is not very practical for most dimensions. Navigating for example a date dimension with 10 years worth of dates would be extremely inconvenient.

I found a somewhat related post at Hide "All" section but unfortunately it didn't provide a definite solution for this problem either.

Parents
No Data
Reply
  • 138253
    Offline posted

    Hello,

    After some research, Showing only leaf level members of dimension hierarchies has been determined to be a new feature request.  I have sent your feature request directly to our product management team.  Our product team chooses new feature requests for development based on popular feedback from our customer base.  Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly. 

    We value your input, and our philosophy is to enhance our toolset based on customer feedback.  If your feature is chosen for development, you will be notified at that time.  Your reference number for this feature request is PI12030041. 

    If you would like to follow up on your feature request at a later point, you may contact Developer Support management via email.  Please include the reference number of your feature request in the subject and body of your email message.  You can reach Developer Support management through the following email address:  dsmanager@infragistics.com 

    Thank you for your request.

Children
No Data