Skip to Content
avatar image
Former Member

How i can set a Backgroundfilter in SAP BusinessObjects Analysis for Excel via VBA Macro

Dear Community,

i need to know how i can set a Background Filter in Analysis

See attached File.

Can somebody help me about this?

Regards

Andreas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 13, 2015 at 09:05 AM

    Hi Andreas Schilling,

    Please implement vba like below to move dimension to Background Filter

    Sub Button1_Click()


    Dim lResult As Long

    lResult = Application.Run("SAPMoveDimension", "DS_1", "Dimension Technical Name", "FILTER")

    End Sub

    Please have a look at help document about SAPMoveDimension

    Regards,

    Subhash


    Capture.PNG (35.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Andreas,

      the Problem is that "Factory Code" is not the technical name!

      You need to use the technical name of the Infoobject! "Input_String" is fine.

      Regards,

      Martin