""

New WebIntelligence™ layout in XI 4.0 (Second Part)

In my previous article I gave an overview about the new features and the enhancements in the design and layout of the new release of WebI XI 4.0. In this article I will continue explaining these changes and what they involve.Let’s start by looking at the design area, where we find 5 tabs on the top of the application (“Report element”, “Format”, “Data access”, “Analysis” and “Page Setup”).

The new WebI XI 4.0 tries to centralize similar features in a more logical manner. In such way, under “Report Element", we find the basic elements for the initial design.

This section is divided into 3 areas, where initially we’ll find these tabs: “Table”, “Cell” and “Section”. We won’t find any new characteristic added here, though a significant change lays in the way we interact with the elements.

What is worthy of mention is that we can now insert elements into a table in the habitual drag & drop way or by simply using a new interface to set any of them more rapidly.

The second section is focused entirely on “Charts”. This area has undergone major improvements and we now have many more graphic options to work with. WebI includes new chart types, new properties and other features developers have been expecting for quite some time.

The third section instead is based on how we allocate the report elements. We will therefore find the regular “Turn Into”, “Set as section”, “Order”, “Align” and “Hyperlinks” functions.

Apart from these three sections, if we click on an active report element, a new section pops up complementing the options that are available to us when right clicking over a report element. For example, if we click on a table, we can set up the Breaks or Insert/Remove Rows.

In the "Format" tab we now have a better distribution of all options which are now centralized and easy to access in order for us to format in any aspect our element. Previously all these options were spread across the report and accessed either by right clicking on the element or by selecting from the formatting bar or the “Data” tab.  Moreover, what I believe is well worth of mention is that WebI now adapts dynamically to each formatting option that fits with the selected item. In other words, if we select a cell, the tab is adjusted to modify multiple cell parameters; the same stands for table, report etc.

In the "Data Access" tab we find all the options related to data access and data manipulation. The first section involves working with the query panel (“Data Providers”). We can now create new queries to new data sources. It basically adds a new query to our document with the selected data source. Alternatively, we can edit one of the active queries, do a data purge or even refresh it. Under “Tools”, instead, we can change the data source specifically for one of the active queries or export the data to a flat file, CSV or PDF. The second section called “Data Objects” is where we can create our report data variables or merge specific dimensions.

Under the "Analysis" tab, the related functions are much more consistent. This is the case, for example, if we want to filter the data; now individual reports like “Filters”, “Ranking” or “Input controls” are grouped in one same block. Still under “Analysis” we find “Data Tracking” with no significant developments. The "Breaks" and "Sorts" options are centralized aswell, now grouped under "Display". Special mention goes to the “Conditional” tab, which includes a feature, legacy from the former WebI: “Alerters”. Finally, we can move on forward to the last set of options under the ”Interact“ tab where we’ll find the “Drill”, “Filter Bar” and “Outline” options and, as for the “Functions” tab, we’ll find the default aggregation functions such as sum, count, min, max etc.

The last tab to consider is named "Page Setup". This is one of the parts which I find particularly useful as it is more defined if compared with the old version.

Divided into three parts, the first block manages the reports. No new functionalities have been added here. The second block focuses on the distribution for each page of the report, defining the orientation and the page size, and the “Show/Hide” and “Height” for the header and footer. Finally, in the third block we have a new feature called “Scale to Page” where we can adjust our items either in width or in height fitting them in single or multiple pages. Additionally we can also control the report margins as well as the page display by toggling between quick display and view page.

Last but not the least, we find three new menus “Reading”,”Design” and “Data” that are quite useful.

These are intended to be shortcuts to the three main actions that a developer would carry out in WebI offering different views for each action.  In case we want to evaluate the report results, all we need to do is right click on “Reading” and the “Summary View” will appear along with the report results. If we want to go back to the creation area, we simply click on “Design” and it will display the canvas either in structure mode or populated with data. Finally the “Data” shortcut shows us a nice overview of all the data providers involved in our queries.

