Posts

Showing posts from October, 2010

Xcelsius 2008 Connectivity with SAP NW BI/BW 7 (Connecting SAP BI Directly with Xcelsius 2008)

Image
BusinessObjects Xcelsius 2008 Enterprise : BusinessObjects Xcelsius Enterprise has all of the features of Xcelsius Engage. In addition, it offers integration capabilities with web portals and Reporting Services. BusinessObjects Xcelsius Enterprise integrates with the BusinessObjects platform, including Query as a Web Service (QaaWS or QaWS), LiveOffice and Crystal Reports. It is intended for users who wish to create visualizations that are deployed in a BusinessObjects Enterprise Environment. License Model : BusinessObjects Xcelsius Enterprise is delivered in two-part licensing structure. i)BusinessObjects Xcelsius Enterprise: Licensed per name user. ii) BusinessObjects Xcelsius Enterprise Interactive Viewing: Licensed per name user or CPU. Languages: English, French, German, Italian, Spanish, Portuguese (Brazilian), Dutch, Swedish, Simplified Chinese, Traditional Chinese, Japanese, Korean and Russian. The following figure illustrates the different ways of connectin...

Performance Tuning in SAP BW/BI

If the client have BW Accelerator implemented. By Creating BWA indices we can improve Query Performance. else (No BWA Exist) Check whether BI Stattstics Cubes has been enabled or not Go to T.code RSDDSTAT -->Query Name --> All, On ( X ) --> Save it. So now we have enabled statistics on that query. For Query RunTime : Stats InfoCubes 0TCTC01 - Low level details can be seen in this Stats cube. 0TCTC02 - 0TCTC03 :(Very Detailed Stats Info) Aggregates fast providing, Aggregates being in use,  DB Ratio = Read / Transferred, the ratio only recommended is 10% . For Loading Related: 0TCTC21 - Process statistics 0TCTC22 - InfoPackage 0TCTC23 - DTP To Check Runtime of BW/BI Queries : Goto T.code RSRT Provide Query Name - ->Execute & Debug. Query Step ID. A pop-up window will appear.....Check a few : Use without Cache, Display Statistics Info. You can check further more info in the following tables : RSDDSTAT RSDDSTATAGGR...

SAP BI - BOBJ Acronyms - SAP IS-Retail Road Map

Image
BW Query Element OLAP Universe Element Cube dimension Class Characteristic (incl. Time and Unit) A class with dimension and detail objects (detail objects for key and description) Hierarchy A class containing a dimension and detail objects for each hierarchy level. Calculated key figure (CKF) Measure element in a class named key figures (information about the calculation is not available via the universe but the CKF is available to be used) Restricted key figure (RKF) Measure element in a class named key figures (information about the restriction is not available via the universe but the RKF is available to be used) Key Figure Measure element in a class named key figures Navigational attribute A class with dimension and detail objects(detail objects for key and description) Display attribute Each display attribute becomes a detail object underneath the related dimension object. Query filter Filters will be applied to the underlying query but are not visible in OLAP universe....

Formulas In Excel for Various BO Dashboard / Webi / Crystal Reports Formulas.

MS Excel Formulas for formatting of data as input to Xcelsius 2008. 1.Maximum =MAX(A2:A9) 2.Minimum =MIN(A2:A9) 3.Rank =RANK(C2,$C$2:$C$12) 4.Match =MATCH(F3,$A$2:$A$16,0) 5.Index =INDEX($B$2:$B$16, F12) 6.=IF($B$2=1,C5,IF($B$2=2,C6,IF($B$2=3,C7,IF($B$2=4,C8,"")))) : If you have 4 Records according to index. Excel Format Cells: Number Currency... 1.Custom - >Type Eg: #,##0.00 #,##0.00;[Red]#,##0.00 To show different Colors for Positive & Negative values [Blue]#,##0.00;[Red]#,##0.00 all the numbers until first first semicolon will be positive and Blue in color rest of the numbers will be in Red i.e., Eg: I 1543 -543 Eg: II 500 Blue #,##0.00; 500#,##0.00 --------------------------------------------------------------------- Crystal Reports Formulas: INT((CurrentDate - tblemployees.DOB)/365.25) [tblemployees.Surname]&" "&[tblemployees.First Name]