Refresh problem with mulitple layouts in input form

[Former Member]

Hi Friends,

Developed one input form(single worksheet), which consists of both opex model and capex model members(i.e. 2 connections)

I entered data in both layouts and saved it. Here no axis sharing.

Rows members are activities(Opex & capex) and columns members are time period(Jan 2014). WBS is user selection.

Based on user selection (wbs), both layouts data should be refreshed upon refresh option (default is "Refresh worksheet data").

Single time user selects(wbs), it updates both page axes(2 layouts) - WBS member.

Here when clicking refresh, it's refreshing only one layout where i kept cursor,but not second layout. If click again refresh, it updates second layout correcly eventhough my cursor is at first layout. Why this strange behaviour? How can i get refresh of both layouts in single refresh ?

while axes sharing (page axis & time ) and refreshing getting some exception errors. Configuration is BPC 10 NW SP15.

Regards,
Kumar

[former_member190501]

Hi,

Can you move WBS from Page axis to column axis and use EPMSelectMember for user to select WBS and refer this value to column axis of both forms.

Thanks,

Raju

[Former Member]

Refresh happening as per SAP help.

SAP help:

If you want to refresh the current report and if the current sheet contains several reports, select a

cell belonging to the report you want to refresh. If you want to refresh specific data cells, select them.

If the current sheet contains only one report, you do not need to select a cell. If the current sheet

contains several reports, and if you select a cell that does not belong to any report, the default report

will be refreshed.

[former_member186338]

Hi Kumar,

I have a single sheet workbook with 6 reports on this sheet using 4 connections to different models. Independent of the currently selected cell (in any report or outside of all reports) when I press EPM Ribbon Refresh button - all reports are refreshed because the default action of Refresh is Refresh Workbook.

All 6 reports have shared column axis with 3 dimensions (CATEGORY, MEASURE and TIME).

I am on BPC NW10 SP10 EPM - SP14

Vadim

[former_member186338]

Hi Kumar,

May be the issue is here: "while axes sharing (page axis & time ) and refreshing getting some exception errors." Please, provide more details about it.

Vadim

[former_member210696]

Hi Kumar,

You can create a refresh button and assign below macro to it -

Dim EPMobject As New FPMXLClient.EPMAddInAutomation

Sub Refresh()

        EPMobject.RefreshActiveWorkBook

End Sub

Remember to check the FPMXLClient under Tools -> Refrences on the VB editor.

Once you create this button, with one click all your reports will be refreshed on that workbook.

Hope it helps!!

[Former Member]

Ashish, thanks for reply.

Observed same behaviour with marco.