You can query multiple SAP BW data sources within a report. SAP BW data sources can include InfoProviders, which provide unified access to all types of SAP BW objects. These objects include InfoCubes, ODS objects, Master Data Tables, InfoSets, and remote InfoCubes.
With SAP BW data sources, Financial Reporting provides direct access to aggregates, which are integrated views of data in an InfoCube. Aggregates make it possible to access InfoCube data quickly in reporting. Financial Reporting provides direct access to aggregates through an OLAP BAPI, which is a specialized interface for accessing SAP BW data through presentation tools.
Note: | The SAP-BW's BAPI driver does not allow you to issue an MDX query on any cube which has more than 50 characters. |
SSAS delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. Financial Reporting allows you to connect to a SSAS data source and produce financial reports. Considerations for SSAS:
CSS/Single sign-on is not supported.
SSAS does not support paging or cursoring. For example, if a parent node has one thousand children, and a user expands that node, one thousand are pushed to the client.
To log on against the SSAS data source, the domain name is required in the User Name field.
By default, when using SSAS 2000, any user can log on to the data source. To force a user to log on, set SSASImpersonate property to true in the in the JConsole.exe file. For information on JConsole, see the “Property Information” topic in the Oracle Hyperion Financial Reporting Workspace Administrator's Guide.