BPC 7.5 to EPM 10 Migration - MNU_ETOOLS_EXPAND

[Former Member]

Dear Friends

I'm working in Migration project, migrating BPC7.5 templates to EPM10 migration. During Migration facing issues like

1. FPMXLClient.TechnicalCategory.GetResult|XXXXX|||||1|Invalid hierarchy for a member.#

What is this error mean, I searched lot in Google but didn't get solution

2. my BPC 7.5 "MNU_ETOOLS_EXPAND" (this is created as a button and assigned this macro) not working in EPM10, it says cannot find macro

3. MemberDefinition|FPMXLClient.Migration.EVDRE_Migration.MemberDefinitionReader.ReadMemberDefinition|XXXXX|||||1|An error occurred while reading member definitions:#

Regarding this type of errors is there any document to see what the error is

Please help me on point no. 2

Regards

luci

[former_member186338]

In general automatic template migration work correctly only for simple templates without macros etc... In most cases you have to recreate templates in BPC 10 from zero.

[Former Member]

Hi Klien,

For the 2nd point please refer to below threads.....MNU macro commands are no longer supported in 10 NW. Please use API's instead.

Using the API in EPM 10.0 NW BPC | SCN

For point 1 and 2...when do you get these type of errors?? Please explain...

Hope this helps....

Regards,

JP

[Former Member]

For more better understanding go through this link...

EPM Add-in Macros - Enterprise Performance Management - SCN Wiki

Regards,

JP

[Former Member]

Hi JP

Thanks a lot, the above link which shared by you is great. Refresh button and Save buttons are now working. I'm not sure how I need to put status as "helpful answer"

I wrote below code for REFRESH button in EPM10 version

Sub REFRESH_ON_CLICK()

Dim Refr As New FPMXLClient.EPMAddInAutomation

Refr.RefreshActiveSheet

End Sub

and the Refresh is working fine, Thanks a lot for help

Need one more clarification

In BPC 7.5 we have code FUNCTION AFTER_EXPAND()

but this code is not working after my Refresh done in EPM10, I put debug point here but the cursor not went inside the function. So I changed AFTER_EXPAND to FUNCTION AFTER_REFRESH and but debug point then cursor went inside the function, but in Application.Screenupdating = False here it came out not moving to forward

Function AFTER_EXPAND()

    Dim isProtected As Integer

    Application.ScreenUpdating = False

    Application.EnableEvents = False

    Application.Calculation = xlCalculationManual

......

......

......

End Function

Can I know reason why the code is not working.

Thank you

Regards

Luci

[Former Member]

Hi Klien,

refer to below thread

For the above error, I am not getting your point exactly....can you explain in detail the code???

Regards,

JP

[former_member186338]

Please post full function code, code posted is incorrect.

[Former Member]

Hi JP & Vadim

In 7.5 this code is working, but in EPM10 version this code is not working

Function AFTER_EXPAND(Argument As String)

    Dim isProtected As Integer

    Application.ScreenUpdating = False

    Application.EnableEvents = False

    Application.Calculation = xlCalculationManual

    isProtected = 0

    If ActiveSheet.ProtectContents = True Then

        ActiveSheet.Unprotect Password:="fibpc"

        isProtected = 1

    End If

    If Range("SHOW") = "N" Then

        Range("AZ:AZ").EntireColumn.Hidden = True

    Else

        Range("AZ:AZ").EntireColumn.Hidden = False

    End If

    If isProtected = 1 Then

        ActiveSheet.Protect Password:="fibpc", DrawingObjects:=True, Contents:=True, Scenarios:=True _

            , AllowFormattingColumns:=True, AllowFormattingRows:=False

    End If

    Application.ScreenUpdating = True

    Application.EnableEvents = True

    Application.Calculation = xlCalculationAutomatic

    AFTER_EXPAND = True

End Function

[Former Member]

I marked this discussion as question, so i'm not able to select "helpful answer"

[former_member186338]

AFTER_EXPAND is not supported for EPM reports. Please show the code you use in BPC 10.