Business Intelligence with SAP Business Objects 4.3

CMC  BI 4.0 - Not able to Delete User  Environment  BI 4.0 SP5 After migrating from XI R3.1 SP 4 to BI 4.0 SP5  logging on CMC as Administrator and  right clickeing on user there is no Delete on the menu .  The remove user or group from user group icon is greyed out. The Workaround for this issue (same for deleting groups) You need to go on the property of the user (as you can see from the image below there are no rights related to this user)  so in order to delete it you must give 'full control' to the Administrator  After this operation it was possible to delete it. You can do this operation to 'user groups' in order to obtain a widespread result.

BIG NEW: In SAP BI 4.1 Supports SAP BusinessObjects Desktop Intelligence 3.1 SP6 FP 6.1  in viewing mode Web Intelligence is the way forward Scope   Consumption of DeskI content in BI 4.1 using Desktop Intelligence 3.1 client SAP BusinessObjects Enterprise 3.1 SP6 FP6.1 will provide the Desktop Intelligence client the capability to connect to a BI 4.1 CMS SAP BusinessObjects Enterprise 3.1 EoL timelines are still applicable on Desktop Intelligence Key benefits Important and critical Desktop Intelligence documents can  be stored in BI 4.1 Customers gain additional time to convert Desktop  Intelligence documents while on BI 4.1 Reduced TCO, as customers can retire SAP  BusinessObjects Enterprise 3.1 completely. Read also related post: SAP BO BI 4

WebI - Connecting to a Bex Query with hierarchical data In WebI as you already know is possible to connect to SAP Bex as data source and taking advantage of hierarchy set up  with related dimensions in order to explore hierarchical data, this is also possible form WebI Rich Client (version 14.0.0; build 760). On the left side of the following  page you will select the Bex query with hierarchy while on the right you will select the quert with multiple hiearchies Then select the hierarchy  (1st pic)  and a measure (2nd pic) In the following picture you can see the query result, by clicking on the plus sign you can expand the customer type hierarchy By editing the query and clicking on the member selector list You can explode and then  select all the hierarchy levels by clicking on the specific button As you will see with this operation you will make visible all the hierarchy levels in the report tab: Read also rel

SAP Mobile BI Server and the new  BI 4.1 New features CMC & Launchpad Integration: Allows Configuring Secury Policies via CMC ( Before you needed a config file in the application server now settings are in CMC) You can enable mobile documents through Launchpad properties; right click on the document to get mobile properties dialog, including “time to live”. Allows Configuring Categories for Content Management via CMC Ability to Mobile Enable and Management Document Properties via Launchpad Support for Auditing user actions from Mobile devices Enhancement to Logging Framework and Perfomance Improvements SAP BO MOBILE Connectivity Options Read aslo: http://businessobjectsbi4.blogspot.it/2013/03/sap-bi-mobile-security-concepts.html http://businessobjectsbi4.blogspot.it/2013/03/dashboards-on-businessobjects-mobile-bi.html http://businessobjectsbi4.blogspot.it/2012/09/sap-bi-mobile-guida-pratica.html

Finally has arrived: BusinessObjects Mobile BI 4.4 wich allows to access to Dashboards on Mobile device and so on IPad and Android Tablet and phones. Dashboard for SAP BI Mobile supported features: Connectivity: through Query Panel on Universes on Query Bex (SAP BW) on Hana Universes Components: Labels Images component Combo box Label based Menu Radio button Scorecard List View Icons Slider Progress Bar Toggle button Push button Charts: Column Chart Bar Chart Pie Chart Line Chart Combination Chart Stacked Bar Chart Stacked Column Chart Gauge Containers: Tab Set Canvass Container Component Groups Please Note that at the moment Prompt component is not available. You will find not compatible components and features on the Compatibility Panel. Keep following the blog for further details and update! Read also Sap Dashboards for ipad Sap BO Dashboards 4 new features

How to enable/disable automerge demension on WebI report Envirnonment BO XI 3.1 SP 4 In edit mode, right click in the report and go to document properties. Check if Auto merge dimension option is selected or not. Also check that if you have right to merge dimensions or not (See the following image). Moreover you should checked on CMC that  the related security in Access Levels in the CMC  option is enabled. I want to know if there are special requirements for the dimensions to be able to be auto-merged, next to having the same name and being of the same type. Keep in mind that: Webi Intelligence can merge dimensions automatically in the following cases: • The dimensions have the same name • The dimensions have the same data type • The dimensions are in the same universe 

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

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

