OK let me pose this question: Say one had a cube with a date dimension. How would one go about determining the min and max values in it? we have a internally developed OLAP application serving reports that we want to display the date range for available data. This is obviously very simple with relational data, but not easy in OLAP... -Eric
If your date hierarchy is ordered by the dates it is very easy -- there are lots of solutions, like Head( [date].[date].members, 1 ) and others like Date.[All].firstchild if the Date level is just below the All member and so on. Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Eric S" wrote in message news:1127234063.519483.152230@z14g2000cwz.googlegroups.com... > OK let me pose this question: > > Say one had a cube with a date dimension. How would one go about > determining the min and max values in it? > > > we have a internally developed OLAP application serving reports that we > want to display the date range for available data. This is obviously > very simple with relational data, but not easy in OLAP... > > > -Eric >
