10-16-2013 02:07 PM
I have CUBE with below mentioned Dimensions. Now i have to create a new Data item called "Max_Year" which should have the maximum YEAR(Dim_Year) value. I am not sure what to write in the Expression Window in SAS Information Map studio. I tried MAX function, it throws an ERROR saying that, MAX function requires more than one arguments??? Any thoughts how to create a new data item MAX_YEAR ???
10-16-2013 05:32 PM
I don't have info map studio at my fingertips right now, but it seems that you only can build expressions on row level - not defining aggregates.IIf you ciuld, how would you use it? An "ugly" work around could be to calculate it prior to loading the cube.