I hope you found this second part of my article helpful and insightful. Don’t hesitate to leave a comment or to ask any questions related to the new WebI 4.0 layout and I will readily reply to you.

New WebIntelligence™ layout in XI 4.0 (First Part)

After a long time working on developing reports either with Deski or WebI documents on the old XI 2.0 and XI 3.0 platforms, I was eager to see what new functionalities SAP was able to offer us with the new releases of BusinessObjects 4.0. There are many articles that illustrate the main new features, but I couldn’t find any that would show how the tool looks like and what the real capabilities and functionalities are for a developer. This is the exact and main purpose of this first article; to give real insight into the new fancy application web version in terms of layout.

First and foremost, it is important to clear out the confusion generated around the nomenclature of Web Intelligence. Previously SAP had considered changing this from Web Intelligence to Interactive Analysis; this is why installer name and documentation refer to it as Interactive Analysis. SAP has decided to maintain the original nomenclature and so we shall continue referring to this application as Web Intelligence (WebI).

Web Intelligence

As soon as we select the “Interactive Analysis” button, the application is launched. It is interesting to note that a new tab called “Interactive Analysis” is added to the BI Launch Pad (formerly known as InfoView), next to the regular Home and Documents tabs.

The tab itself offers 3 possibilities, close, pin the tab, and open a new window to maximize the working area. This option is perhaps the most interesting of all as it responds to the long-standing demand from behalf of developers, to be able to work on a larger canvas area without having to pre-configure global options in the BI Launch Pad.

Below the tab we find a greyed out bar with the usual properties for editing and formatting as well as a drop combo box (Interactive Analysis) that will prove to be really helpful to manage the different bars and panes. Momentarily, we can only interact with the “new”, “open a document”, “user preferences button” and “help button”.

The user preferences button offers a new feature on the web version of WebI called "Manage BI services" used to manage the web services available in the hosts. It is also interesting to see that we can open a new a document from the server, either from a folder or a category.

If we decide to create a new document, the application prompts us to create a new data provider by selecting the data source it will be based on. The options available are “no data source”, “universe”, “BEX” and “Analysis View”.

Web Intelligence 2

The new and most significant options amongst these are “BEX” and “Analysis View”. BEX (acronym for Businness Explorer queries) is used to retrieve data directly from the queries mounted on the Infocubes from  SAP BW environment. Instead, View Analysis uses the results from an Analysis workspace, exported as an analysis view and created within an OLAP source system. I highly recommend the reader to explore these possibilities in forthcoming posts.

In this post I will use the everlasting universe efashion as an example.

As you can notice in the below illustration, the query panel isn’t any different from the old query pane in terms of layout.  It is still based on the same interactive functions and we can continue playing with the options to show or hide panels. The main new feature is the data preview panel which provides us with a first preview of the data depending on the objects dropped.

Minor changes are worth being taken into consideration such as for the “SQL” button that has now become the “View Script” button, or the reshaped “Master Perspective” drop down box that basically enables to display the objects sorted by class or by hierarchy. A new handy and interesting option is the new “Close” button offering us the possibility to choose between applying changes and closing or reverting changes and then close.

However the major enhancement of the query panel is one that is not visible. The outstanding feature is that now we can add new multiple queries to our document combining different data sources  (other universes, queries or analysis BEX View) answering a fundamental request from Webi developers.

Web Intelligence 3

The real feel of this being a new product release comes when we run a query and we use the new design mode. The first impression we have is that WebI is in line with the layout of the newest Microsoft Office products. The WebI canvas has experienced a total revolution. The static old bars have made way to a much more logical design using integrated tabs distributed throughout the application, which improves tremendously the usability for the developer. At a first glance, we can identify two main parts, the navigation area and the creation area.

WebIntelligence 4

Let us focus on the navigation area; this too is mainly divided into two parts. The first is the historical file menu where we can create, open, save, and print documents…nothing new. The second is a more centralized area where we can set up global properties at both document and application level. This last level is segmented into 3 parts. The first is the "View" menu, where we can show and hide all toolbars, tabs and panes. Now, we also have the possibility to expand to full screen.  In short, WebI has now more options centralized than the previous versions, which were distributed across the report and the query panel.

