BEx Query Designer
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.
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.
Knowledge sharing, SAP BusinessObjects Design Studio
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
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.Knowledge sharing