Skip to Content
author's profile photo Former Member
Former Member

SAP BO Analysis : Why macros?

Hello Experts,

I was doing my hands on for SAP BO Analysis tool -Office Edition, and I am analysing the practical usage of macros.

Let me give an example,

Scenario 1: We have filters section already in the Analysis tab , then why do we have SAPSetFilter macro. The same thing can be done directly by users by drag and drop.

Scenario 2: We can handle prompts and modify them directly from the analysis tab, then why do we have macros for same.

Please provide some real life scenarios where one cannot perform the above actions directly and have to go through some macro only.

Thanks in advance,

Richa

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jun 17, 2013 at 09:20 AM

    Regarding "Scenario 1: We have filters section already in the Analysis tab , then why do we have SAPSetFilter macro. The same thing can be done directly by users by drag and drop."

    Some companies do not want to expose the entire Analysis Ribbon to their customers. So they build macros to provide guided navigation

    Regards,

    Tammy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2013 at 10:24 AM

    Hi Richa,

    we use macros for automation of workbooks. We create a short overview mask in our first worksheet and an execute-button to start queries and save queries automatically on your local PC as PDF Files for example.

    The SAPSetFilter function for macros is absolutly a great thing to automatically execute the queries with different countries for example or with different sales divisions or something like that.

    If you do not need an automatic workbook it is sufficient to work without macro coding in my opinion.

    Best Regards,

    Benni

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 09:47 PM

    Many times a user needs to filter a large list of SKUs or POs that already exist in an Excel document. the experience and performance is much better for the user when I use SAPSETFILTER vs. asking the user to copy and paste into the filter natively since the filter pulls back all options available (50k SKUs in our case).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.