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 |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2009-01-22 : 09:13:03
|
| Hi !I have a problem with defining descending order in the following sentencewith set [mivne_children] as order (filter(STRTOMEMBER(@DIMORGSTRUCTHierarchy, CONSTRAINED).children, ([Measures].[Actual] <> null or [Measures]. [Measures].[ParallelPeriod] <> null,[Measures].[PPeriodDiffAbs])member Mivne as [DIM ORG STRUCT].[Hierarchy 1].currentmember.nameSELECT { filter([mivne_children],[Measures].[Actual] <> null)} on rows,NON EMPTY { Mivne,[Measures].[ParallelPeriod2], [Measures].[PPeriodDiff],[Measures].[PPeriodDiffAbs], [Measures].[Actual] } ON COLUMNSDoes anybody have a solution? Thanks a lot |
|
|
|
|
|
Order descending