Hi Dan,

That worked. Thanks a lot. However we have another problem.

Here's our qury based on the query you sent.

/*

with set [first twelve] as head([Accounting Date].[Month].[Month].AllMembers, 12)

set[remaining] as except({[Accounting Date].[Month].[Month]},

[first twelve])

member [Accounting Date].[Month].[Remaining Months] as

Aggregate([remaining])

select {[Measures].[Procedure Charge Amt],

[Measures].[Transaction Amount],

[Measures].[Payment Trans Amount]

} ON COLUMNS,

non empty({

[first twelve], [Accounting Date].[Month].[Remaining Months]

--* [Procedures].[Billing Groups].[Billing Groups].ALLMEMBERS

}) on rows

from [VCube]

*/

Now I want to display the Billing Groups. See the last line commented.

When I tried to execute I am getting an error message "Dimensionality Exceded". Is this becuase of the way [first twelve] is declared?

Is there a workaround for this?

Thanks

Vishy