Export Consolidated Data from SAP FC

[former_member591608]

I need to extract consolidated data from FC (10.1). However, I cannot find any information about this in the help files. Only CSV is mentioned but I would definitively prefer an integrated method.
Are there any application-level extraction methods that I can use? (ODP, ODBC, ...)

Thanks in advance!

[former_member219022]

Hi Justin,

Maybe you can try another EPM product named FIM and use FC as the source data store, then by adding mapping rules you will be able to export consolidation data to such as a database table with your customized column name.

Regards

[gael77]

Dear Justin,

you can create an SQL rule at the end of the consolidation, that plays the role of the half outbound interface. It can populate an SQL table or generate a csv file.

[olga_vasilieva]

Hello jsimi,
You can use FC Cube Designer for FC data export to OLAP cubes and/or star schemas.
Here's the link to the FC Cube Designer Help guide.

[former_member591608]

Thanks, but this is definitively no integrated method. Nothing I can use in a regular ETL process?

[adelaide_brunel]

Hi Justin,

You can also use Excel links or Web Excel links, in order to extract data directly in Excel.
Regards