Member Formula over 255 Char

[Former Member]

Based on one of Vadim Kalinin articles on Member Formula, I replicated similarly. But, I get strange error and need your help on it.

Below are some snapshots per the execution of Member formula (more than 255 char)

Member Formula Code:

Member Formula:

Error Message per the Member Formula:

Regards

Praveen

[former_member186338 · Accepted solution]

Please, provide the full formula!

Show your account dimension!

Start with something simple - create function for 2 members!

Vadim

P.S. Instead of sum by member formula it's better to create a second hierarchy!

[Former Member · Accepted solution]

Hi Vadim,

I cannot create Hierarchy as the number of these formula's are huge. If it was handful it would have been different. I could have either used A/C Classification or Hierarchy to handle it.

But given the amount of data, A/C ReClassification is out of question. Hierarchy, might be expensive as number of hierarchies would be more than 10 or 15..

In order to achieve this, I was planning to use a hybrid approach of using A/C Reclassification in few instances, couple of hierarchies and member formulae.

Attached is the image you requested:

Regards

Praveen.

[former_member186338 · Accepted solution]

Please show members 4122 and 4126 in the Account administration screen!

What is your BW and BPC version and SP?

Vadim

[former_member186338 · Accepted solution]

Other:

It's not a good idea to name function the same as member id...

First try: SBR_1000_TEST member - formula: [4122]+[4126]

Second fry different function name:

*FUNCTION SBR1000TEST

[4122]+[4126]

*ENDFUNCTION

SBR_1000_TEST member - formula: SBR1000TEST

[Former Member · Accepted solution]

Vadim

Here are the steps I performed.

1. Member Formula Validation:

2. Member Formula via File:

Function Used:

*FUNCTION SBR_1001TEST()

[4122] + [4126]

*ENDFUNCTION

[Former Member]

Hello Praveen,

The limitation problem related to the use of 255 characters in BPC Web Admin can be solved by the following SAP note: 2049535 - Remove length restriction of Member Formula.

Did you check it?

The correction instructions can be applied only for some BPC versions. I hope it can be applied in your case.

Regards,

Safa

[Former Member]

Hi Safa,

Unfortunately we are BPC 10.0 and no chance of upgrading to 10.1. Thats the reason, I was trying to use Vandim's Article and was stuck on it..

Regards

Praveen

[former_member186338]

Sorry, but BPC 10: 800 SP16 and 801 SP09 are covered by the mentioned note!

[Former Member]

Hi Praveen,

Can you provide the exact BPC version of your system? is it 800 or 801 and which SP level please?

Safa,

[Former Member]

Hi Safa

Here is the version:

CPMBPC

801

0005

SAPK-80105INCPMBPC

SAP_BW

740

0005

[Former Member]

Hi Praveen,

I see that the note can easily be applied in your system since it is valid for CPMBPC 801 begining from SP02 to SP08.

Regards,

Safa

[former_member186338]

As I already told you - upgrade to sp09.

Vadim