|
Home > Archive > MS SQL Server OLAP > January 2006 > Balance First day of year
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Balance First day of year
|
|
| john.r.carter@bankofamerica.com 2006-01-26, 4:58 pm |
| Does anyone know how to get the value of a measure from the first day
of every year.
I tried the mdx query below, however I get the opening balance for 2006
for every year. What I would like is the opening balance for every year
I have in my time dimension.
(openingperiod([Day],[2006]), [Measures].[Net Front End Cash Fee Amt])
Thanks,
John C
| |
| Deepak Puri 2006-01-26, 4:58 pm |
| Hi John,
You didn't describe the time hierarchy, but maybe:
[color=darkred]
(OpeningPeriod([Day],
Ancestor([Time].CurrentMember, [Time].[Year])),
[Measures].[Net Front End Cash Fee Amt])[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|