Skip to Content

SAP BPC EPM Add-In. how to get security info about user using the API VBA in Excel?

Hi everyone! Is anybody knows how to get security info about user (like Team, Task Profile, Data Access Profile) using the API VBA in Excel? This info is needed to determine ability to push the button on a report sheet.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 03, 2017 at 09:47 AM

    The only way it can be done using write back badi:

    In write back badi you check for some specific dummy members intersection and reject the value with error message!

    In this error message you provide string with Team, profile etc... (define some format to parse later).

    Then you create extra worksheet with some input form that will write some value to the specific dummy members intersection.

    In VBA use:

    Option Explicit
    
    Public api As New FPMXLClient.EPMAddInAutomation
    Public submres() As FPMXLClient_OlapUtilities.SubmitResult 'Array!!!
    
    Public Sub SubmitData()
    Dim lngTemp As Long
    
    submres = api.SubmitWorkSheet(ThisWorkbook.Worksheets("Sheet1"))
    For lngTemp = 0 To UBound(submres)
        MsgBox CStr(submres(lngTemp).ErrorMessage)
    Next lngTemp
    End Sub

    ErrorMessage will contain required info!

    Don't forget to add references:

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 03, 2017 at 09:02 AM

    Unfortunately there is no way to get this info - no API provided.

    Add comment
    10|10000 characters needed characters exceeded