Showing rows/columns with empty cells

8 posts, 0 answers
  1. Stephen
    Stephen avatar
    11 posts
    Member since:
    Sep 2010

    Posted 10 Nov 2016 Link to this post

    Hi,

    I am trying to figure out how to show rows and/or columns in the PivotGrid whose cells are empty, so if I have a list of products from an OLAP cube selected, and there are no values for these products with the selected measure(s) - the grid returns no cells and no rows, so I only see the grand total line and nothing else. 

    I would prefer all the selected data to be returned. Most pivot grids have an option to toggle this on or off, but I can't seem to find how to do this on the PivotGrid. 

     

    Can someone please advise? 

     

    Thanks

  2. Kalin
    Admin
    Kalin avatar
    1261 posts

    Posted 14 Nov 2016 Link to this post

    Hello Stephen,

    Thank you for contacting us.

    Can you please share more details regarding the exact scenario you want to achieve? Can you provide a screenshots of our PivotGrid compared to another pivot control that behaves differently? Also is this supported by the pivot in excel, can you please check it? Can you demonstrate this behavior in our online demos (demos.telerik.com/wpf) and share the exact settings, so we can check it on our side.

    I'm looking forward to hearing from you.

    Regards,
    Kalin
    Telerik by Progress
    Do you need help with upgrading your WPF project? Try the Telerik API Analyzer and share your thoughts!
  3. Stephen
    Stephen avatar
    11 posts
    Member since:
    Sep 2010

    Posted 17 Nov 2016 in reply to Kalin Link to this post

    Hi Kalin, 

     

    Please find the screenshots attached. They show the RadPivotGrid with rows that have data, then what happens when I select a measure with null values for all selections. I've also added screenshots using an Excel pivot grid OLAP connection, with the same output, i.e. one with data, and one without data. 

    There is also a screenshot of the selection in the Excel PivotGrid that allows you to enable showing empty rows or columns, and how it looks once it has been selected. 

     

    Hope that helps. 

     

    Thanks,

    Stephen

  4. Kalin
    Admin
    Kalin avatar
    1261 posts

    Posted 22 Nov 2016 Link to this post

    Hello Stephen,

    Thanks for the details. However we will need some more time in order to investigate the scenario.

    Will get back to you as soon as possible.

    Regards,
    Kalin
    Telerik by Progress
    Telerik UI for WPF is ready for Visual Studio 2017 RC! Learn more.
  5. Stephen
    Stephen avatar
    11 posts
    Member since:
    Sep 2010

    Posted 22 Nov 2016 in reply to Kalin Link to this post

    Hi Kalin, 

     

    I look forward to your response once you've had time to examine it. 

     

    Could you please open up a support ticket for this issue and add nemanja@pyramidsoftware.co.za as a cc to the issue so that we can be fully up to date when you do have a proper look at it? 

     

    Thanks,

    Stephen

  6. Kalin
    Admin
    Kalin avatar
    1261 posts

    Posted 23 Nov 2016 Link to this post

    Hello Stephen,

    Actually this is a feature that is available for the other providers and we already have it logged in our Feedback portal as a Feature Request. You can vote for it and track its status on the following link:
    https://feedback.telerik.com/Project/143/Feedback/Details/201206-pivotgrid-add-options-for-showing-items-with-no-data-when-using-olap-data-provid

    If you have any other questions or concerns, please let us know.

    Regards,
    Kalin
    Telerik by Progress
    Telerik UI for WPF is ready for Visual Studio 2017 RC! Learn more.
  7. Stephen
    Stephen avatar
    11 posts
    Member since:
    Sep 2010

    Posted 11 May in reply to Kalin Link to this post

    Hi,

    We have encountered a bug in the pivot grid control that relates to this issue. 

    When we select 2 measures from an OLAP cube, set against the column area, and a list of items (stores in our case) on the rows, and one of the measures has only empty values, the results returned are completely incorrect. In our example, we select sales and stock for a list of stores (with a time filter set in the report filter). We only need to see the overall results by store on the columns, and the store names in the rows. 

    If you look at the attached files, the results, in the format we'd expect to see them are shown in the 'incorrect' screenshot, i.e. they all just show the number '6'. I did a SQL Profiler trace on the MDX being generated by the pivot grid and ran it in SSMS manually to see what we get - see MDX query screenshot. Those values were exactly right, but bore no relation to the data shown in the first screenshot. 

    I did notice however, that the grand totals in the first query were showing correctly, so I changed the pivot grid selection to add a time bucket above the measures in the columns section (so that we can get grand totals on the columns) and the results came back correctly. See respective attachment. 

     

    I can see why this is a problem, as the pivot grid is expecting to get back values for two measures, but is only getting one, thanks to the NON EMPTY directive in the MDX query. The problem is that this doesn't currently seem to be allowed. 

     

    Can you please raise a support ticket for this issue as this is a bug? 

     

    Thanks,

    Stephen

  8. Polya
    Admin
    Polya avatar
    227 posts

    Posted 16 May Link to this post

    Hello Stepthen,

    Indeed, there is an issue in the data displayed when a measure with only empty values is added in the Aggregate descriptions of the OlapDataProvider.
    We have this problem logged in our Feedback Portal where you can track its progress: https://feedback.telerik.com/Project/143/Feedback/Details/148256-pivotgrid-wrong-data-is-displayed-if-olap-measure-has-null-values-for-all-record

    Regards,
    Polya
    Telerik by Progress
    Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allow you to write beautiful native mobile apps using a single shared C# codebase.
Back to Top