Web Intelligence, the business intelligence reporting tool, is a part of SAP BusinessObjects product suite. This is a handy tool for business users for analytical and ad hoc reporting. Using Web Intelligence, business users can create basic, medium, and complex reports from transactional data in. Nov 29, 2017  Tips for Optimizing the Performance of Web Intelligence Documents DRAFT DISCLAIMER - This document is a work in progress and will be released 1 chapter at a time. Please follow, bookmark and subscribe to updates to ensure you are notified of the latest changes. Jun 08, 2017  Press the 'Download Now' button to download and install Efashion Universe. The eFashion universe is used for all the examples, and is very small and easy to use. Click on the background of the report to make sure nothing is selected. Conditional Column Hiding in BO 3.1 Webi Report. We will be using the standard efashion universe.

1. How To Install Efashion Universe Background On Mac
2. How To Install Efashion Universe Background On Computer
3. C & Efashion

September 25, 2014 This blog post is inspired by a recent customer request to challenge their decision to use Design Studio for some “dashboard requirements”. Showing how you can create a dashboard in Webi doesn’t mean I told the customer not to use Design Studio.

Much more it is to show that finally a dashboard as well as every other type of BI front end solution is made up of requirements and not primarily by the tool you build the solution. Please refer to my for more details as well as my post regarding. Having said this, let’s have a look at how we can use latest Webi 4.1 features to quickly build an interactive dashboard without the need of (much) scripting. First of all here is what the final result looks like: You can select values from the left side bar (Product Lines), you can select States by directly clicking into the table and you can switch from the bar chart to a line chart. Here you see it in action: The first step to achieve this, is to create the basic table and the two charts.

Until the dynamic switch is implemented, I placed them side by side. Next add a simple input control in the left side bar: Next thing is to define the table as an additional input control – right click the table and choose “Linking” and “Add Element Link”, choose the two chart objects as dependencies: Next we need to create the “switch” to toggle the two charts.

As I would like to position this switch at the top right corner of the chart, I again use a table input control. May 4, 2012 I’ve just noticed a problem with our. The problem is with eFashion and other MS Access based demo databases, namely that you get the following error in (online) Webi, both on BO 4.0 SP02 as well as with FP3 – due to 64bit connectivity problems: You don’t get the error in Webi Rich Client usually. In this post I will quickly outline the reasons for this and how to solve it: First of all: Others got these errors too: The answers from SAP (namely ) are not really satisfying. Of course it is not very clever to use Access as a demo datasource – but why SAP then provides these (access based) samples in BO 4.0 and not e.g. Within the database they include within the setup?

Anyway, there are three options you can choose:. Move your efashion and other MS Access databases to a “real” database like SQL Server (Express), MySQL etc. It must be just accessible by 32 AND 64 bit drivers.

Migrate to BO4 FP3 – and read the rest of the blog of how you can get Access databases running. If you are on BO4 SP2 – sorry, I don’t know a way how to get Access running on a 64bit driver – if you are interested in the reason, read on (If you know another solution, please post a comment!) In BO 4.0 still all the client tools (like the Webi Rich Client) use 32bit drivers. Regarding eFashion this is not a problem as any default Windows XP / 7 / Server will provide preinstalled drivers. The BOE setup will automatically create the corresponding 32bit-ODBC datasources. Therefore you’re all fine.

