mdx: last column as ytd - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

mdx: last column as ytd

Author

Topic

influent
Constraint Violating Yak Guru

367 Posts

Posted - 2008-04-11 : 12:45:40

I'm trying to do something like this but it's not working:

SELECT
{
([Dim TimeOfferAccepted].[Year - MonthNumber].[Year_Text].&[2008].&[1]),
([Dim TimeOfferAccepted].[Year - MonthNumber].[Year_Text].&[2008].&[2]),
YTD(
AVG(
DESCENDANTS([Dim TimeOfferAccepted].[Year - MonthNumber].[Year_Text].&[2008])
)
)
}
ON COLUMNS,
NON EMPTY
{
[Dim Location].[Region Name].MEMBERS
}
ON ROWS
FROM
[Requisitions]
WHERE
[Measures].[Offer Accepted Date Count]

What I want it to return (instead of an error) is three columns (January, February, and YTD). Is it impossible?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources