SAP BusinessObjects Design Studio
Integration into SAP BI Mobile Solutions
SAP BO Design Studio integrated with BO BI 4
Dashboard for SAP BI Mobile supported features:
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!
BO XI 3.1 SP 4
Xcelsius 2008 SP 4
Live Office XI 3.1 SP 4
If you need to install Live Office on a pc with Office 2010 already installed you will get the following warning:
In can bypass this error with a
a workaround wich aims to avoid that MS installer checks if Office is installed.
In order to do so you need an MSI editor, we suggest
So follow these steps:
Create a copy of Lifeoffice.msi file located in the Package folder.
Open with InstEd the Lifeoffice.msi file and select the “Tables” tab and click on LaunchCondition;
Then delete the row which refers to Office ( “EXCELl10 OR OUTLOOK10″)
and save the file.
Then run this modified Lifeoffice.msi,
previous error will not appear any more and you will accomplish your installation!
Then select button Property tab
assign a name to button label
and then insert the appropriate URL
in the following format
Please read related post:
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 following link another example with related files:
For more Dashboards templates and example:
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:
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 Total data provider):
TOP 10 lookup sheet
Account detail sheet
In order to download this dashboard template ( XLF, swf and .xls) you can open the following link:
Others Dashboards template
For general information see also:
With this last SP you can verify old dashboards you developed in order to use them on Ipad.
In this version you cano select the right size for an iPad screen (1024×768)
Beside you have to check the components/parameters in order to verify that are supported for HTML5, this check is easy to do through a new functionality for analayze dashboards components compatibility panel.
A plus is the chance to choose iOS compatible fonts (Arial, etc. – otherwise, the embedded browser will try to use the best font).
Before exporting the reviewed dashboard you can preview it using the mobile viewer option to see how its layout on an iPad:
you can choose between:
- Fit to screen
- Original size
Finally you can export to the server the dashboard and you can open it using the SAP BusinessObjects mobile application on the iPad.
Mobile compatibility panel
New features are to be found in the mobile and HTML5 support topic.The main is new ‘Mobile compatibility panel’.
If you open an existing xlf dashboard and go in the mobile compatibility panel, all components are shown, including a icon to tell if they are support for mobile export or not.
Some dashboard components in this first HTML5 realise (SP5) are not supported:
- all connections using the Data manager
- component value
- area chart
- the list builder
- mouse over interaction (on buttons and charts).
but SAP announced that these and more components will be supported in the near future however most of the unsupported components are not critical.
The next SAP dashboard tool will be
SAP BusinessObjects Design Studio (aka SAP Zen)
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.
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 top, you only need a WSDL document for the web service. For Query as a Web Service , you can find the WSDL in the properties of each web service by selecting it in the Query Catalog page.
After downloading the Xcelsius widget from the web, you may encounter difficulty retrieving data with Query as a Web Service if the Flash and the client tool come from different web domains.
This occurs for security reasons related to Macromedia Flash. The Flash displayed in a browser is not permitted to access data residing outside the web domain from which the Flash file format (SWF) originated.
The solution depends on whether your Xcelsius server and the Query as a Web Service client tool are on the same or different machines.
Open the Optional Parameters dialog box from the Advanced parameters button and modify the Web Service Base URL so that it matches the web domain from which you downloaded Xcelsius.
For instructions, go to: