I have a working( in cube editor) custom rollup formular that makes the
quarter total = the 1st month data of that quarter (instead of the sum of
the three month).
But when I use MDX query to select the data from the cube, the
quarter_total still equals the sum of the three month in that quarter, even
though the formular was saved in the cube. So I tried to add a modified
version of the formula in the MDX query, but still wouldn't work.

The formular that I used is as follows (this one works in the cube)
IIF (membertostr([Account].currentmember)="[Account].[Concept Desc].&
[Ending Backlog / Orders on Hand per Comar]", [Time]
..Currentmember.lastchild,
rollupchildren([Time].currentmember,"+"))

The MDX query that I wrote is like this, which is part of a crossjoin
statement:
{Filter({Descendants([Time].[All Time].[2005],[Time].[Quarter],self)}, IIF
(membertostr([Account].currentmember)="[Account].[Concept Desc].&[Ending
Backlog / Orders on Hand per Comar]", [Time].Currentmember.lastchild,
[Time].CurrentMember.Name ="Q1" ) )}

Any help will be greatly appreciated.

USDOLAP

--
Message posted via http://www.sqlmonster.com