Posts

How duplicate a Business Objects Server from CMC

Image
It' is possible to duplicate a Business Objects Server from Central Management Console, when the server machine has enough RAM memory in order to support more servers then the standard number in order to improve Business Objects Suite performances. One of the server wich is useful to duplicate is the WebIntelligenceProcessingServer: log on CMC go in the servers page select the WebIntelligenceProcessingServer right click on this server and select 'Duplicate Server' After having create the second WebIntelligenceProcessingServer you need to Enable it and Start it To do so select the new server, right click and select 'Enable Server' the repeat the procedure in order to Start Server with the command 'Start Server' Please Note that you can repeat this procedure in order to duplicate every kind of server. Read also  this CMC in BI 4

Report conversion tool - BO XI R3.1 - SAP BI 4

Image
The Report Conversion Tool (RCT) is a tool useful to convert a Desktop Intelligence Report to WebIntelligence report. Let see ho to use this tool: Open it from Programs -> Business Objects 3.1 (or BI 4.0) Log in with Enterprise account Open Public Folder or Favorites Folder in order to select Deski report you need to convert: Select your report and clic the botton in order to move it in the right window: Select the last check box on the right if it is a Free Sql report otherwise click on the button 'ahead'  the conversion will start. The final result could be : a full conversion; a partial conversion; no conversion at all. as you can see from the following image: You could also choose a connection in order to save conversion result in order to audit this process, in this case you have to check the box in the second part of the window and you have to select one of available connections: In this way

Universe Best Practices

Business Objects Designer Basic Rules:  Keep the number of objects to 700 - 800  Larger universes will require more memory to use - This means more Java runtime memory allocated for Web Intelligence users  Reduce complexity where possible   Focus your universe efforts  Test  how this universe will work   Implement this universe as one piece of an overall strategic solution  Minimize your maintenance Classes are  group logically related business terms (objects) together. Best practices for classes include: - Naming conventions - Descriptions - Layout - Nesting limits (classes within classes) Layout and Organization - Limit to 20 – 25 objects per class - This will reduce scrolling through long lists - Use subclasses and detail objects  Determine how objects will be listed:    Most commonly used is most popular or  Alternatives: - Alphanumeric - Order by type (dates, calculations, …) - Hierarchically (general to specific) - Fastes

BO XI R3.1 Auditing Deski Reports

Image
Before starting conversion from DeskI to WebI   Reasons for moving from DeskI to WebI , could be useful to activate DeskI Reports Auditing  in order to understand what reports are still used and therefore are to be converted. So in this case you hato log on CMC Console go on Applications Menu choose Desktop Intelligence (Audit Events) and select the action to be audited: From CMC select Servers -> AdaptiveProcessingServer -> Audit Events Finally you can create a report on Activity Universe in order to select Deski reports' name still in use. Business Objcts XI R3.1 Auditing

Designer, using delegated measures

Best practices for using delegated measures  Use a delegated measure when report users manipulate the measures in reports. When they only need to refresh, view, and print their reports, the calculation may be simpler to perform in the report. So use a delegated measure: -          to replace multiple query aggregates. -         on calculations that could give inaccurate results when calculated in the report (such as complex averages). -         for measures requiring division. When you create a delegated measure, make sure that you enter text to identify as such to users. You can do so in the Edit Properties dialog box for the measure in the Description box of the Definition tab. This ensures that report designers can quickly recognize a delegated measure when they glide their mouse over it in a query. Case in wich delegated measures must not to be used. Do not use delegated measures when you apply a filter to an aggregated value from your query and further aggregate it

Starting CMC from command line

In order to start and stop a service via command line within a windows environment, write the command line as follows: Starting : net start bobjcentralms Unlike stopping via command line: net stop bobjcentralms

Business Objects Tuning Servers

Business Objects administrators' job In ordet to improve system performance, Business Objects administrators can  run load tests and also observe live/organic system performance over time. Infact the b etter way to know for certain the impact of any tuning change is to compare the system’s performance before and after the change. This fact present problems on live production systems because the use of the system constantly varies in load volume and the kind of work being done. Good     CMS  Parameters  Some Central Management Server (CMS) settings which given adequate hardware and database configurations, will almost always benefit all Business Objects XI systems. The first one: CMS Cache The cache is the first place you should focus. No CMS running on average server hardware will be harmed by pushing the memory cache parameter to the maximum and most systems will benefit. The only advise here is that if your system has limited memory (you will know by watching RAM u