Web Intelligence 5

Finally under "Application" we find the same “user settings” present in the previous version of WebI, where we can set up the Measurement unit and the Grid properties.

Still, in the previous WebI, we used to have five tabs on the left hand side of the canvas (Map, Templates, Properties, Data and Input Controls). Now, in the latest WebI version, this part has been totally renewed. This new area is more focused on navigation and customization of the global document rather than the report elements. The first is the summary document which outputs a summary of the main options established in the WebI document. An interesting new option within this section is an area where you visualize the prompts parameters defined in the doc as well as the KeyData. The next two icons correspond to a new partition of what we used to find in the old “map” tab: report map and document structure and filters. Input controls and Available objects (former “Data” tab) present nothing new. Finally the structure is completed with the web service publisher.

I hope you enjoyed this article and that it has allowed you to gain a better understanding of the new WebI layout. Stay tuned for the second part of this article for more insight on what’s new in WebI.

Don’t hesitate to leave a comment or ask for clarifications and I will readily reply to you.

SAP Business Objects XI 4.0 Release: Connecting to OLAP data sources

In March the new SAP Business Objects 4.0 release came to the scene containing a lot of new interesting features. Today I’m going to describe how to configure a connection to an OLAP data source by using some of the new tools and features in SAP Business Objects XI 4.0. In order to successfully follow the instructions outlined in this article, it is best to ensure that the below prerequisites are met:

  • Windows Server 2008.  The server configuration needs to be enabled as a Web Server (IIS) role.
  • SAP Business Object XI 4.0.
  • SQL Server 2008 & Microsoft Analysis Services. The example database “Adventure Works” should be installed and the OLAP cube’s examples deployed in Microsoft Analysis Services.

Setting up the OLAP Connection

First of all, in order for you to create an OLAP connection you will have to configure IIS to provide you the access to the OLAP cube stored in Microsoft Analysis Services.

Configuring IIS

Just follow these steps and you’re on track:

1.  Firstly we create a folder called “Olap” in the root path of IIS in the machine, by default the path should be: C:inetpubwwwroot

2.  Copy the files required to create the connection with Analysis Services. These files, which are set as a default installation of SQL Server 2008, are stored in the following path:

C:ProgramFilesMicrosoftSQLServerMSAS10.MSSQLSERVEROLAPbinisapi.

Copy all files contained in this folder and paste them in the “Olap” folder which we have created in step 1.

At this point, this is what we should be able to visualize:

XI4
XI4

3.  Launch Internet Information Services (IIS) Manager. You will find it in Control Panel under Administrative Tools.

SAP XI 4
SAP XI 4

4.  In the Connection panel we then open the tree of sites. We right click in Application Pools and select the option Add Application Pool.

SAP XI 4(2)
SAP XI 4(2)

5.  This is how the configuration of the pool should appear to us:

SAP BO XI4
SAP BO XI4

6.  Now, within the list of  Application Pools available to us, we are able to see the Olap pool. Simply right click on the Olap pool and select Advanced Settings. Once we have reached this setting, it´s extremely important that we set the option "Enable 32-bits Application" to FALSE. This is a critical step because, unless this option is set to FALSE, the connection won’t work.

SAP BO XI4
SAP BO XI4

7.  We continue by right clicking in the Olap site and selecting the option Convert to Application.

SAP BO XI4
SAP BO XI4

8.  In the configuration window we press the Select button and choose the Application Pool that has been created. This is how the configuration should appear:

SAP BO XI4
SAP BO XI4

9.  Now select the Olap site in Connections. In the right panel we will be able to see different categories. Double click in Handler Mappings.

10.  On the upmost right section of the panel you will now be able to visualize the Action’s panel. From here select Add Script Map. A configuration panel will pop up, and this is how it should appear to us:

XI4
XI4

11. Now we proceed to setting up the Configuration of Authentication. Click in Connections in the Olap site and double click on the Authentication category which is in the right panel.

