HI,

I want to aggregate some data on my time dimension.

I want have the result aggregate for day 1 and 2 and don't show any value of the day 3.

this is my cube:
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="allpromotions">
<Cube name="allpromotions">
<Table name="allpromotion"/>
<Dimension name="PROMOTIONS">
<Hierarchy name="DAYS" hasAll="false" allMemberName="all DAYS">
<Table name="allpromotion"/>
<Level name="days" table="allpromotion" column="days" uniqueMembers="true"/>
</Hierarchy>
<Hierarchy name="PROMOTIONS" hasAll="true" allMemberName="all PROMOTIONS">
<Table name="allpromotion"/>
<Level name="allpromotion.universe" table="allpromotion" column="universe" uniqueMembers="false"/>
<Level name="allpromotion.language" table="allpromotion" column="language" uniqueMembers="false"/>
<Level name="allpromotion.country" table="allpromotion" column="country" uniqueMembers="false"/>
<Level name="allpromotion.usertype" table="allpromotion" column="usertype" uniqueMembers="false"/>
<Level name="promotion-name" table="allpromotion" column="themessplit" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Measure name="nr-promotion-impressions" column="nrview" aggregator="sum" datatype="Numeric" formatString="#,##0"/>
<Measure name="name" column="themessplit" aggregator="max" datatype="String" formatString="#.##0"/>
<Measure name="universe" column="universe" aggregator="max" datatype="String" formatString="#.##0"/>
<Measure name="language" column="language" aggregator="max" datatype="String" formatString="#.##0"/>
<Measure name="country" column="country" aggregator="max" datatype="String" formatString="#.##0"/>
<Measure name="usertype" column="usertype" aggregator="max" datatype="String" formatString="#.##0"/>
</Cube>
</Schema>

My MDX query:
WITH MEMBER [PROMOTIONS.DAYS].[all good days] AS AGGREGATE ({[PROMOTIONS.DAYS].[01],[PROMOTIONS.DAYS].[02]})
SELECT
{TopCount(FILTER([PROMOTIONS.PROMOTIONS].MEMBERS,[PROMOTIONS.PROMOTIONS].CurrentMember.NAME<>'NULL' and [PROMOTIONS.PROMOTIONS].CurrentMember.level.NAME='promotion-name'),1000,[Measures].[nr-promotion-impressions])}ON ROWS , {[Measures].[name],[Measures].[nr-promotion-impressions],[Measures].[universe],[Measures].[language],[Measures].[usertype],[Measures].[country]} ON COLUMNS FROM allpromotions

this is working but i still have the value for the day 3.

the logical way and is what i saw on the forum will be to add WHERE ([PROMOTIONS.DAYS].[all good days]) but mondrian tell me that this query is illegal.

Can someone tell me what i am doing wrong?
Thanks........
AD