On server side it is important to note that e.g. Webi Processing Server always uses 64bit drivers. As far as I can overlook it as well for MS Access. But these 64bit drivers seem not to be installed by default, at least they weren’t on my environments. In addition there is a strange thing that the BOE setup creates both, 32bit as well as 64bit ODBC connections for eFashion and club.The below screenshot shows the 64bit ODBC Admin (trust me 🙂 But be careful: Whereas the 32bit ODBC connections work fine at least on my side I got the following errors when I wanted to modify e.g.

The efashion connection: If you want to create a new ODBC connection you will notify there are no 64bit drivers installed for MS Access: My suggestion to solve this is to go here and download the Microsoft Access Database Engine 2010 Redistributable – because there is a 64bit setup / drivers for this: Download the 64bit setup and run it: Finally your 64bit ODBC Admin “Add connection” dialog should look like this: Now you can create the efashion, efashion-webi etc. Data sources. Make sure you write it absolutely identical as it is written in the 32bit ODBC connection! So far everything works fine for both, BO 4.0 SP02 as well as FP3.

As usual there is a big BUT: You will still get the same errors shown right at the beginning of this post. Remember, you just installed the Access 2010 redistributable. This means you have to change your universe connection to use the appropriate driver (for this log in to Universe Design Tool and choose Tools – Connections).

And here is, where at least I had to say there is no (obvious) way of how to solve it with SP02: Sorry guys, no Access 2010 support in BO 4.0 SP02. But at least FP3 provides something for us: And finally it should work.

To sum up:. On a BO 4.0 FP3 server install MS Access 2010 Redistributable 64bit. Create necessary 64bit ODBC connection. Modify your universe connections to point to the Access2010 driver. have fun with efashion 😉 PS: I don’t have any issues with our BO 4.0 SP02 environment which has SP02 installed only as a Patch.

We installed this environment during ramp-up for SP02 (in these times Webi was still labeled Interactive Analysis, that’s why I noticed the difference) and only later applied SP02. I didn’t investigate, but it seems like Webi Proc servers uses 32bit drivers here (no 64bit drivers for access installed on this system) PPS: Don’t have FP3 available but you ‘d like to test yourself?

I can get you easily access to copy on cloudshare.com – see the corresponding Do you have similar experiences? Any other hint I missed? Please post your comment. RT @: Ab heute kannst du dich in der Pop-Up Gallery in ZH minifizieren lassen. Wir liefern dich dann bald als Figur zu d. RT @: This month of February has exactly 8!

How To Install Efashion Universe Background On Mac

Happy February 😄. RT @: In February 1988 - 30 years ago this month - the first was published in the @ Systems Jour. RT @: Who is going to the in Dublin this year?

Both my and sessions have been selected:. RT @: 'Ability to select multiple items in a report for cross-highlighting' Another top-10 Power BI feature request has just been.

Lesson 4: Formatting Reports Formatting charts Like reports, tables and cells, charts are composed of a number of elements that can be formatted separately. Web Intelligence XI provides all the chart formatting features that you are familiar with when creating professional reports. In this section of the lesson, we will explore a few of the chart formatting features that are available.

Looking at chart properties To look at the chart properties. In the Java Report Panel, build a query using the eFashion universe, and select the Year, State and Sales revenue objects. Click Run Query.

Drag and drop the Vertical Grouped Bar chart template in the new report. Select the View Structure button on tool bar. The document zone switches to View Structure mode. Using drag and drop, move the Sales revenue object to the measures place holder in the chart structure. Move the State object to the dimension object placeholder and the Year object to the optional dimension object placeholder. Click View Results.

The new chart displays as shown below. Click in the bar chart to select the chart.

A gray border appears around the chart to indicate that it is highlighted. Click the Properties tab of the Report Manager. The Properties tab opens and displays the default properties set for the chart you have selected. The Chart Properties tab allows you to change the default formatting of the chart.

Formatting bar charts To make this chart more attractive and easier to read, you can reduce the font size of the Sales revenue values so that they are more in line with the rest of the chart and also modify the size of the chart. To change the font size of a chart element Continue using the report from the previous exercise. Click + next to Display in the Chart Properties tab. Adjust the chart Height and Width so that it is visually more appealing. Set the width to 700 px and the Height to 300 px. Click + in the X Axis zone to expand the X Axis properties. Click + in the Values zone.

In the Text Format zone, click the Browse button to display the Text formatting dialog box. Adjust the default font size to 6 points. The values selected are updated to reflect the changes. To display the value for each bar Continue working with the report from the previous exercise.

In the Appearance zone, click + next to Data, then click + next to Values to expand the Data Values properties. In the Show data values, click the Yes option.

How To Install Efashion Universe Background On Computer

The data values appear above each bar in the chart. Keep the document open. Formatting pie charts In the next section, you will format a pie chart to make it more attractive and easier to read. To display the axis legend Continue using the report from the previous exercise.

Insert a new report into the document. Drag the Pie chart template onto the report. Add the State and Sales revenue objects to the template placeholders.

Click View Results. The pie chart displays in the report as shown below. Click in the pie chart to select the chart. A gray border appears around the chart to indicate that it is highlighted. Click the Properties tab of the Report Manager. The Properties tab opens and displays the default properties set for the chart you have selected.

In the Display zone, adjust the Height and Width of the pie chart. Set the height to 400 px and the width to 300 px. In the Appearance zone, click Yes next to the Show floor option. Change the show floor Wall colour to light yellow.

To display the data values Continue using the report from the previous exercise. Click + next to the Data zone to expand the Data values properties. In the Values zone, click Yes next to the Show data option.

C & Efashion

The data values appear as labels as shown below:. In the Values zone, click Yes next to the Show as percentages option. The percentages appear as labels for the pie sections as shown below: Experiment with the different features available in Web Intelligence for formatting charts. Close the document without saving.