Good Afternoon, All!

I have created multiple Running Total calc. members in my cube (one for each
measure). The only difference between them is the actual measure that they
use. One uses Units (Units Running Total), another uses Profit (Profit
Running Total), etc. An example of one of them is listed below. Is there a
way to create these Running Totals using the SCOPE command/feature; thus,
eliminating the repetition?

Thanks in advance!

CREATE MEMBER CURRENTCUBE.MEASURES.[Units Running Total]
as
case
when [Time].[Time].currentmember.level.ordinal <= 1
then
SUM(periodstodate([Time].[Time].currentmember.level,[Time].[Time].currentmember),[MEASURES].[Units])
when [Time].[Time].currentmember.level.ordinal < 5
then

SUM(periodstodate([Time].[Time].currentmember.parent.level,[Time].[Time].currentmember),[MEASURES].[Units])
else

SUM(periodstodate([Time].[Time].currentmember.parent.parent.level,[Time].[Time].currentmember),[MEASURES].[Units])
end,
FORMAT_STRING = "#,#",
VISIBLE = 1
;

Why not try adding Time Intelligence (included with the Business
Intelligence Wizard):

http://msdn2.microsoft.com/en-us/library/ms175440.aspx
Wizard

The time intelligence enhancement is a cube enhancement that adds time
calculations (or time views) to a selected hierarchy. This enhancement
supports the following categories of calculations:

Period to date.

Period over period growth.

Moving averages.

Parallel period comparisons.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Thank you for your reply. I do have Time Intelligence already; however,
this is something different for the reporting purposes.

Thanks,
Paul

"Deepak Puri" wrote: