User manual BUSINESS OBJECTS EXTENDED ANALYTICS 4 DESIGNER GUIDE

[. . . ] BusinessObjects Extended Analytics Designer User Guide BusinessObjects Extended Analytics Designer version 4 Copyright Copyright © 2007 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 6, 247, 008; 6, 289, 352; 6, 490, 593; 6, 578, 027; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 7, 139, 766; 7, 181, 435; 7, 181, 440 and 7, 194, 465. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence, Crystal Enterprise, Crystal Analysis, Web Intelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Note: You can select only one Parent Child hierarchy per dimension and per cube. Warning: Some BusinessObjects Finance characteristics linked to a dimension contain circular references. The deployment will then fail. · · Named level hierarchies. The BusinessObjects Finance characteristics that do not belong to the same reference table as the dimension to which they are assigned are changed into "Named level hierarchies". If you are using a BusinessObjects Finance database, other hierarchies are available for the Account and Reporting Unit dimensions. · For the Reporting Unit dimension, you can select Scope Entity Hierarchy. The hierarchies available in the drop-down menu depend on the scopes previously selected. When you select a scope hierarchy, the members of the scope linked to this scope hierarchy will automatically be selected in the Members tab. For the Account dimension, you can select a Category Scenario Account Hierarchy. The hierarchies available in the drop-down menu depend on the members selected in the Category dimension. · Note: If you are using a BusinessObjects Finance 10 SP2 or higher database and you chose to historize the scope hierarchies, the Parent child hierarchy cannot be changed for the Reporting Unit dimension. If you do not select a hierarchy or you select the Include default hierarchy option, the default hierarchy will be applied in the future cube. Note: In order to obtain a simple cube, you should select only one hierarchy per dimension and per cube. Note: If you have already selected a hierarchy, you are advised not to select the Include default hierarchy option. 60 BusinessObjects Extended Analytics Designer User Guide Views Defining dimensions 6 You can also specify that you do not want the name of the dimension to appear in the retrieval tool by selecting the Hide dimension name option. Defining aggregations For all dimensions except for Category, Scope, Variant and Consolidation Currency, two options are available. If you select these options, the parent node will contain the aggregated total of its children amounts. · · The Enable Named Level Hierarchy Aggregations option applies to the named level and the default hierarchies. The Enable Parent Child Hierarchy Aggregations option applies to parent child hierarchies. Note: For the Period, Data entry period and Account dimensions, this option does not appear. However, you can activate this option for the Account dimension by setting the following key in the 'Cartesis. InformationDelivery. Workbench. exe. config' file: <add key="IsAccountDimensionAggregatable" value="true"/>. Concurrently, for aggregatable hierarchies, you can deactivate the calculation at the "All" node level when not relevant. The Deactivate 'All' node calculation option applies to all types of hierarchies of the dimension. When the option is selected, the behavior is as follows in your data retrieval tool: · · The 'All' node is neither displayed nor calculated on a default hierarchy. The 'All' node is displayed but not calculated on the named level and parent child hierarchies. Enabling automatic aggregations on the Period and Data entry period dimension hierarchies You can choose to apply a different behavior on time aggregation by activating the automatic time aggregation based on BusinessObjects Finance flow types. To do so, you will choose from the Flow dimension a BusinessObjects Finance category scenario that will be used as a reference. The behavior of the flows will be as described in the selected BusinessObjects Finance category scenario. [. . . ] Wrong User and/or Password: 110 BusinessObjects Extended Analytics Designer User Guide Importing solutions A C:\Program Files\Business Objects\Extended Analytics\Designer>EXPORT "/ DS:LV_SQL2005_ES" "/U:WRONG" "/P:" "/F:Batch_Export. xml" "VAL-PYBO" "VAL-PYBO1" "VAL-IDEV" Solution export started for 3 solutions. C:\Program Files\Business Objects\Extended Analytics\Designer>pause Press any key to continue . . For oher messages such as 'invalid path' and 'unrecognized parameter', please refer to the Batch deployment error messages. Importing solutions The 'Import' exe file enables you to import solutions from an XML file into BusinessObjects Extended Analytics Designer. Example: Example of a command line for this program: C:\Program Files\Business Objects\Extended Analytics\Designer>import IMPORT - Imports Analytics Solutions from an external XML file. [. . . ]