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

10|10000 characters needed characters exceeded

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

10|10000 characters needed characters exceeded
• Vadim Kalinin Sebastian Montero

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]

10|10000 characters needed characters exceeded
• Sebastian Montero Vadim Kalinin

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,