Skip to Content

Dynamic reporting in Analysis for office

Hi All,

Has anyone had experience in creating a set of annual financial statements using Analysis for Office. We are using BPC (10.1 embedded) as the consolidation engine, but A40 fro reporting.

We'll have a potential 42 notes to report, but if it just a small dormant company, we'll only need 3-4 notes. Ideally we'd like to have one workbook with all the notes and then dynamically build the report depending on the company requirements.

There'll be a few paragraphs of commentary per note we'd also need to pull in.

Initially, we could keep all the queries as data sources in the workbook, but only to refresh and insert into the workbook if actually needed. I am hoping there are some more undocumented VBA api's methods we can use to insert a datasources as a crosstab into a sheet.

Otherwise, we'd need to populate an array and use that as the cross tab in the report.

Any ideas welcome, I may almost be re-building SAP Disclosure Management in BW using A40.

Many thanks


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 28, 2016 at 01:34 PM

    Hi Tim,

    i read your text twice and I still don't understand what you need or what you want to do. Maybe you can explain it a little bit more.

    Can't you select your data via a variable? You can also use VBA to set a variable.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Tim,

      We use AO for all of your listed reporting types. We found the crosstabs limited to the display our users would like and therefore we make extensive use of the SAPGetData formulas to present the data in the format they require.

      Some things to consider if you do go down this route is;

      • Performance - Depending on the number of SAPGetadata that are used in a workbook this can have a negative impact
      • Support - Adds an overhead on supporting the workbooks if things change on your queries this also depends on the level of reporting you have.
      • Scheduling - This is supported on the BO Platform but with a number of limitations that make this not an option for us.

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.