BPC Member Formulas Stored In BW

[former_member585302]

Hello,

Does anyone knows if the member formulas (Rules -> Member Formulas) created in the Administration console of BPC are stored in any table in BW? I would like to know the name of the table.

Thank you in advance.

Regards.

[former_member186338 · Accepted solution]

Easy solution:

Just create EPM report with ACCOUNT dimension in Row axis (with Filter by FORMULA property - not empty) and with local member like:

=EPMMemberProperty(,EPMDIM_CURRENT_MEMBER(ACCOUNT),"FORMULA")

You will get all member formulas for ACCOUNT dimension!

[former_member186338 · Accepted solution]

Sample:

Filter:

I have only single formula in ENVIRONMENTSHELL copy.

[former_member585302 · Accepted solution]

Thank you so much Vadim,

We will try with the report.

Kind Regards.

[former_member186338 · Accepted solution]

Then please accept the correct answer.

[SeerOfSig]

The member formulas are not stored in a traditional BPC table and are not meant to be human readable.

The solution proposed by Vadim is the recommended solution.

Regards,

Peter Kreutlein

[former_member585302]

Thank you Peter!

[former_member186338]

Sorry, but what do you want to achieve? What is the idea behind?

[former_member585302]

Hi Vadim,

The objective is knowing the name of the table(s) where the formula members are stored. We just would like to know if they are in BW anywhere or if they are just stored in BPC and we can't see them in BW.

Thank you

[former_member186338]

Look on RSA1 - FORMULA is an attribute...

Still not clear, what do you want to do...

[former_member585302]

Hello Vadim,

Yes, we have checked the attribute, but we can not see the list of formulas of each dimension in BW.

We want to know if it is possible to acceed the member formulas in BW because the user says that it could simplify maintenance.

Regards,

[former_member186338]

"We want to know if it is possible to acceed the member formulas in BW because the user says that it could simplify maintenance." -???

What do you mean by maintenance?

It's not possible to maintain BPC member formulas in BW! BPC dimension processing is required for each change in member formula.

[former_member585302]

Hello,

The objective is not maintenance in bpc, we will maintain the formula members in bpc as usual, but we want to know if we can extract them from a bw table in order to avoid its maintenance twice in another application.

Regards.