Thanks,

Unfortunately the DW was implemented prior to our engagement with the customer, and some of the table designs / schemas are very questionable and not clear as to their intention....

Hi,

What are the specs of your machine? I've found that by 'nesting' more and more dimensions next to another, memory usage increases. By starting off with one dimension on rows...

Hi,

I found that using the following in the calculated cell works very well:

([Report Section].[Module].&[CASHFLOW], [Measures].[Amt],parallelperiod(month))

Parallelperiod finds the current member of the time dimension, and in this case (month) looks at...

Thanks Keith,

I've tried this syntax in AS on the calculated cell:

with

member measures.Amt as ' sum( { PeriodsToDate(Time.Year, Time.Month.currentmember) } , measures.currentmember ) '

select { [measures].measureslevel.allmembers } on columns,

{ [Time].[Month].members }...

Thanks,

Seems Excel is the more flexible frontend (compared to Crystal Analysis that the customer is using). Any ideas on speeding up the OLAP query that runs or reduce the amount...