12. In the right panel you can now see the types of authentications available. Right click on Windows Authentication and enable.

SAP BO XI4
SAP BO XI4

Configuring Analysis Services 2008

Now our following step consists in configuring the Analysis Services which means having to modify the security settings. This is why if you follow the instructions in this article to setup a production environment please check your security implications. For more information on this matter please click here.

1. Launch SQL Server Management Studio and connect to your Analysis Services Server

2. Right click on the server and select Properties.

XI4
XI4

3. In the left panel select the option Security.  In the right panel we can see the Server Administrator. Click on the Add button in the lower left part of the window.

4. Type the name IUSR in the box and press Check Names. Finally press OK.

5. Now we can see the account IUSR in the list of Server administrators.

XI4
XI4

Connecting SAP Business Objects XI 4.0 to OLAP

There are various ways to creating a new connection in SAP BO 4.0 and accessing the OLAP cube. In this article we are going to focus on the use of a new tool introduced in SAP BO 4.0 called the Information Design Tool (IDT). The IDT is the SAP Business Objects design environment for creating and publishing new SAP Business Objects universes and connections. To finalize the process we’ll create a new OLAP Universe using the Universe Design Tool and lastly create a simple report with Web Intelligence 4.0 which will allow us to test the access to the data source.

Creating the OLAP Connection

Proceed in the following manner:

1. Launch the Information Design Tool

2. Create a New Project, go to File, New, then Project

3. Enter the Project Name, the location (optional) and press Finish

4. Go to File,New, OLAP, Connection to start creating the connection to the OLAP data source.

5. Enter a Name for the connection, a description (optional) and press Next

XI4
XI4

6. In the next screen we have to select the driver for the connection, in our case Microsoft Analysis Services 2008, and Press Next

7. Enter the parameters of the connection, this is what you should be visualizing:

XI4
XI4

8.  Select the cube for the connection and press Finish.

XI4
XI4

If you have managed successfully in your task thanks to following these steps, you have been able to create a new connection and now all that is left is for you is to publish this connection in BO. This is how it is done.

1. Right click in the new connection and select the option Publish connection to a Repository

2. Enter the credentials for connect to your BO repository and press Connect

3. Select a location for the connection and press Finish.

Creating an OLAP Universe

For testing purposes we are going to create an OLAP Universe using the new connection.

1. Launch Universe Design Tool and enter your credentials to access the server

2. Go to File, from there to New

XI4
XI4

3.  Enter the parameters of the universe, select the connection created and press OK. This is how it should appear:

19
19

The universe will automatically load the structure and objects of the cube.

XI 4
XI 4

Creating a Report Web Intelligence

Once all this has been done, let us look into creating a Report Web Intelligence:

1. Launch Interactive Analysis Desktop

2. Select the Universe

XI 4
XI 4

3. Enter the credentials to access to your BO server

4. Select the Universe created and press Select, in our case the set example is OLAP Universe

5. Create a Query and press Run Query.

XI 4
XI 4

At this stage, having accurately followed these steps, we should now have a new report displayed in front of us, allowing us to use the Universe which we have designed with the OLAP connection, to access the information in the cube stored in Analysis Services 2008.

XI 4
XI 4

I hope you found this article of your interest and for any suggestions or queries regarding SAP Business Objects XI 4.0 please leave a comment and I will readily reply to you.

Making peace with the enemy: SAP BusinessObjects Live Office XI 4.0

The most common scenario that I’ve  faced with so far, after quite some years giving BI pre-sales presentations and implementing BI systems for customers, has been that of meeting members of an overloaded IT department who direct their efforts into developing complex reports with BI tools for a group of business users who, in the end, will simply export the information delivered to them to an Excel sheet and work on it directly.

For decades, most BI vendors have tried to convince users to give up Excel sheets and instead work with more flexible and user friendly BI tools. But it’s an acknowledged fact that nowadays millions of people around the world use spreadsheets on a daily basis. The time has come for vendors to take off their blinders and to act upon what is happening. Already some have been readjusting their strategies and roadmaps, and have shifted towards accepting Excel as a presentation layer for data thereby providing the necessary integration with it.

This article is about how SAP BusinessObjects tackles this challenge and goes one step further in terms of tools integration thanks to the new features of the latest release XI 4.0.

With Live Office, it is possible to insert content from Web Intelligence, Crystal Reports and also Universe Queries directly into Microsoft Office documents (PowerPoint, Word, Excel or Outlook). Furthermore, when opening the very document at a later time, it is possible to refresh the embedded objects and retrieve up-to-date data in the document.

This is truly an advantageous solution and I have had the opportunity to use this technology with some customers, who continue employing their traditional form of reporting with an Excel sheet but can now combine this with error-free data obtained directly from their business systems.

In the latest release of Live Office, a new functionality loads the data selection of Microsoft Excel to SAP BusinessObjects Explorer, a flash-based tool that allows further analysis in a very visual and intuitive way. Moreover, the results from a completed analysis can also be downloaded to other applications, such as Outlook and PowerPoint to further the study or to simply send by email.

Live Office XI 4.0

If you have any questions regarding Live Office XI 4.0 and its uses in a customer environment, feel free to leave a comment and I will follow up with you.

SAPPHIRE NOW Connects to SAP World Tour Events in Four European Cities

SAP AG will host its annual conference, SAPPHIRE NOW, in Orlando, Florida, from May 15 - 18, 2011. Building on a record 2010 attendance of 50,000 customers, partners and employees on-site and online, SAP will connect this year’s conference to four regional events in Europe. Delegates to SAP® World Tour stops in London; Moscow; Brussels, Belgium; and Lausanne, Switzerland, will have the opportunity to meet with SAP executives from regional leadership teams and local customers and partners to discuss the product and technology updates being presented at the event. Attendance at the four events, which take place on May 18 (May 17 - 18 in Lausanne), is expected to exceed 3,000.

How to organize a meeting between two relatives who don’t know each other: connecting Strategy Management with Data Services

As promised in our previous SSM article, I will now walk you through another interesting objective we have achieved while working on our SSM project: populate Strategy Management KPIs with a Data Services job.

Currently SAP BO SSM does not provide a connector to SAP Business Objects tools even if both SSM and Data Services are SAP BusinessObjects products.

The solution we designed for our customer in UAE provides them with the option of loading the data from any source into SAP BO Data Services and of finally dumping the values into an SSM PAS Cube (via E&A PAS schedule).

The solution recommended by SAP for its latest version currently in use, SSM7.5 SP08, allows loading the data into the PAS cube by creating an IDQL script.

The concerns we were faced with in our project were related to the actions required for the maintenance of IDQL (scripting language).

For a non-trained customer, IDQL sounds like a black box and sets off many alerts especially when it comes to maintenance.

I was caught in the midst of a question storm which ended thanks to our “problem solving attitude” and rapidly blew off all questions.

It didn’t take us long to learn how the SSM data model works for the KPIs as we had already studied them while working on the initiative.

The first step taken consisted in creating a cube in the SSM “Cube Builder” console. From here we proceeded to mapping the KPIs ID that we have in SSM SQL and in our original source (i.e. ERP, Excel, and Other DBs).

The process of creating a source and sending it out with a data integrator was a straightforward and pleasurable task and has delivered great results.

Now, this solution allows me not only to insert the current data but to introduce the historical data just as well, it’s absolutely fantastic!!!!

I was able to visualize in my “Entry and Approval” panel the data I was inserting on an excel file and on the ERP tables.

At this point my data was not added into the “Balance Scorecard” yet, so the last action I had to perform was that of publishing those values.

I used the “Entry and Approval” scheduler that was running right after the ETL job.

Reached this stage, I had my SSM Context populated with my values.

In the image displayed below I have outlined the steps we followed (IDQL is marked in red since it hadn’t been utilized throughout this process) and as you can clearly notice, we are now capable to create reports and dashboards from the SSM Database by generating a universe on top of the SSM tables. 

Integrating SSM with Data Services

  Please don’t hesitate to contact us at info@clariba.com for more information about this article or for SSM consultancy.

Sewing the initiatives on a customer’s strategic suit (with SAP SSM 7.5)

All through my ongoing project in Abu Dhabi, I have never turned down any of the challenges that arise while working with my customer. The project in question involves the customer looking through the tools I propose as if they were a collection of nice suits, but all in the wrong size.

At this stage we need to proceed like a tailor would: we can’t presume that our customer is going to lose/gain the weight to fit into the clothing we want to sew for them, but rather we need to tweak the outfit here and there until we get the perfect fit for our customer.

We would never think of recommending a diet and most certainly wouldn’t add more stitches to their outfit. Today what is most pressing is that we talk about our customer’s strategy, and how to adapt SAP Strategy Management (SSM) to our customer’s needs.

One of the requests I have received is related to the implementation of the Initiatives.

But what does "Initiative" mean? According to strategic management experts Kaplan and Norton, "an Initiative organizes people and resources and dictates which activities are required to accomplish a specific goal by a particular date; Initiatives provide the how while goals provide the what."

During a demo presentation of SSM, as I was illustrating the properties of Initiatives, my customer asked me: "What if the Initiative depends directly on the achievement of the last milestone? What if I want to consider an Initiative as green (ok) even if the first milestone has not been achieved on time but the rest of them were met ahead of schedule?"

As always, the quickest and easiest answer would be "it is not possible", but our sales mentality automatically converts that answer in "it is not an out-of-the-box solution provided by the tool". No matter how you put it, the customer wants to hear that "it is possible".

Which answer did I give to the customer? Well, whatever I said, now the customer knows that it is possible to configure the Initiatives as sequential.

So let’s check what we did to create our sequential and not sequential Initiatives (based on sequential/not sequential milestones).

Initiatives (sequential milestones, not sequential milestones)

  • Sequential Milestones: The status of the Initiative needs to be synched up with the status of the last Milestone. The status of the other milestones will not affect the schedule status of the Initiative (i.e. the delay of the milestone does not mean a failure of the Initiative whether or not the last milestone will be achieved on time).

 

 

  • Non sequential Milestones: The status of the initiative will be set as not achieved even if only one of the milestones has not been achieved. Out of the box solution with SSM.

 

 

Validation Rules

  • The milestones values can't be meaningless based on user input. I.e. 40% complete without setting an end date or 100% complete with no end date (2nd case more acceptable).

The big question that arises after having explained what we solved is: “how did we solve it?” Basically, we managed to interact with the SSM tables when a new Initiative is created (based on rules).

General Rules: We manage the percentage and the end date of the milestones to avoid the following scenarios:

  • Milestone 100% completed without setting an end date: Populate the end date with the actual date whether the percentage is equal to 100%.
  • Milestone <100% completed with an end date already set: Automatically change the percentage to 100% as soon as an end date is set.

Sequential Initiatives:

  • The user needs to write the word “@Sequential” at the beginning of the description of the Initiative. The tool will automatically apply the rules defined by our customer and by us.
  • We apply an end date to the Initiative and a status color based on the results of the last milestone.

Non-Sequential Initiatives:

  • The user can write a different description than "@Sequential" and SSM will automatically behave as set out-of-the-box.

This solution adds value to Strategy Management and helps our customers feel more comfortable in a suit which is tailored to fit their needs. This solution can be applied to SQL server, MaxDB or Oracle installations.

For more information/consultancy on this or any other custom solution with SSM, please contact us at info@clariba.com

Loading Status Animation in Xcelsius

Often when developing a dashboard with Xcelsius we have connections to a DataBase, either with LiveOffice or QaaWS (Query as a Web Service). This leaves us with only two options to refresh our dashboard: either we proceed once all the Xcelsius components are loaded or, alternatively, change a radio button, combo box or any of the components related to the connection objects. In both these examples, when having to manage large amounts of data, we would normally wait until the connection returns our request. This can be frustrating, especially when we don’t have any indicator to signal that the data is being processed. In this article I will illustrate a convenient solution to this problem.

  • First of all we need to create the objects that will be displayed while the query is loading the data: I would advise to start by creating a rectangle as a fake layer. Once this has been done we create another image that will be our animation.

