exclude field in aggragation
Posted: Mon May 16, 2011 11:06 am
i everybody.
I have a problem to execute a MDX query.
I have a hierarchy Sector->Coil->Campaign and a mesure KPI4 for each Sector.
A coil is composed by 20 Sector, so I would to aggregate on Coil level, but excluding the first and last Sector of each coil (i.e.
number 1 and 20)
What is the right MDX query?
regards
nico
I have a problem to execute a MDX query.
I have a hierarchy Sector->Coil->Campaign and a mesure KPI4 for each Sector.
A coil is composed by 20 Sector, so I would to aggregate on Coil level, but excluding the first and last Sector of each coil (i.e.
number 1 and 20)
What is the right MDX query?
regards
nico