User manual BUSINESS OBJECTS EXTENDED ANALYTICS 4.1 ADMINISTRATION GUIDE

[. . . ] BusinessObjects Extended Analytics Administration guide BusinessObjects Extended Analytics 4. 1 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. [. . . ] However, in order to avoid the creation of huge useless reports, you can limit the number of cells requested from the server. To do this, there are two DWORD registry entries: · QueryCellLimit: you must create this entry in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office \Excel\Addins\IDPrj. AnalyzerAddIn\QueryCellLimit This key controls the number of cells that would activate the warning dialog. This will provide an error message informing the user that the request has more cells than allowed and the query will not be executed. · QueryCellLimitWarnOnly: you must create this entry in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Office\Excel\Addins\IDPrj. AnalyzerAddIn\QueryCellLimitWa rnOnly This key controls whether the query is still executed after the message about QueryCellLimit is displayed. A value of 0 (same as registry entry not existing) means that the query will not be executed. You can also deactivate the Anayzer cache by creating the following key. · HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Office\Excel\Addins\IDPrj. AnalyzerAddIn\UseMetaDataCache A value of 0 means that the cache mechanism will not be used. Administration guide 51 5 Appendix Web sites properties Web sites properties Reporter Once the setups are done, the recommended settings are the following. You should verify that identify where the Windows account has been specified in the following two locations: in the data pool and in the website properties. Check the Windows account specified in the Reporter data pool properties. 2. Check the security settings of the Reporter web site properties. 52 Administration guide Appendix Web sites properties 5 Deployer Note: This procedure applies to BusinessObjects Finance Deployer installation. You should verify that the Windows account has been specified in the following two locations: in the data pool and in the website properties. Check the Windows account specified in the Deployer data pool properties. 2. Check the security settings of the Deployer web site properties Administration guide 53 5 Appendix Web sites properties 54 Administration guide Troubleshooting chapter 6 Troubleshooting Object: Unable to open solution Knowledge base article number: 14842 Problem encountered This problem occurs when you try to open an existing and previously saved solution. Resolution A possible cause is that the connection to the DB server was interrupted when you were saving the solution or deploying a cube within this solution. You need to restart the Finance data source in CtAdmin and this will normally solve the problem. Object: Analyzer: Unable to start C:\Program Files\Business Objects\Extended Analytics Analyzer Knowledge base article number: 15154 Problem encountered When you try to start Analyzer, the following error message appears: "Excel cannot be launched". Resolution There are four areas to be checked: Check ActiveX settings in Internet Explorer Proceed as follows: 1. In the Initialize and script ActiveX controls not marked as safe setting, check the Enable option and click on OK. In the Security tab, click on the "Custom Level" button for "Trusted sites". In the Initialize and script ActiveX controls not marked as safe setting, check the Enable option and click on OK. Click on OK and close Internet Explorer. 56 Administration guide Troubleshooting 6 Check the following keys in the registry · HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\Repo rtPublishing. ReportPublisherAddIn] · · · · "FriendlyName"="Cartesis ES Report Publisher Add-In" "Description"="Report Publishing for Information Delivery Add-In" "LoadBehavior"=dword:00000003 The 'loadBehavior' must be set at 3. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\IDPrj . AnalyzerAddIn] · · · · · · 1. 2. "Standalone"="1" "LoadBehavior"=dword:00000003 "CommandLineSafe"=dword:00000000 "FriendlyName"="Cartesis ES ID Add-In" "Description"="Cartesis ES ID Add-In" "Toolbar"=hex:01, 00, 01, 01, 00, 00, 4c, 00 Reactivate the Analyzer add-in Click on About in the Help menu in Microsoft Office Excel. Then click on Disabled Items. For installation in Citrix and Excel 2000 or XP Check that the HKEY_LOCAL_MACHINE\Software\Classes\Interface\{000C0601-00000000-C000-000000000046 key exists. Otherwise, you should create it. Object: Deleted view still appears in Analyzer Knowledge base article number: 14824 Problem encountered Although the view has been deleted, it still appears in Analyzer. Resolution This problem occurs because the view is a separate object from the cube. Note: the name of the cube is by default the same as the deployment name created. If you use Analyzer, you connect the (excel) sheet to a cube and not to a view. Administration guide 57 6 Troubleshooting So, when deleting a view, you are in fact just doing that - you delete the view, but not the cube. [. . . ] Resolution Excel reports are empty when opened because access restrictions are applied only when you connect to the cube. Users who are authorized to consult reports should do so in RDL format. This enables them to set variables and run reports directly in Reporter. Administration guide 69 6 Troubleshooting If the page setup configured for reports is not applied when publishing in RDL (see Answer Link article), you should change the page setup so that it is compatible with RDL format. Object: ORA-955: Error message when deploying solution Knowledge base article number: 15738 Problem encountered During the deployment of a solution, an error message appears when I insert data in one of the tables e. g. RGSFH_Default_CODATA :"é ORA-955: name is already used by an existing object. [. . . ]