SAS Info Map - New Data Item

Reply
Contributor
Posts: 34

SAS Info Map - New Data Item

Hi There,

   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 ???

Dim_Year

Dim_Gender

Masure_Count

Thanks,

Prabakaran

Super User
Posts: 5,254

Re: SAS Info Map - New Data Item

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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 177 views
  • 0 likes
  • 2 in conversation