Skip to Content
Jun 28, 2016 at 12:09 PM

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