You can use Analysis with SAP BusinessObjects Business Intelligence XI 4.0 or SAP BusinessObjects Enterprise XI 3.1   as the central content management system for Analysis workbooks  and presentations and as platform for managing data source connections. Before users can begin working with business data in Analysis, you have to create connections to BW systems so they can add data sources to their Analysis workbooks. You create new connection objects and manage existing connection objects in the module OLAP Connections in the Central Management Console (CMC) of the business intelligence platform. To create a connection to a BW system, you define a connection to any object of the BW system. You also have to make sure that the client PCs can communicate with the connected BW systems. If the BW system uses a message server the client PCs must specify the service name of the message server in the system services file at :\WINDOWS\system32\drivers\etc\services.  Config

Xcelsius provides an authentication mechanism that enables you to avoid logging into InfoView twice with the same session ID. Take note of following rules if you customize authentication: - An existing session ID is used only if the user name and password are blank (if they are not hard coded or not passed as input values captured by a dialog). This occurs when Query as a Web Service is running in InfoView or Dashboard Manager. - If the user name and password are not blank, then use these values to authenticate the user. No session is created. This is the most scalable scenario and is the preferred option for large-scale usage. - If there is no pre-existing session (and username and password are blank), Xcelsius displays the standard security dialog, in which a session is created. This occurs when Xcelsius designers do not build their own security dialog. See also: Consuming a query as a web service in Xcelsius How to start Query as a Web Service

To consume a query as a web service inside Xcelsius, use the Web Service Connector The Web Service Connector component allows a Flash document created in Xcelsius to communicate with Query as a Web Service through SOAP, using point and click. The Xcelsius Flash document is self-contained and communicates with the web service to display data visually. The only prerequisite is that there be a SOAP-based web service available to the Flash document. The Web Service Connector component, when activated, creates a SOAP-based message (basically an XML document) and sends it to the web service. The web service responds with a SOAP-based message of its own. The Web Service Connector component then sends this data to all the other components, resulting in a live visual representation of your data. There are many public web services available, and many different toolkits and packages for SOAP-based web services. To use public web services and packages that already have a web service on t

This kind of query  is useful because can be used it to consume data into Xcelsius Dashboards in alternative to connecting through Live Office. See: Sap BO Dashboards 4.0 - Xcelsius 2008 Query as a Web Service is used with a Central Management System (CMS) The CMS contains the server component that stores the Query as a Web Service catalog and hosts the published Web Services. When you start Query as a Web Service for the first time, you must define the host server before starting. Each successive time you start Query as a Web Service you select an available host server, then log into the CMS. Once you are logged in, the Query as a Web Service startup Query Catalog page appears.  From this page you can start the query creation and publication wizard to publish a new query and edit existing published queries. How To define a query in Publish as a Web Service Wizard The "Query" page of the "Publish as a Web Service Wizard" allows you to use a quer

SAP Visual Intelligence  can Acquire data from different data sources SAP Visual Intelligence 1.0.6 You can acquire data from the following data sources: - C.S.V file - SAP HANA cube - MS Excel - Freehand SQL - SAP BusinessObjects Universe Each data source can be adapted before acquisition to include or remove columns. For certain data sources you have other options, for example data formatting, column naming and trimming, and specifying column name prefixes. The acquisition options are described for each individual data source. Note: For data that is acquired to manipulate locally the maximum number of cells that can be acquired is 15 million. Spreadsheets with more than this maximum are cut off at this point. Read also: Using SAP Visual Intelligence SAP Visual Intelligence SAP VISUAL INTELLIGENCE FEATURES SAP HANA Introduction

In order to migrate  a universe from a prior CMS release (XI R3.1 and XI r2)  to a BI 4 CMS, you must use the Upgrade management tool  (UMT)  that is provided with BI 4. SAP Business Objects 4.0 BI 4 includes two universe development tools: - The universe design too l, which is an upgraded release of the Universe Designer tool you are familiar with if you are an existing Business Objects customer wich creates a UNV file . - and the new Information design tool (IDT) , which is the new universe authoring tool provided with BI 4 that produces a UNX file . A UNX universe file is published on the CMS  is the result of a merge of three components that are designed in the information design tool.: -  CNX files for connections -  DFX files for data foundations -  BLX files for business layers A UNX is the result of CNX + DFX + BLX where: the data foundation    (DFX )  contains a schema  of tables and joins from one or more relational databases ,  through connections (CNX), th

