Case sensitive filter search RRS feed

  • Question

  • Hi,

    In SP2013 Performancepoint Services, I have multiple dashboards with filters and reports connected to Analysis service, both MD and Tabular. On the dashboards using the Tabular model, I can search the filters case insensitive. But on the filters connected to my MultiDimensional-model I have to get the case right to get hits.

    So I checked the AS-database: The Tabular was ASCI and MD was ASCS. So I tried changing the server collation for MD. Didn't work. Changed the dimension Collation with no luck and even the attribute used in the filter. But still it uses case sensitive for search. However, when querying using SSMS, I can use insensitive naming for the member in question.

    Is there any way to have the Performancepoint filter serach case insensitive. It CAN do it, proven by my Tabular model, but there is still something missing here.

    Ole-Jakob K

    Wednesday, September 10, 2014 7:12 AM