BPC 10 NW: Macro AFTER_EXPAND

[Former Member]

Hi all,

I'm trying to trigger a macro when the user expand a node (double-click) in the hierarchy of the report. I thought that the event AFTER_EXPAND would have accomplished this scenario but the event isn't triggered.

This is the basic code:

Function AFTER_EXPAND()
Dim ps As New FPMXLClient.EPMAddInAutomation
ps.Refresh
AFTER_EXPAND = True
End Function

I can trigger the refresh event with BEFORE/AFTER_REFRESH.

Anyway my problem is this: I have created a local member with the function EPMRetrieveData and when I expand a node the function EPMRetrieveData for the just expanded members show #RFR:

and so I have to click on Refresh again which is pretty annoying. If I can put an auto-refresh in the macro after the user-triggered expand I can avoid the user-refresh.

Any suggestion ?

Thanks,

Michele

[former_member186338]

"I have created a local member with the function EPMRetrieveData" - do you think it's a good idea? The report will be slow...

Vadim

[Former Member]

Hi Vadim,

I have a requirement I don't know how to realize with the standard report features. I would like to use the dynamic hierarchy of the standard report with the EPMRetrieveData to retrieve the actual data.

Regards,

Michele

[former_member186338]

May be it's better to describe your report requirements... instead of doing something far from ideal

Vadim

[former_member186338]

P.S. By the way, AFTER_EXPAND is related to EVDRE expand coming from BPC 7.5 (please, read help!) Nothing to do with nodes Expand/Collapse!

[Former Member]

This is the requirement:

Basically I have a hierarchy on the account dimension and I have a property for the account which defines the type of the account (1 or 2). I have to create a report like the one in the image above: the problem is that the hierarchy and the property type are on the same dimension ACCOUNT and I have to put the hierarchy in the row dimension and on the column axis I should show the two types of the property and the totals of the nodes should be the total of the below base members filtered based on the column type.

So, as in the example, the amount on A2 account should be only in the column 2 and the Node 2 should display not the total of the 3 account (35) but 25 on column type 1 and 10 on column type 2.

Regards,

Michele

[former_member186338]

Hi Michele,

You have the problem with the account hierarchy design! Your property method will not work...

First - what do you want to achieve from the business point of view?

What I can see from the sample report is that you need an extra dimension with 2 members 1 and 2.

Vadim

[Former Member]

I cannot create another dimension with the elements 1 and 2.

I'm going to create two different hierarchy on the account dimension but I won't be able to use the dynamic hierarchy of a BPC report. So it would be a static one.

Michele

[former_member186338]

"I cannot create another dimension with the elements 1 and 2." - sorry, but this is the right way!

"I'm going to create two different hierarchy on the account dimension" - you will not be able to create report like you want: same node in different hierarchies is required to have the same children! You will have to use different nodes in different hierarchies...

Vadim

[Former Member]

About the second point: yes, of course I created different nodes in the 2 hierarchies. It works but now the real problem will be the maintenance of this kind of static report.

Michele

[former_member186338]

Yes, it's not a problem, it's a disaster

Try not to reinvent the wheel - use new dimension!