Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Transaction Control inside a DataFlow Task

    Thanks Elliot!

    I staged the data first, like you recommended.

    Thanks again!

  • RE: Calculated Member using Member Properties

    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.

  • RE: Calculated Member using Member Properties

    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.

  • RE: Calculated Member using Member Properties

    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...

Viewing 4 posts - 1 through 4 (of 4 total)