SAP Design Studio and Conditions

Posted by on Jun 8, 2013

I got an email this week from a SAP BI developer about an issue with SAP BusinessObjects Design Studio. He is trying to filter a set of data in Top N categories, for example to get the 10 regions with the highest sales numbers (Top 10).

Unfortunately, in Design Studio we can only create filters on characteristics/dimensions (Vendor, Customer, Region) and not on key figures/measures (Sales numbers). In BEx Analyzer and SAP BusinessObjects Analysis the Conditions options does in fact provide this exact functionality, see the screenshot below.

DScond1

These Conditions can be defined in BEx Analyzer and Analysis, but can also be pre-defined in the BEx Query Designer. Luckily there is a way to use these pre-defined conditions in Design Studio and even change their condition value!

First we’ll have to go to BEx Query Designer and create a Condition in the query. Choose a key figure and an operator.

DScond2

Read More

Posted in: Knowledge sharing, SAP BusinessObjects Design Studio

Xcelsius/SAP BW direct connection HTG

Xcelsius/SAP BW direct connection HTG
Posted by on Feb 23, 2010

With the Xcelsius 2008 sp2 release last year SAP now offers a direct data connection between Xcelsius and SAP BW queries. This is a huge improvement knowing that until this release we needed the BusinessObjects Enterprise, the Universe and QAAWS or Live Office to get our data from SAP BW into Xcelsius dashboards.

SAP published a nice how-to guide, including all pre-requisites needed to setup a connection, a list of BEx query features that do or do not work in Xcelsius and lots of tips and best practices. A must read!

Get it here.

Posted in: Knowledge sharing, SAP, SAP BusinessObjects, SAP BusinessObjects Dashboards, SAP BW, Xcelsius

Webinar: SAP BW/BO integration best practices

Webinar: SAP BW/BO integration best practices
Posted by on Dec 10, 2009

Last night SAP presented a webinar on integration SAP BusinessObjects BI with SAP Netweaver BW. The webinar included best practices on tool selection, report development approach, architectural choices and performance optimization. The upcoming enhancements in the BOE/BW stack were discussed and an overview of successful scenarios was given.

You can now rewatch the webinar here and download the presentation here. In the remainder of this post I dropped the webinar agenda and some interesting slides.

Read More

Posted in: Knowledge sharing