SSAS Date Problem - 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 2008 Forums

Analysis Server and Reporting Services (2008)

SSAS Date Problem

Author

Topic

knichols
Starting Member

12 Posts

Posted - 2011-12-19 : 17:05:16

Hello All,

I am trying to use a StrToMember or anything that will let me get a date to work here is my code:


SELECT {[Measures].[Work Item Count]} on columns,
[Date].[Year - Month - Date Hierarchy] on rows 
FROM [Team System]
WHERE {[Date].[Date].[2011 12 10]:[Date].[Date].[2011 12 10]}
[code]

This snippet returns the following error:

Query (2, 1) The MDX function CURRENTMEMBER failed because current coordinate is empty. (Microsoft SQL Server 2008 Analysis Services)
.

This snippet of code 

[code]
SELECT {[Measures].[Work Item Count]} on columns,
[Date].[Year - Month - Date Hierarchy] on rows 
FROM [Team System]
WHERE (StrToMember("[Year].[Month].[Day]&[2011]")

Returns this error:

Parser: The end of the input was reached. (Microsoft SQL Server 2008 Analysis Services)

Can anyone clue me in? Our date formats are like this:

20111219

Hoping to get a quick answer.

Kurt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources