This is a migrated thread and some comments may be shown as answers.

Showing rows/columns with empty cells

7 Answers 236 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Stephen
Top achievements
Rank 1
Stephen asked on 10 Nov 2016, 05:11 PM

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

Sort by
0
Kalin
Telerik team
answered on 14 Nov 2016, 09:42 AM
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!
0
Stephen
Top achievements
Rank 1
answered on 17 Nov 2016, 10:16 AM

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

0
Kalin
Telerik team
answered on 22 Nov 2016, 08:01 AM
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.
0
Stephen
Top achievements
Rank 1
answered on 22 Nov 2016, 11:47 AM

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

0
Kalin
Telerik team
answered on 23 Nov 2016, 04:54 PM
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.
0
Stephen
Top achievements
Rank 1
answered on 11 May 2017, 03:07 PM

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

0
Polya
Telerik team
answered on 16 May 2017, 08:12 AM
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.
Tags
PivotGrid
Asked by
Stephen
Top achievements
Rank 1
Answers by
Kalin
Telerik team
Stephen
Top achievements
Rank 1
Polya
Telerik team
Share this question
or