Online Tutorials & Training Materials | STechies.com
Register Login

Use ODBO with Planning & Consolidation for Microsoft

|| || 0

Use ODBO with Planning & Consolidation for Microsoft
Stechies

1. Explain the Features of the Planning and Consolidation OLAP cube which are visible to User?

Ans: Planning and Consolidation ODBO Provider exposes Planning and Consolidation applications, dimensions and attributes (properties) according to the OLE DB for OLAP (ODBO) standard (available at microsoft.com) to provide access to BPC meta data, master data, and transaction data. The Planning and Consolidation measure is also exposed.

The Planning and Consolidation terms 'Application Set', 'Application', 'Dimension', and 'Property' map to 'Catalog', 'Cube', 'Dimension', and 'Dimension Property' respectively when Planning and Consolidation is accessed via ODBO.

Planning and Consolidation supports both ODBO and XML for Analysis (XLMA).

2. What are the standards Planning and Consolidation Supports for Analysis?

Ans: Both ODBO and XML. Planning and Consolidation exposes both dimensions and properties. It is not possible to access Planning and Consolidation properties with BusinessObjects Enterprise 3.1.

3. Explain the syntax used to fetch data from the data source?

Ans: MDX is a frequently used method to obtain data from a data source; other ways as defined by ODBO specification or XMLA standard are also supported. However, if you run the Universe client to retrieve data through it, no Planning and Consolidation cube functions or syntax are required.

4. Explain the limitations of Planning and Consolidation ODBO?

Ans: Planning and Consolidation ODBO/XMLA do not support write-back.

5. How to use properties and dimensions in SAP BusinessObjects Web Intelligence?

Ans: Planning and Consolidation security is enforced by checking the connected user. In the case of WebI, the user in the Universe connection is used for Planning and Consolidation security checking. To access data from the Planning and Consolidation cube, you must assign the proper Planning and Consolidation member access profile and task profile .

Flexible member captioning (member description) is supported. In the member caption field, choose from Description only, Technical name only, Description - Technical name, or Description (Technical name). This option is maintained in Planning and Consolidation web admin.


Related Articles