tirsdag den 5. januar 2016

Date and Value Filter


To get the correct filters shown in reporting services powerview, make sure the attribute of the dimension has a ValueColumn set with a dataType that is matches the type of filter.e.g. a date value

or you can change the dataType directly on the keycolumn if the type is wrong (e.g. wChar and should have been date)

https://www.mssqltips.com/sqlservertip/3271/sql-server-analysis-server-ssas-keycolumn-vs-namecolumn-vs-valuecolumn/

Ingen kommentarer:

Send en kommentar