We have many possible animations:

View the flash file: Loading Animations in Xcelsius

This is how the animation appears:

View the flash file: Xcelsius Animation

  • We then group these two objects and bring them to the front.

  • In a spreadsheet we create a cell where we bind the status of the query.

  • Reached this point, under properties in QaaWs or in Live Office connection we follow these steps:

In the Usage tab:

Load Status section:

  1. In the Loading Message cell we hardcode a "L"
  2. In the Idle Message cell we hardcode a "C"
  3. In the Insert In option we should map the cell of the spreadsheet, in our case "B1"

  • Finally we select the group that we had previously created, and in the dynamic visibility window we map the Status to the "B1" cell and the key to an "L". This means that while the query is loading, we can simultaneously view the group.

The final result is as displayed below.

This strategy contributes to providing a user friendly environment in particular in those situations of slow data retrieval.

If you have any questions or suggestions about this solution, please feel free to leave a comment and I will gladly reply.

Join Clariba and SAP for the Better Business Insight Events in Doha, April 18 and in Dubai, April 20

Dubai, UAE: Clariba and SAP Middle East & North Africa are proud to be hosting two unique events in Doha, April 18 and in Dubai, April 20 for C-level executives, IT decision makers, and business managers. The purpose of these sessions is to provide an in-depth look at best-in-class business intelligence solutions in the Middle East and the exciting release of SAP BusinessObjects BI 4.0.

In a highly competitive global market, marked by the momentum of mobility solutions, businesses are continually confronted with the need to act decisively on growing volumes of data and make rapid decisions wherever they are.

New Class of Analytics: Clariba and SAP offer the first opportunity for business and IT professionals in the Middle East to view the benefits of SAP BusinessObjects BI 4.0, which delivers the most comprehensive suite of BI tools on the market. The 4.0 release of Business Intelligence incorporates the speed of in-memory computing, the mobility of BI on any device and the accessibility of business and social data, allowing for better information management and business insight.

Real Business Results: Clariba has become a recognized and respected Business Intelligence consultancy and SAP partner in the Middle East by working closely with decision makers in finance, sales, marketing, and other functional areas to develop comprehensive analytical solutions across multiple industries. These events also provide attendees with the chance to learn about real business results from influential organizations in the UAE and Qatar.

“As leaders in Business Analytics technology and implementations, Clariba and SAP are ideally positioned to highlight the latest innovations and strategies for better business insight,” explains Marc Haberland, Managing Director of Clariba. “The combination of Clariba’s best practice approach and the power of SAP BI tools provide our customers with a distinct competitive advantage.”

The Better Business Insight with SAP Business Objects BI 4.0 and Clariba event will be held in Doha, April 18 and in Dubai, April 20 from 09.00 to 11.00. Business leaders and  IT professionals interested in discovering innovations that are shaping the future of analytics are invited to contact Clariba for more information by emailing events@clariba.com or calling +971 50 100 7441.

About Clariba Clariba delivers innovative, reliable and high-quality business intelligence (BI) solutions to customers worldwide. We are recognized and respected as one of the leading SAP Business Intelligence consultancies in EMEA. Our consultants, based in the Middle East and Europe are SAP BusinessObjects certified professionals and experts in the planning, installation, development and deployment of BI solutions. Clariba develops best practice BI solutions for dashboards, reporting and analysis, providing our customers with clarity and actionable insight to improve their business performance. Our customers in the Middle East are leaders in the telecommunication, education, manufacturing, and banking sectors. By working closely with business leaders and IT teams, Clariba turns vital data from ERP, CRM and other transactional systems into actionable insight for all levels of the organization. For more information on Clariba’s business intelligence solutions visit www.clariba.com

