| shilpy 2005-11-28, 11:24 am |
| The problem In the below mentioned query that I am facing is that for the :
TimeEntryDate Dimension which is used in Nonemptycrossjoin and is a user
selection I have to display all the date entries for the period selected in
my result set along with what the user has selected. Which means that for
March 2003 selection my resultset should show:
Dates CNumber
March 2003 3/1/2003 1
3/2/2003 1
3/3/2003 etc. 5
WITH
MEMBER [Measures].[LFName] AS '[C].CurrentMember.Properties("LF")'
MEMBER [Measures].[CNumber] AS '[C].CurrentMember.Properties("CNumber")'
SELECT {
[Measures].[LFName],
[Measures].[CNumber],
[Measures].[X],
[Measures].[Y],
[Measures].[Z]
} ON COLUMNS,
& #123;NonEmptyCrossjo
in({[LFMember].[All LFMember].children},
& #123;NonEmptyCrossJo
in({[TimeEntryDate].[All TimeEntryDate].[2003].[Q1
2003].[March]},
{[Case].[All Case].Children}
)})}
ON ROWS
FROM Datamart
WHERE
([ID].[All ID].[10])
How is it possible to show the same dimension on two axis at a time. Even if
I create another time dimension and place it , have to relate it to the next
dimension on my resultset the CNumber Dimension because later i have to drill
down at CNumber level with respect to that date. and the time dimension has
no relation with the CNumber dimension.!
|