Posts

Showing posts from December, 2012

SAP HANA Modeling Guidance

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

Error WIS 00010 - The universe does not allow using a complex expression in a GROUP BY statement

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 Tables, Models and View Processing

Image
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

Webi 4 - Changing the query data source

Image
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

Error FWM 01006 - Unable to connect to service from server via CMS

 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

Image
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

How to Improve Dashboard performances - Decalogue

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

Error WIS 10901 - Database error occur

Database error occur. The error message is : (CS) "DBDriver failed to load : Installdir\win32_x86\dataAccess\connectionServer\dbd_oci.dll  (the module cannot be found)". (WIS 10901) Environment: Business Objects XI R 3.1 DB Oracle 11g When opening a Webi report on infoview, the above error is generated,while Webi rich client  works fine. Cause The problem can be explained because the WebI Rich Client uses your local connection settings while infoview uses those on the Business Objects server. So you need to check  that the server has same DB access of your local machine. Besides  you need to  keep in mind that the permissions depends  by the service account, so if your service runs under local account then you need to check the security policy on this account. Solution You need to check the following points: 1. If you have not an Oracle client on your client You need to install it 2. Set the ORACLE_HOME 3. Check whether TNS.ORA is set up properly an

World Sales Dashboard template

Image
Let's see how create a  simple Sales Dashboard  which has as main component the Accordion menu which allows to have a multiple level hierarchical filtering. This means that you can first select the top level hierarchy dimension in our case the 'Country' and then you can choose one of the ' Products' sold in the selected country: The columns chart shows the sales for that kind of bike in the months of the year. In the following image you will see how data changed when you select an other kind of product Below  you can see how create the Excel file in order to create this dashboard. In the yellow are will be drilled the months sale data after selecting the two hierarchical dimensions. Under this line there are different tables for each Country that can be selected which contains sales data per product for each months. Below is detailed how to set the Accordion Menu You can find the related files on SAP COMMUNITY NETWORK, in the

Error WIS 30272 - Max character file size limit exceeded

Max character file size limit exceeded. The document is too large to be processed by the server. Contact your BusinessObjects administrator. (WIS 30272) Cause: When you view a Web Intelligence document in HTML format, the Web  Intelligence server generates character based output, which is then interpreted by your web browser. This errors occurs, if the size of the  character output is greater than the maximum size specified by your administrator for the Web Intelligence server. Solution The administrator can change the parameters set for Maximum character output on the Administration Console.  Please note that however, increasing the maximum  binary output can affect performance. Log  on  CMC -> servers -> Web Intelligence Report Server -> Properties  Maximum Binary File Size:  Maximum Character File Size: The Binary file size shold be  for PDF; the character size is for webi reports.  You have to increase you current limits unt

Error FWM 02088 - Account Information Not Recognized

Account Information Not Recognized: The CMS system database is not available. This error cannot be rectified by the end user. Report this error to your system administrator or database administrator. (FWM 02088)  Environment XI R3.1 Cause The CMS database is unavailable. Solution Check if all the servers including CMS are running and enabled in CCM on BOBJ server. If yes,  r estart the SIA, it always works! See also: BUSINESS OBJECTS ERRORS LIST

Error WIS 00509 - Universe data connection could not be found

Universe data connection could not be found. Either the connection has been deleted or you do not have the rights to use it. The universe data connection is not available, either because it has been deleted or because you do not have the right to access it. Solution: The Business Objects Administrator must  give to a specific users group (user)   the right to access to the universe and its related connection. See also: BUSINESS OBJECTS ERRORS LIST

Xcelsius Dashboard template files

Image
In order to learn how to create  a Transportation dashboard   you can  study this  dashboard example.  Here you can choose  between 'Company Total' page  and 'Top 5 What if analysis' pages. Let's see the first page   'Company Total' : On the right you can select six labels which corresponds to  different analysis: ABC  2006 Acme 2006 XYX  2006 Total  2006 Total  2005 Same week 2005. All the tabs acts have the same functions. Besides selecting one of the Top ten customer  you will see the drill of related data in the bottom bar charts for each analysis type, follows the image about selecting the 7th customer: The second page is about 'Top 5 What if analysis'  On the left panel, you can see the What if analysis that is you will see all the values and gauges changing on moving the indicator  on the upper graduated bar. Follows the Excel sheet images that provide  data to the dashboard: TOP 200 sheet (Company