About SAP As market leader in enterprise application software, SAP (NYSE: SAP) helps companies of all sizes and industries run better. From back office to boardroom, warehouse to storefront, desktop to mobile device – SAP empowers people and organizations to work together more efficiently and use business insight more effectively to stay ahead of the competition. SAP applications and services enable more than 109,000 customers to operate profitably, adapt continuously, and grow sustainably. For more information, visit www.sap.com.

Creating Dynamic WebI Documents

Often we are forced to find a solution to make our Web Intelligence reports more dynamic, because of a specific user need or for the purpose of sales demos. In this case we can add some interactivity to make our presentations livelier and more visually appealing. In this post you will find some examples for achieving more dynamic WebI reports that don’t come with the out-of the-box WebI standard module:

  1. Dynamic columns
  2. Hiding and Unhiding blocks
  3. Hiding and Unhiding blocks in sections

The techniques explained below are valid not only for tables but also for graphs.

1. Dynamic Columns:

The purpose of this technique is to change the value of a dimension column according to a selection from its input control. Below you will find the high level guidelines for creating dynamic columns:

  • Create a dummy table in the Universe; ideally a derived table with the name of the descriptions you want the user to display and to show in the document. You can see a sample below:
Dummy Table WebI
Dummy Table WebI
  • These dynamic variables should come in a separate Query and be linked with the real data coming from a second Query. Alternatively all data could come from a single Query. If the variables and the data to present are not linked, our solution will not work.
  • The next step is to create the Input Control making sure that the filter applied affects either the entire report or a specific table, depending on where the dynamic columns are located.
  • Once we have all this, we need to build the table or block where our "Dynamic Column" will be located and build a conditional formula with IF and ELSE features. Using our example, if our dynamic variable is called Input control, if the information we want to show is located in the Period table and if the dynamic source fields are Month, Week & Day, then the formula should be the following: =If("inputControl"="Month";[Period.Month];If("inputControl"="Week";[Period.Week];If("inputControl"=”Day”;[Period.Day]))) Make sure the formula sentence is properly defined so that a meaningful result will be displayed when the user applies the "All values" option.

For a more detailed explanation on this topic you can check the Clariba blog article:  How to Use WebIntelligence Input Controls Efficiently from 22nd January 2011 at www.clariba.com/blog.

2. Hiding / Unhiding blocks

  • The purpose of this technique is to hide one table and show another with dimension columns by changing its value according to a selection from its Input Control:
  • Create a dummy table (like in the example above) with the options we want to show to the user and for the purpose of linking two Queries (i.e. with the word “LINK”)
  • Create a table with all the data you want to show.  After that, it is necessary to uncheck one of the properties that our block/table has by default. Select the proper block, go to properties, deploy the "Display" option and make sure that the "show when empty" property is not active.
  • The next step is to create the Input Control, making sure that the filter applied affects the entire report.
  • Next we need to play around with the filters for the different blocks. The object with the word “LINK” needs to be used like a filter for every single block (equal to). After that we apply a filter with the object we used before for the Input Control, making sure that the option for this filter is “not equal to” the value that corresponds to the actual table. We need to do the same with all tables.

3. Hiding / Unhiding blocks in sections:

Imagine we have a report where we want to split a trends table into sections showing the trends in "Months", "Weeks" and "Days". The section could be too long and the user may not want to scroll down to find a specific one.

  • In this case,  we would make three different tables, one for Months, one for Weeks and the last for Days and place them in the section, making sure that we change the names on the top of the table so that users can  easily recognize them.
  • Select the different blocks and disable "show when empty" selection from the properties. Create three different Input Controls with all values, one for every possible trend. Establish connections between these and their corresponding table.
  • Make sure that the Input Control has one value by default, so only one table is visible. This way when the user makes a selection in a single "trend" Input Control, the corresponding block will be displayed correctly; whereas if the user deselects all the options in the Input Control tables, all the blocks will be visible.

The techniques explained above were developed by our team of Web Intelligence developers to provide business users with the added value of interactivity in their queries, analysis and navigations.

If you have any questions or feedback about these solutions, please feel free to leave a comment below or send an email to info@clariba.com