Viewing 6 posts - 4,081 through 4,087 (of 4,087 total)
Your CASE statement is fine. The problem is in your PIVOT statement. You have PIVOT
(
MAX(fldTCN)
FOR fldTCN IN ([1.1],[2.2],[3.3],[4.4])
) AS Pvt
This gives you the max of the field that...
July 26, 2009 at 9:37 am
I'm still learning MDX myself, so I'm not sure I can explain why it is necessary. I knew that you shouldn't be getting the exact same average for each...
July 24, 2009 at 7:00 pm
It looks like your trying to use the same attribute as the name for each of your four hierarchy levels. You're going to need a separate attribute for the...
July 24, 2009 at 6:33 pm
I came up with an even simpler solution. WITH
MEMBER AvgPerDay AS
Avg(
[Due Date].[Dim Time].Children * [Due Date].[Day Number Of Week].CurrentMember
, [Measures].[Fact Reseller...
July 23, 2009 at 3:36 pm
When you specify [TimeDim].[Date].[Date], you're resetting the context for your measure to all dates. You need to filter your dates in your member expression by the current day of...
July 23, 2009 at 3:33 pm
The user wants to be able to select all the orders that have :
1. FirstCode1 or First Code 2 or FirstSecondaryCode2 or SecondSecondaryCode15 or FinalCode20
Without really knowing the data, it...
July 21, 2009 at 2:20 pm
Viewing 6 posts - 4,081 through 4,087 (of 4,087 total)