Viewing 4 posts - 1 through 4 (of 4 total)
Thanks Elliot!
I staged the data first, like you recommended.
Thanks again!
April 27, 2010 at 2:40 am
Thanks Steve and Dan!
I did what you guys told in the last two posts and it worked like a charm.
I owe the beer this time.
Thank you guys.
September 15, 2009 at 10:51 am
Dan, this is the query:
WITH MEMBER
[Event].[Events].[Category].&[PayRoll].[Test]
AS Aggregate({[Event].[Events].[Category].&[PayRoll].&[Social Enc. PayRoll - Enterprise]}) / ([Event].[Events].[Category].&[PayRoll].&[Social Enc. PayRoll - Co-Workers])
SELECT [Event].[Events].[Category].&[PayRoll].[Test] ON 0
FROM [DW Fator]
Thanks.
September 14, 2009 at 12:07 pm
Thanks for the replies, and thanks Dan for the advices.
My problem persists, though.
I tried the following:
[Event].[Events].[Category].&[Payroll].&[95]
And
[Event].[Events].Properties( "Cv Cod Eve" ) = [859]
And it gives me #VALUE# on the field.
Hope someone...
September 14, 2009 at 10:36 am
Viewing 4 posts - 1 through 4 (of 4 total)