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.
| Author |
Topic |
|
bhushan_juare
Starting Member
45 Posts |
 Posted - 2011-09-09 : 12:02:10
|
| Hi Guys,I have designed a cube, Now I want to filter Dimension's data using Case statement. Here is the query written but i am getting an error"The following syntax error occurred during parsing: Invalid token"Query:With Member [Measures].[I/E]As Case [OMS Order 1].[Movement Type].[Movement Type].CurrentMember When [OMS Order 1].[Movement Type].&[PORT TO FTWZ] Then "Import" When [OMS Order 1].[Movement Type].&[FTWZ TO DTA] Then "Import" When [OMS Order 1].[Movement Type].&[DTA TO FTWZ] Then 'Export" When [OMS Order 1].[Movement Type].&[FTWZ TO PORT] Then "Export" Else "Null"EndSelect {[Measures].[I/E],[Measures].[Order Progress Dashboard Count]} on Columns,{[OMS Order 1].[Office].Members} on rowsfrom CubeI am not getting what went wrongThanks..... |
|
|
|
|
|
Case Statement for SSAS Dimension's using mdx