SSAS Dimension Grouping -
i having problem trying group dimension year using ssas. first time me deploying cube. there way can group year rather seeing multiple lines of same year (please see attached image)
check keycolumn
property of attribute gl year
, if value of key equal, they'd automatically grouped. see in list namecolumn
property.
more info on msdn , on mssqltips.
update:
for keycolumns
property, msdn states:
contains column or columns represent key attribute, column in underlying relational table in data source view attribute bound.
this means whenever value of column(s) specified in property equal in underlying table number of rows, ssas treat these rows 1 member
.
in example, if have column glyear
in relational table , in keycolumns
property have specified same column, resultant list in screenshot have single value each year. hence, rows value 2015
combined form single member in list.
Comments
Post a Comment