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
7 Answers, 1 is accepted
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

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
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

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
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

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
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