Dimension Context refresh

[Former Member]

Hi BPC Experts,

I've got one challenge.

In my workbook, i've got two sheets for example:

1- Sales (Sales Model)

2- PNL (PNL model)

(The user have access multiple Entitys, and the entity dimension is secure in both model in same level)

When I create my BPF, I have to select only one MODEL for example, I select the SALES.

after whole configurations.

when the user  open through BPF the EPM template

it shows SALES the correct entity selected based in BPF Contaxt

but the PNL it is showing one another (where the EPM is saved, or randmomwise)

How can I solve this? maybe in BPF is missing something..

(I've got one workaround, in PNL sheet, set the Entity as Page axis Shared, and use the formula from Sales, it's works), but I would like to know if there is a standard solution for this.

Thanks

Regards,

[former_member186338 · Accepted solution]

To my mind, "use the formula from Sales" in P&L page axis is the right solution.

Vadim

[Former Member · Accepted solution]

Thanks Vadim,

There is any way to refresh the context based on that formula?

The reason why i'm asking that, its because I've got another workbooks where I'm using the DMP (of course it is based on Context)

Thanks

[former_member186338 · Accepted solution]

"I'm using the DMP (of course it is based on Context)" - what do you mean by "based on context?

[Former Member · Accepted solution]

yes yes

Sorry..

but, it is anyway to refresh the dimension?

THanks

[Former Member · Accepted solution]

I tried this logic

Dim epm As New FPMXLClient.EPMAddInAutomation

Sub change context()

Dim CONNE As String

CONNE = epm.GetActiveConnection(ActiveSheet)

'To set context

epm.SetContextMember CONNE, "CURRENCY", Range("A1")

'To refresh

epm.RefreshActiveWorkBook

End Sub

And It worked.

But, this only works once I put an Button.

I don't know where IN VB I can trigger the automatic like

Dim epm As New FPMXLClient.EPMAddInAutomation

Function AFTER_CONTEXTCHANGE()

Dim CONNE As String

CONNE = epm.GetActiveConnection(ActiveSheet)

'To set context

epm.SetContextMember CONNE, "CURRENCY", Range("A1")

End nFunctio

Where in VB I can write this code to it refresh automatically?

Thanks

[former_member186338 · Accepted solution]

What do you mean by "automatically"? After what event?

Have you tested event AFTER_WORKBOOK_OPEN?

Vadim

[Former Member · Accepted solution]

It is working fine.

thanks

I just did a small mistake.

With this logic I finalized.