When using Custom Table type filter that is connected to a Sharepoint list, the IsDefault setting fails.
The list contains a specific column for the default setting. I've tried with these data types:
- Yes/No (which translates to 1/0)
- Number (tested with 1/0 and -1/0)
- Text ("True"/"False")
The error appears in the filter as red text: "An unexpected error occurred. Error 30140. Additional details have been logged for your administrator."
I checked server events and found this:
"An unexpected error occurred. Error 30140.
Exception details:
System.InvalidCastException: Specified cast is not valid.
at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetFilterDisplayData(RepositoryLocation filterLocation, ParameterDefinition parameterDefinition, List`1 selections, Boolean useSavedUserSelections, Boolean selectionsOnly, WebPartContext
webPartContext)"
Seems like PPS can't create a boolean from the value.
- Edited by antruo Wednesday, March 26, 2014 8:32 AM