Business Intelligence with SAP Business Objects 4.3

Before importing an universe in Translation Manager    the Best practise I feel to suggest is to make a local back up of the universe using BO Designer  you need to translate!! In this case  if after exporting the translated universe on CMS you will find the Universe is in some way corrupted you can recover it quicky form  the Designer! Read also related posts: Business Objects Translation Manager Translation Manager Exporting documents How to use Translation Manager Translation Manager Substitution mechanism

[repo_proxy 13] Session Facade::openSessionLogon with user info has failed(Transport error: Communication failure. (FWM 00001) (hr=#0x80042a01) Environment: Business Objects XI R 3.1 Enterprise SP 4 Desktop Intelligence client from extranet site cannot access to the BO Server. We used the right credentials, we checked our firewalls. Our firewall is open for the ports 6400 and 8080 (as default). The log shows that the network packages are sent between the client and server. The request is reaching the CMS as 6400 (BO server port) is enable but the Clients are not getting the response back as the request port is not enabled on the Firewall. On CMS there are two ports: one is Name Server port the other is the Request Port , by default the name server port is assigned the port 6400 and the request will reach the CMS when the name server is enabled on the firewall. The problem is that Web/client application cannot communicate as the Request port is unaware and the f

Environment BO XI R 3.1 SP 4 On logging on Desktop Intelligence,  the following error occurs:  SessionFacade::openSessionLogon with user info has failed(Transport error: Communication failure.(FWM 00001) Cause The client could not talk to the Server . This is the main  reason.  1)SYSTEM:6400(J2EE) means you are using 3 tier Desktop Intelligence which happens through web works fine as there is no firewall in between.  2)SYSTEM:6400 is 2 tier login and your firewall is blocking the connection.  The first one is a key that gets created when you modify or create a new Desktop Intelligence document from Infoview, that is 3-tier. The second one is you entering manually the information for 2-tier. Others Possible causes of the problem are: The server may be down. There may have been a network communication problem. The request my have timed out. Could be also a database connectivity issue between the CMS server and the Repository database. In order to

How to add a link in a dashboard  in order to open a document in SAP BI 4 platform First of all I wish you all HAPPY NEW YEAR! Let see how to insert a link to a document  that has been already published on SAP Business Objects 4 platform. Go to Web Connectivity menu in SAP Dashboards  as shown in the following image Select the  URL Button and drag an drop it  in the chosen position on the canvass Then select button Property tab  assign a name to button label  and then insert the appropriate URL in the following format http://BI4Servername:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=..... In this way, after publishing the dashboard on BILaunchpad  when you will click on the Open Workspace url Button  the related document will be opened: Please read related post: SAP BO 4.0 Open Document

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