Using SAP BusinessObjects BI Clients for SAP HANA Creating the JDBC connection to the SAP In-Memory Database To set up the JDBC connection to the IMDB: 1. Copy the ngdbc.jar in the appropriate folder under …/dataAccess/ConnectionServer/jd bc/drivers/newdb If this directory structure does not exist, you need to create this directory structure under ../dataAc cess/connectionSrever/jdbc and then drop the jdbc jar file under this directory. 2. Launch the SAP BusinessObjects information design tool. 3. Create a new local project. 4. In this project, create a new Relational Connection. 5. Name it. 6. Select JDBC Drives as the data source. 7. Enter DB credentials and test. 8. Choose Finish. Note: for Explorer, you can also create a native connection from the IMDB to the Explorer application, by configuring the Explorer application settings in the SAP BusinessObjects Central Management Console (CMC). When this type of native connection is used for Explorer, a UNX file

After installing SAP HANA, you have to connect the components of your SAP HANA landscape so they can work together. You have to establish connectivity between the following components: 1. SAP HANA box to SAP ERP system 2. SAP HANA box to SAP HANA studio 3. SAP HANA box to end-user clients. If you are using the SAP BusinessObjects servers, which are not in the scope of SAP HANA, you also have to connect the following SAP BusinessObjects systems: 1. SAP HANA box to SAP BusinessObjects Enterprise (to use the SAP BusinessObjects BI clients) 2. SAP ERP system to SAP BusinessObjects Data Services (to use Data Services for data replication) See also: Create a Data Foundation (UNX) on a SAP HANA Universe on SAP HANA

Choosing between creating HANA information models and universes Client tool Requires a Universe Access HANA data via: SBO Analysis Office             No                       an information model SBO Explorer (*) Microsoft Excel (PivotTable) SBO Web Intelligence Yes                       a universe built on tables or information models SBO Dashboards SBO Crystal Reports for Enterprise (*) Explorer could also be connected to universes When you have to begin a new business intelligence project on HANA, the first question to ask yourself is whether you want to (or need to) create information models or universes. At the moment  your choice mainly depends on the client tool that you want to use to access HANA. When you create information models you benefit from: -Availability to Analysis, Explorer, Excel, reusability in Universes -SQL Script, L, R languages for programmatic calculation view -Modeling in HANA Studio When

VISUAL INTELLIGENCE FEATURES AND EVOLUTION A new BI general need  about a fast data visualization that enables  interactive data visualization and self consumption is now covered by SAP with SAP VISUAL INTELLIGENCE. Through  Visual Intelligence SAP aims to answer the growing demand for self-service data visualization in order to realize an analytic dashboard tool. SAP Visual Intelligence was originally released during the May 2012 SAPPHIRE NOW event, and a new version, was released as Feature Pack 3 for BI BusinessObjects 4 . Concerning  power and complexity, SAP Visual Intelligence is positionated between the dashboards such as SAP BusinessObjects Dashboards (a.k.a Xcelsius) and SAP Zen, and the self-service web and mobile tools of SAP BusinessObjects Explorer. SAP Visual Intelligence is part of the SAP BusinessObjects Explorer family, but while BusinessObjects Explorer allows for data exploration and visualization via a web service or through a mobile app, SAP Visual Intelli

Creating and managing workbooks In SAP BO ANALYSIS you can insert SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources  in a workbook.  These data sources are stored in a SAP NetWeaver BW system. You can add multiple  crosstabs to worksheet or workbook.  The crosstabs can contain data from the same data source or from different sources. You can also use data sources that are stored in different systems in one workbook. To add a crosstab with data to a workbook, you select a data source in a SAP NetWeaver BW system. You need the appropriate authorizations for the platform you want to use (SAP NetWeaver BW or SAP BusinessObjects Business Intelligence), and the relevant SAP NetWeaver BW systems to insert a data source in a workbook. For more information, contact your IT administrator. You can insert a data source in a standard workbook or in a default workbook. If you use a default workbook, styles, formatting and the workbook settings t

SAP BusinessObjects  Analysis, Microsoft Office Edition It is new tool of BI 4 it is: Easy-to-use OLAP  analysis in Office Familiar and intuitive Microsoft   Office user experience Uncover deep insights with  powerful Excel-based analytical capabilities Bring  analyses into PowerPoint  presentations Leverage all your investments -  BW cubes and BEx queries, and BI platform SAP BusinessObjects Analysis, edition for Microsoft Office, is a Microsoft Office Add-In that allows multidimensional analysis of OLAP sources in Microsoft Excel, MS Excel workbook application design, and intuitive creation of BI presentations with MS PowerPoint. The Add-In is available for the following Microsoft Office versions: • Microsoft Office 2010 (Excel and PowerPoint) • Microsoft Office 2007 (Excel and PowerPoint) • Microsoft Office 2003 (Excel) In the edition for Microsoft Office, you can use SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources. The