Hi,

I am new to Analysis Services and I think my first
application is an odd one. What I have to do is show the
balance of different accounts at different time levels.
This might seem simple but the problem is that I have the
_actual balance_ and not all the transactions that get us
to that balance. This means that the actual balance that
the user should see is the balance one the last day of
the selected time level (e.g. last day of the month, last
day of the quarter, last day of the year, etc.). The
database has the actual balance for each day.

The final presentation of the cube will be through
PivotChart where you can drill into the Time dimension.
Can anyone please give me an idea of what I will need to
do (normal member, calculated member, etc.) to get this
number to change as the time dimension's level changes?
Any specific information will also be appreciated (MDX
example if applicable, etc.).

Thanks in advance!

Check ClosingPeriod function
something like
ClosingPeriod(Time.year,Time.currentmembere),[measures].[X])

"ASPnMSSQL" <anonymous (AT) discussions (DOT) microsoft.com> wrote

For other people, here is what the final expression ended
up like:

(ClosingPeriod([Time].[Day], [Time].CurrentMember),
[Measures].[Daily Balance])

I used Time.Day instead of Time.Year because I had a
daily balance instead of a yearly balance.



Thanks a lot Prasanna!!


$a401280a (AT) phx (DOT) gbl>...