Business Intelligence with SAP Business Objects 4.3

HANA Modeling Target: Minimize Data Transfers  The main goal  during modeling is to minimized Data transfers.  This is possible true both  internally, between the SAP HANA database views, and also between SAP  HANA and the end user application. So for example, the end-user will never  need to see 1 million rows of data.  They would never be able to understand  so much information or consume it in some meaningful way.  So d ata should be aggregated and filtered to a manageable  size before it leaves the data layer. When deciding upon the records that should be reported,  the best  practice approach is to think at a “set level” not a “record level” .  A set of  data can be aggregated by a region, a date, or some other group in order to minimize the amount of data passed between views. Read related post: SAP HANA Tables, Models and View Processing

The universe does not allow using a complex expression in a GROUP BY statement. You cannot run this query. See your Business Objects administrator. (Error: WIS 00010) Cause A query contains a GROUP BY clause that uses formulas or aliases. The universe does not allow these expressions in GROUP BY clauses. The behavior is determined by the parameter Y in the PRM file for the target RDBMS. Action You have two solutions: • Modify the query so that objects using formulas or aliases are not included in the query. • A universe designer can open the PRM file for the target RDBMS and change the value for the parameter GROUPBY_EXCLUDE_COMPLEX to N. This change should be made only if you are sure that your RDBMS supports complex GROUP BY expressions. Please note: The parameter GROUPBY_EXCLUDE_COMPLEX by default is 'N' . Check your .prm file in your environment and change accordingly.  See also: BUSINESS OBJECTS ERRORS LIST

SAP HANA Database Concepts: Tables, Models and View Processing  SAP HANA database is a very capable database system but it requires some understanding, and to be used correctly, to obtain good performance. Let's see the key concepts of the SAP HANA database. We will explain how  approach modeling in order to to achieve best results. The SAP HANA database allows you to model your data as tables and views. Tables are tabular data structures, each row identifying a particular entity, and each column having a unique name. The data fields of one row are called the attributes of the entity. The word “attribute” is used with different meanings. It may refers to a table column, a particular data field of a table row, or the contents of such a data field. The respective meaning will be clear from the context. Views are combinations and selections of data from tables modeled to serve a particular purpose. Views always appear like readable tables, i. e. database operations which

Let see how to change the data source in a existing  Webi  report. Open the Webi report  select the 'Data Access' tab Select the 'Tools' menu under Data Access tab Select the Change Source Menu  Select  the Query to which you need to change the data source Select the Specify a New Data source  Flag  Select the wanted Universe Check that all the new query objects match to the old ( as in this image) Then Click on Finish. See also: Bex Query with WebI 4 http://businessobjectsbi4.blogspot.it/2013/11/how-to-publish-unx-from-information.html

 Unable to connect to service from server via CMS (FWM 01006) Environment SAP BI 4  DB  SqlServer2008 Cause Unable to connect to the service through the CMS. Action Log on to the CMC and ensure that the service is running on the appropriate server. Solution In our case we have disabled, stopped and then enabled and started the WebiProcessing Server. See also: BUSINESS OBJECTS ERRORS LIST

Using SAP Visual Intelligence - Step by Step Let's see how to create a chart with Visual Intelligence. 1. Connect to your data source If your data source is: - RDBMS: Enter your credentials, connect to the database server, browse and select a data source.   If you are connecting to SAP HANA, you select a view and cube to build your chart. - Flat file: Choose the columns to be acquired, trimmed, or shown and hidden. - Universe: Enter your universe credentials, connect to the Central Management Server repository, and select a universe to build your chart. 2. View and organize the columns and attributes. The data acquired can be viewed as columns or as facets. You can organize the data display to make chart building easier by doing the following: - Create filters and hide unneeded columns. - Create measures, time and geography hierarchies. - Clean and organize the data in columns using a range of manipulation tools. - Create columns with formulas using a wide sel

Improving SAP BO Dashboard performances Decalogue 1. Avoid Excel formulas if is possible so Try to reduce using formulas as much you can 2. Un-nest Excel formula if you can 3. Avoid linking cells 4. Avoid array Excel functions like sumif, sumproduct 5. Limit dashboards components number 6. Reduce or avoid container components 7. Try to make a simple dashboard model in order to make also simple and easy it's maintenance and it's evolution 8. Prefer QaaWS to LiveOffice when connecting to many universes otherwise it’s better using Webi Reports because you can load heavy data by scheduling Webi reports, besides in Webi it’s easier  to do calculations and values  formatting . 9. In order to improve dashboard performances schedule Webi reports, better if not at the same time. 10. If possible you can use triggers on the cells in order to update data from Webi reports. Sap BO Dashboards 4.0 - Xcelsius 2008