Member Formula. 255 characters limitation and Options file

[Former Member]

Hi SAP BPC experts,

We are facing an issue regardind a member formula that cannot be longer than 255 characters.

Once we are in this point we have two questions:

1. Is it possible to change the configuration (some application or application set parameter) in order to allow longer formulas?
2. Is it possible to work with longer formulas is we use the Options in the right side of the Member Formula screen.
   1. The file supports MDX syntax or is another different programming language?
   2. Where do we need to store the file and what name should we use?
   3. Is this file somehow related to the script logic files?

Best regards and thanks in advance

[Former Member · Accepted solution]

Hi Lauro,

What is the version SAP BPC?

What is the version Excel?

Regards

Gustavo

[Former Member · Accepted solution]

Hi Gustavo,

We are working on SAP BPC 10 Netweaver and Excel 2010.

I have read in other forum posts and it is not a limitation related with Excel, it seems to be a limitation related to SAP BPC.

Best Regards

[Former Member · Accepted solution]

Hi Lauro,

Have you seen this IDEA?

Increase max length of Member Formulas : View Idea

Regards

Gustavo

[former_member186338 · Accepted solution]

Hi Gustavo,

Unfortunately the MDXLIB approach works very unstable - simple formulas OK, complex - not working...

May be you know some magic ?

Vadim

[Former Member · Accepted solution]

Hi Vadim,

We have created our formula removing the ACCOUNT dimension name from the formula and 255 characters is not enough for us.

Is there any possibility to use the Options in the formula member in order to create a formula linger than 255 and the reference it in the member formula?

Thanks

[former_member186338 · Accepted solution]

Please, provide the formula to test...

Vadim

[former_member186338 · Accepted solution]

Hi Lauro,

I have done some tests with long formula and found that it's working in this case:

I have created text file CEDT.LGF with the following function inside:

*FUNCTION CEDT(%PE%)

IIF(%PE%=0,NULL,([2020202010723]+[2020202010722]+[2020202010721]+[2020202010720]+[2020202010719]+[2020202010718]+[2020202010717]+[2020202010716]+[2020202010715]+[2020202010714]+[2020202010713]+[2020202010712]+[2020202010711]+[2020202010710]+[2020202010709]+[2020202010708])/%PE%)

*ENDFUNCTION

I have used the same name for the file and for the function but it's not required.

I have uploaded this file using UJFS to the root\webfolders\sim\systemlibrary\logic library\cedt.lgf (sim - is the environment name).

Then, for the member EDTFRCOSTPEP I have created simple formula:

CEDT([PAGESEDT]);SOLVE_ORDER=10

Then - processed the dimension (If you change the uploaded file you need to reprocess the dimension - simulate change in formula, then save, then - reprocess)

And tested results in the Excel report.

Result: Calculations are Correct!

The resulting formula:

IIF([PAGESEDT]=0,NULL,([2020202010723]+[2020202010722]+[2020202010721]+[2020202010720]+[2020202010719]+[2020202010718]+[2020202010717]+[2020202010716]+[2020202010715]+[2020202010714]+[2020202010713]+[2020202010712]+[2020202010711]+[2020202010710]+[2020202010709]+[2020202010708])/[PAGESEDT]);SOLVE_ORDER=10

Text length - 306 chars!

B.R. Vadim

P.S. PAGESEDT and 20202020107XX - are members of ACCOUNT dimension - no dimension prefix.

Message was edited by: Vadim Kalinin P.S. Added

[Former Member · Accepted solution]

Vadim,

What is "PAGESEDT" in the above example? Is it a member?If so, How is it is related to the formula. All these "2020....." members relate to ""PAGESEDT"?

Is %PE% refer to "PAGESEDT"?

Please help.