Skip to Content

Formula on MEMBER Question

Hello Experts,

I have a dumb question. Is it possible on member fórmulas to include different Dimension?

I Ask because I have the next Formulas on member in dimension ZSTAGL, (ZSTAGL is User Defined Dimension):

The only formula that seems to be working is for OCCUPANCY since it makes reference to the same Dimesion ZSTAGL, the other 2 fórmulas that make reference to PF_CUENTAS (ACCOUNTS) and combine ZSTAGL are not working.

I am assuming that the formula is incorrect.

Am I right or is it possible to combine dimensions and I am missing something?

Thanks for the posts.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 30, 2017 at 05:39 PM

    It's possible but only if you have same dimensions (used in formula) for all models in the environment!

    If you have the model where you have not all dimensions you will be unable to save formula.

    Add comment
    10|10000 characters needed characters exceeded

    • Please provide dimension lists for all models!

      member formula is not for single model it's for all models in the particular environment (where the dimension with member formula is used)!

  • Jan 30, 2017 at 07:28 PM

    Ups, sorry! I see that you are able to validate dimension! It means the formulas are using allowed dimensions!

    But the formula calculation logic is strange!

    [PF_CUENTAS].[LODGING] / [ZSTAGL].[H_OCUP]

    You have to use tuple like:

    ([PF_CUENTAS].[LODGING],[ZSTAGL].[XXXX]) / [ZSTAGL].[H_OCUP]

    Add comment
    10|10000 characters needed characters exceeded

    • ZSTAGL according to customer Definition is quantity of rooms, depending the member, f16= Availableg, f17= Available per month, ADR= average rate, OCUP= real occupied/available, REV_PAR= Income/Room available (as if all rooms were in rental).

      The acconts are simulating a Income statement. last 3 dimensions of ZSTAGL are calculated in function of INCOME. well actually ADR and REV_PAR.

  • Jan 30, 2017 at 11:20 PM

    Ohhh... It is because those are BW dimension that they use to do other reporting. And I was asked to respect that structure. Those are dimension without currency,

    Add comment
    10|10000 characters needed characters exceeded

    • To my mind it's an incorrect design in general. Remove the ZSTAGLE dimension and add the members to

      PF_CUENTAS.

      P.S. Looks like a lot of customers add a lot of dimensions to the models and later unable to understand why BPC is so slow :)