VBA local member formula

[Former Member]

Hi,

I am currently putting together a tool to document the templates in a BPC project.  BPC 10.1 NetWeaver with EPM add-in SP22 patch 1 or SP24 patch 1.

I would like to be able to extract information about the EPM reports using VBA API's.

In particular I would like to extract the local member formulas so that I can document them.

There is no obvious API available to do this.

The only API's that I have found can query the number of dimensions in the row and column axis.  Using GetRowAxisDimensionCount and GetColumnAxisDimensionCount.

Does anyone have any suggestions.

Thanks in advance,

Mark

[former_member186338 · Accepted solution]

Hi Mark,

Unfortunately EPM API is very limited and there is no functions/methods to extract the local member formulas.

You can get only:

Page/Row/Column axis members - GetXXXAxisMembers

Row/Column axis dimensions count - GetXXXAxisDimensionCount

and the info about report range...

Vadim

[Former Member · Accepted solution]

Dear Vadim,

Thanks for the information, you have confirmed what I thought, that what I want to do is impossible.

Regards,

Mark

[former_member186338 · Accepted solution]

You can decompile the EPM NET dll's and correct some code You will see a lot of interesting things...

Vadim

[Former Member · Accepted solution]

Do I understand you correctly, that you think that it could be possible to add my own API to do this if I decompile the code?

Cheers,

Mark

[former_member186338 · Accepted solution]

Not an easy job, but yes! Look here:

Vadim