Dimension Overrride with Two properties referencing Excel Cells

[Former Member]

Hi Gurus,

I'm using a Dimension override as the one below. It works fine. I can reference two properties and one of them is an Excel cell:

=EPMDimensionOverride(D31;"D_PO";"P_ALOC_NR=03 AND P_CTRY="&D3)

However, I would like to add some flexibility to the first property, too. I would like to also reference it to another Excel cell instead of hardcoding the value 03. I've been trying several commands but nothing seems to work.

Any clue? BPC NW 10.0 Add-in SP17

Thanks,

Alberto Sabate

[Former Member · Accepted solution]

Hi,

It does however work with the following instruction

=EPMDimensionOverride(D31;"D_PO";"P_ALOC_NR="&G11& " AND P_CTRY="&D3)

No need to place part of teh command in another cell.

Thanks,

Alberto

[former_member190501 · Accepted solution]

Hi,

Then what is  the issue?

[former_member186338 · Accepted solution]

I think the issue was due to leading zero of the property value P_ALOC_NR=03

Try "P_ALOC_NR=""03"" AND...

Or "P_ALOC_NR='03' AND...

Ups, sorry, the linked cell has to be formatted as text to accept 03 without conversion.

Vadim

[former_member190501]

Hi,

Try as follows :

Cell A1 ="P_ALOC_NR="&B1&" AND P_CTRY="&D3

=EPMDimensionOverride(D31;"D_PO";A1)

Hope it works..

regards,

Raju

[Former Member]

Hi Raju,

Thanks for your answer. I tried your approach and several variants based on that. Unfortunately, no override is taking place with such a formula.

Regards,

Alberto

[former_member190501]

Hi,

Its working in SP16 patch 01. I am not sure about SP17. You can try in SP16 patch 01 to just make sure is it related to version dependent or not.

Thanks,

Raju