Skip to Content
Author's profile photo Tammy Powlas

Design Studio Cookbook for Dashboard Users – ASUG BusinessObjects Conference

This was an SAP session at the ASUG BusinessObjects User Conference by SAP’s Ian Mayor.  The room was standing-room only, like many of the sessions at this conference.

1ian rule.png

Figure 1: Source: SAP

An example in Figure 1 to insert multiple queries you need to use Excel formulas like HLOOKUP, VLOOKUP for XCelsius

He said this was easy to do in Design Studio where you can change the query on the fly

However it is easy to manage layout, formatting,  and make it “look pretty” including font size, colors – XCelsius

Style sheets and scripting make things more complex in Design Studio

There are not as many components in Design Studio than XCelsius


Figure 2: Source: SAP

Figure 2 explains some key differences but even better is the figure in Figure 3.


Figure 3: Source: SAP

Figure 3 shows the data pipeline

When accessing data through the universe it is like Web Intelligence as it uses micro cubes as a data source, whereas if using the BEx query it uses the Query as a data source


Figure 4: Source: SAP

There was a slide that “style sheets are your friends”.

Create a standard style sheet file, standard, type title, if design standards change, change master file

There is no CSS editor, there are lots of good editors for free on the web (he showed

He suggested learning developer tools in browser


Figure 5: Source: SAP

The message for Figure 5 was “don’t fear scripting”.

The CTRL-SPACE wizard helps.


Figure 6: Source: SAP

Figure 6 shows how Design Studio scripting can be simpler than an XCelsius formula using Lookups

CSS tips (shown through a demo):


In Chrome, when testing CSS, disable cache in developer tools so you can see the CSS refreshed


Figure 7: Source: SAP

There was a brief discussion on this with a suggestion to leverage the SDK.  To learn more I recommend attending SAP TechEd && d-code session EA 211 SAP BusinessObjects Design Studio SDK with former SCN member of the month Mike Howles

Question & Answer

Q: Why drop XCelsius, a product that has been around 12 years?

A: Encountered architectural issues with Flash and Excel model

Online Resources:

BI Tutorials:

Online Documentation:


Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions

Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference – register here

Assigned Tags

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

      Good information. I agree with many of these slides!  I look forward to those coming to TechEd who are brave enough to attend my SDK session!  😀