Hi,
We have the problem that PivotGrid crashes when I click on the Filter button of an attribute in a hierarchy. We have a Product dimension that has an attribute hierarchy of Years, Quarters, Months, Days stating the products introduction date. Now for some products the datetime field in the database is empty since we do not have that information available.
Unfortunately, for the years, the PivotGrid converts the year null to 0 (instead of blank) and filtering on quarters or months crashes with a "Unable to cast object of type 'System.DBNull' to type 'System.String'" Exception.
Attached you'll find a backup of the demo cube.
Steps to Reproduce:
- Restore the Cube
- Drag the Amounts measure to the data area
- Drag the 'Date of Origin' attribute of the Products dimension to the rows area
--> year 'null' shows as 0 - Click on the quarters filter.
--> Exception
Actual Results:
"Unable to cast object of type 'System.DBNull' to type 'System.String'" Exception
Expected Results: - Null should show up blank or as the definition of property 'UnknownMemberName' as set on the dimension, but not 0
- There should not be an exception when trying to filter for quarters or months.
Here's the SQL 2005 database
And here's a screenshot of the problem
Hello Marcel,
As for the member captions, currently, you should handle the FieldValueDisplayText event to provide required display text. I've created a suggestion ID S31768 (OLAP - Add the capability to load member captions from the OLAP datasource and show them by default) that asks for the capability to retrieve member captions by default.
This bug is currently fixed.
Thanks,
Ivan