User manual BUSINESS OBJECTS FINANCIAL CONSOLIDATION 2010-12-09

[. . . ] Cube Designer User Guide SAP BusinessObjects Financial Consolidation, Cube Designer 10. 0 2010-12-09 Copyright © 2010 SAP AG. All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S. A. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] You chose the SSAS database server while creating the deployment and it is displayed in the General tab. All the languages chosen in the view will be available in the future cube, but a default language needs to be chosen in the deployment. In the data access group you belong to in SAP BusinessObjects Financial Consolidation, you might not be allowed to view all the children of a specific parent. You can choose which children the parent amount should take into account: · · · The parent amount is the sum of all its children, even those which you are not allowed to see. The parent amount is the sum of only the children you are allowed to see. In this case, you will leave the Enable Visual Totals option checked, as it is by default. · Choose a default number format. You choose the default number format that will be taken into account for the entire SSAS cube. You can choose a predefined format from the Measure Format drop-down menu or you can directly enter the format of your choice in the same menu. Note: The format is defined at the deployment level, enabling you to apply different formats to different deployments. You can define all of the above elements in the Options tab of a deployment. Related Topics · Language Selection 57 2010-12-09 Cube Deployments 4. 2. 3 Automatic Universe Creation You can choose to create an OLAP universe that will be based on the SSAS cube. All the SAP BusinessObjects tools supporting OLAP universes will be able to connect to the universes generated by cube designer and retrieve SAP BusinessObjects Financial Consolidation data security. For the universe to be created automatically, you need to enter the following information: · Universes Folder. You must enter the path to a folder that already exists on the SAP BusinessObjects Enterprise platform. Restriction: The name of the universe must not contain any of the following characters: ?. *:<>|/\"' Caution: If the name already exists in the specified folder of the platform, the existing name will be overwritten. Example: Path in the Universes Folder field. /InteractiveAnalysis universes/My universes 4. 2. 3. 1 Automatically Creating a Universe 1. In the Options tab of the SSAS deployment, select Automatically create associated universe. Enter a name for the universe in the Universe Name field taking into account the appropriate syntax limitations. Related Topics · Automatic Universe Creation 58 2010-12-09 Cube Deployments 4. 2. 4 Database and Cube Data Synchronization For each deployment, you can define synchronizing intervals so that the cube data will be consistent with the SAP BusinessObjects Financial Consolidation database data. If you do not activate the synchronization, the cube data will remain as it was when you deployed the cube. The synchronization applies to all the tables that have been modified. If you only want to synchronize the data related to certain data entry periods, you can select them. Caution: In this version, the synchronization only applies to the tables that existed when the deployment was done. [. . . ] The solution 'ID Solution' was successfully saved to the data source 'Magisk'. The solution 'Basic' was successfully saved to the data source 'Magisk'. 6. 4. 2 Error Messages Wrong data source: C:\Program Files\SAP BusinessObjects\Financial Consolidation\Cube Designer>IMPORT "/DS:WRONG" "/U:ADMIN" "/P: "/A:Windows" /F:Batch_Export. xml" "VAL-PYBO" "VAL-PYBO1" "VAL-IDEV" Invalid command : Cannot find 'WRONG' datasource in 'st-srv10' broker machine C:\Program Files\SAP BusinessObjects\Financial Consolidation\Cube Designer>pause Press any key to continue . . Wrong user and/or password: C:\Program Files\SAP BusinessObjects\Financial Consolidation\Cube Designer>IMPORT "/DS:LV_SQL2005_ES" "/U:WRONG" "/P:" "/A:Windows" "/F:Batch_Export. xml" "/OVERWRITE" Started import of solutions in file Batch_Export. xml. Import failed [Reason='Error connecting to magnitude (MagnitudeCredentialsFailed)']. 108 2010-12-09 Batches C:\Program Files\SAP BusinessObjects\Financial Consolidation\Cube Designer>pause Press any key to continue . [. . . ]