none
OLAP - Weighted Allocation error RRS feed

  • Question

  • Hello!

    I would like to execute a what-if analysis in Excel OLAP cube. All functions work except when I enter into Weighted Allocation to

    iif ([Measures]. [FACT] = null, 0,

      [Measures]. [FACT]

         / Sum ([Measures]. [FACT]

           Axis (1). Item (0)

         ))

    If you do not use the Axis, it works:

    iif ([Measures]. [FACT] = null, 0,

      [Measures]. [FACT]

         / Sum ([Measures]. [FACT]

           [Condominium]. [Building]. Parent

         ))

    Then write an error message: The Following system error occurred: Invalid procedure call or argument

    Can you tell me how can I solve this problem?

    Thanks!!

    Wednesday, April 9, 2014 12:35 PM

All replies

  • Hi hodobee,

    as I know, we can't use Axis function in Update Cube script. Look at Axis function in detail. Correct me, if I'm wrong

    P.S. if you wanna check measure value for NULL, use IsEmpty function: 

    iif (IsEmpty([Measures].[FACT]), 0,
      [Measures]. [FACT]
         / Sum ([Measures].[FACT]
           [Condominium].[Building]. Parent
         ))
    Best regards.

    Wednesday, April 9, 2014 2:04 PM
  • Hi Aleksandr!

    Thanks for the reply.

    And you do not know that it could be another way to solve it, if you do not have to type the name of the dimension. I want to pick out any dimension, with the value recalculate on.

    Thursday, April 10, 2014 6:30 AM