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

/wp-content/uploads/2014/09/2keyarch_548882.png

Figure 2: Source: SAP

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

/wp-content/uploads/2014/09/3pipeline_548883.png

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

/wp-content/uploads/2014/09/4cssstylesheets_548884.png

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 enjoycss.com)

He suggested learning developer tools in browser

/wp-content/uploads/2014/09/5fig_548885.png

Figure 5: Source: SAP

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

The CTRL-SPACE wizard helps.

/wp-content/uploads/2014/09/6fig_548886.png

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):

Use enjoycss.com

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

/wp-content/uploads/2014/09/7fig_548887.png

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: http://sap.com/learnbi

Online Documentation: http://help.sap.com/boad

Related:

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. 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!  😀

    (0) 

Leave a Reply