Accessing SAP BO FC from Disclosure Management

[cf2]

Hi

Does anybody know how to access SAP BO FC data from SAP BO Disclosure Management?

SAP BO FC is not listed among possible DataSources within the Disclosure Management application.

Thanks for any hints.

Kind regards

Christoph

[Former Member]

Hi Riccardo,

Here are your options :

• Load manually data after having retreived manually data from BFC using Excel Links
• As Oscar said, using the 'report bundle' custom allows you to create tasks into BFC in order to generate Excel files. The downside of the report bundle is that it requires MS Excel to be installed on your BFC Application Server. => Use this if you are using  BFC 7.5 or if your BFC v10 application life cycle does not allow you to upgrade to BFC 10 SP10 or above right now.

        If you can't find where to download it, it should be located under (I guess):

        Software Downloads \ Analytics Solutions \ Installations and Upgrades - R \ SAP Raprid Deployment solutions \ SAP Solvency II Regulatory Reporting rapid deployment Solution

        Regardless if you find the download or not, I advise you ton contact you SAP Sales reprensative for the report bundle.

• As Folu said, use the native external link available since BFC 10 SP10.
  This feature is quite hard to configure if you want tu use ssl (it works in matter of minutes if you want to use standard http) but that is the feature you should use if this scenario is available for you.

Regards,

Matthieu

[former_member195154]

Hi Christoph,

The FC to DM feature was implemented in Financial Consolidation V10.0 SP10.

Please refer to the the User Guide for Financial Consolidation V10, updated for SP12 where it is described how to configure and use  FC to link to Disclosure Management.

Here are the sections referencing Disclosure Management  in the guide :

Page 11 / What’s new in Financial Consolidation 10.0 Support Package 10

• Page 68 / Section 3.10 : Configuring the General Options
• Pages 74-75 / Section 3.10.4 : Activating access to SAP Disclosure Management
• Pages 405 / Section 6.1.2.1.4 : Definition tab functions
• Pages 405-408 / Section 6.1.2.2.1 : Run Report Bundles
• Pages 524-525 / Section 6.3.9.6 : Functional profile rights for external links

***User guide can be found at SAP BusinessObjects Financial Consolidation 10.0 – SAP Help Portal Page - under Application help

Regards

Folu

[Former Member]

Hi Christoph,

The best way is probably to use the EPM Add-in (version 10) in MS Excel.

So you setup your report in Excel to retrieve your data from SAP BO FC using the Add-in. This Excel document can be uploaded to your Data Cache. Next time you open your Excel report from your Data Cache in DM and at the client side you (manualy) have to refresh your data using the EPM Add-in.

Server Side resfresh is not possible in this way...

There is another solution that comes with the SAP RDS SII solution. Part of this solution is a piece of software that needs to be installed on the SAP BO FC application server(s) and (fat) clients. This give you the possibility to export SAP BO FC reports defined in a report bundle using a Task. This task creates for each SAP BO FC report an Excel file. You can use this Excel file as a source in your DM Data Cache.

Hope this helps.

With regards,

Oscar

[riccardobettinelli]

Hi Oscar,

the Report Bundle Export Tool is not included in the standard release of Financial Consolidation so can you tell me where i can dowload it?

I search in SAP Service Marketplace but i don't find it.

Thanks a lot,

Riccardo