Posts

Showing posts with the label SAP BW BEX

SAP BI 4 WebI - Connecting to a Bex Query with hierarchical data

Image
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 BO Design Studio Integrated with SAP BusinessObjects BI Platform

Image
Integrating  SAP BO Design Studio   with SAP BusinessObjects BI Platform Enable application management on BI Platform allows: - Enable multi user-access to applications - Storage of applications and images - Embedded runtime on BI Platform - Central management of system connections The following image show how to Open and save applications on BI Platform How to manage  System connections on BI Platform SAP BO Design Studio satisfies different needs for each company role as follows Executive - Consume and interact with information using simplified BI templates - Analyze information on mobile devices Middle Management - Leverage BI applications for planning and forecasting scenarios - User product interoperability to share results with other BI clients Business Analyst - Leverage BI applications for planning and forecasting scenarios  - Create BI applications and design guided navigations Consumer - Use pre-built templates with guided step

SAP BusinessObjects Design Studio (a.k.a. ZEN)

Image
SAP  BusinessObjects  Design Studio  SAP BusinessObjects Design Studio   represents  BEx Web & BEx Web Application Designer successor. Design Stuido allows for intuitive design of centrally governable analytic content ranging from guided analytics to sophisticated OLAP applications and aggregated dashboards.  The product features iPad support, an  HTML5 User Interface, differents themes available for application and a WYSIWYG Eclipse-based designer, full & native support of BW BEx queries, direct connectivity to HANA as well as an advanced scripting engine. Available features in detail: - Intuitive WYSIWYG design environment for designers - Large set of design components (buttons, tabs, dropdown menus etc.) - Extend via scripting language (subset of JavaScript) - Enterprise Ready Life Cycle Management - Central Supportability - Theming & Customizing iPad Support built-in Apps are ready for immediate usage on standard web browsers and mobile

Dashboards on BusinessObjects Mobile BI 4.4

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

Configuring BO Analysis on SAP HANA

You can also create an BO Analysis OLAP connection with SAP HANA as provider. With this HANA OLAP connection, you can use Analysis directly on top of a SAP HANA database. Configuration for SAP HANA If you use the SAP HANA appliance software, you can analyze SAP HANA data sources with Analysis. If you use SAP NetWeaver Business Warehouse, powered by SAP HANA, you can analyze BW queries, query views and InfoProvider with Analysis. You can connect and use a BW system, powered by SAP HANA, like other BW systems with Analysis. You have the following options to connect to SAP HANA:  - You can use an OLAP connection to connect via SAP BusinessObjects Business Intelligence platform. This connection can be created directly in the CMC of the SAP BusinessObjects BI platform like BW system connections to the platform. The SAP HANA OLAP connections are currently not SSO compatible. - You can use a JDBC connection to connect via SAP BusinessObjects Business Intelligence platform .

BO Analysis - Creating and managing BW system connections in SAP BusinessObjects BI4 - BOE

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

SAP BO ANALYSIS Creating workbooks

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

Image
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

Reporting on BEX Query in WEBI 4.0

Image
In order to create a report Webi based on a  BEX query Longon in BI Launch Pad and create a new document choosing BEX as Data source: Select a BW Bex Query choosing the OLAP connection published before You will see the WebI Query panel on a BW Bex Query as in the following picture: Inserting object into the query and selecting prompt value: Read also: SAP BI 4 WebI - Connecting to a Bex Query with hierarchical data Webi 4 - Changing the query data source

Bex Query with SAP BI 4

Image
USING OLAP IN INFORMATION DESIGN TOOL (SAP BI 4) Let see how to use Query Bex in Business Objects 4.0. Open Information Design Tool (IDT) and go to Connections  and open OLAP MIDDLEWARE DRIVER SELECTION as in the following image In order to open an olap connection on SAP Netweaver BI 7.x, choose the last BICS  connection: Insert Parameters for SAP Netweaver BI 7: Select the needed  Cube: Create the related connection: Publish connection in Repository: Read also: How to disable automerge demension on WebI 4 Webi 4 connecting to Bex query