Skip to Content
Author's profile photo Ingo Hilgefort

Visual BI Extensions – Using a “different” Table in SAP BusinessObjects Design Studio

Have you been looking for functionality with the crosstab in SAP BusinessObjects Design Studio but then noticed that the functionality wasn’t there and you were looking perhaps for a slightly different table component ?

Let me give you an overview on some of the features and functions of our Table component as part of the Visual BI Extensions and why we decided to create the table component.

C4A_March_28_007.jpg

The first item you will notice in the Additional Properties of our table component is the fact, that it comes with lots of standard features out of the box without the need to write a single line of script, but instead just a simple click away.

The Table provides the option to activate Search, Sorting, Scrollbars if needed, Text Wrapping, Interactive Filtering, and the option to Freeze the header for larger tables and scrolling.

The option Repeat Members allows you to decide – in a situation where you for example use multiple dimensions in the table – if you would like to repeat the members of the outer dimension or not.


C4A_March_28_009.jpg


Above you can see a screenshot from the table component with the Search option being activated and you can also recognize that the sorting and the interactive filtering has been activated and the user can simply click on the icons in the column header.


C4A_March_28_008.jpg


Above you can see a screenshot of the interactive filtering, where the user is given a list of members based on the assigned data source and has the option to filter the data using a simple click and also has the option to enter a search criteria for that particular column to look for specific members.


C4A_March_28_010.jpg


The Conditional formatting options (Dynamic Alerts) provide the dashboard designer with the option to setup an alert either based on a single measure (example: Revenue > 1 Million), a Measure Calculation (example: Actual – Budget > 1 Million), or a Target Value option (example Cost is between 10 – 20% of the Revenue).


C4A_March_28_011.jpg

In my example I configured an alert based on measure Costs in comparison to measure Net Value and I can then decide if I would like to highlight the actual Value, the Background, or if I would like to add a Symbol to the column….


C4A_March_28_012.jpg

… and then I can setup multiple rules, like in the example where I define the different colors based on the percentage of Cost compared to the Net Value measure.


Another feature the table supports is the Paging that can be configured.


C4A_March_28_013.jpg

Here the user has the option to decide if the page navigation is going to be on the top of the bottom of the page and if the page navigator should be shown in form of buttons (iOS style) or as actual page numbers. In addition the user can decide to repeat the Page header on each new page.


C4A_March_28_014.jpg


And last but not least, the table provides all the formatting options directly in the Additional Properties – no need for trying to find out the style sheet classes – but instead a simple configuration in the Additional Properties can be used to format the table.


Most important – all these features are data source independent and work with BW, HANA, Universes, or spreadsheets as data source.




100 Things you can do with Visual BI Extensions and SAP BusinessObjects Design Studio


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      We are using it in one of the applications and the feature most liked is the ability to search. I think interactive filtering will be a great addition to the application.