Lets say I have two nodes at the top of a GLAccounts DIM
(There is no 'All' level). For one of the nodes
called "Balance" I need the measure "Total" to display
an "accumulated total" for this years "Total" and all
previous years total for current memeber. So in essence
when you are looking at the total for 2003 it is really
comprised of all dates before it.

The second node in the tree is fine using the unary
operators I have specified and rolling up as normal.

Any ideas?

-mike

Hi Michael,

Thanks for your post. According to the description, I am not quiet clear
the detailed situation on your side. As I understand, it seems that you
want to create conditional expressions, if I have misunderstood, please
feel free to let me know. Conditional expressions that return different
information depending upon a decision made in the calculated member based
on the existence of a condition.

For more information regarding this issue, please refer to the following
article on SQL Server Books Online.
Topic: "Conditional Expressions"

Does it meet your requirements? If not, please let me know your accurate
concern in detail. It is best to provide the screen shot of the data view
to help describe your requirements.

Try to obtain the screen shot.

1. Press the "Pr Scrn" button on the keyboard.
2. Run the Paint tools (Start'All programs'Accessories'Paint).
3. Press Ctrl+V to copy the screen shot from the memory.
4. Save as a JPEG file.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

The calcuated measure I am looking for is something like this...

IIF(were are in this part of the tree,
Sum({[Date].Siblings},[Measures].[Total]), Sum([Measures].[Total])
Siblings also needs to be replaced with only those years that is the current
on all prior. So I think I need to use the lag function but how do I know
how many to go back?

-mike



"Michael Shao [MSFT]" <v-yshao (AT) online (DOT) microsoft.com> wrote

Hi Michael,

Thanks for your post. Please check and see if use PeriodsToDate function
meets the requirements on your side. The PeriodsToDate function returns a
set of periods (members) from a specified level starting with the first
period and ending with a specified member.

Syntax:

PeriodsToDate(["Level"[, "Member"]])

Example:

This expression returns the set of days from the beginning of Quarter3.
PeriodsToDate(Quarter,[05-Sep-1997])

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.