BW
SAP GUI sessions 101 (updated)

The SAP GUI is the first application I start in the morning and the last one I close at the end of the day. Most of the time I use multiple sessions on multiple systems. Last week @pverstraeten saw me closing all these sessions one-by-one and showed me how to do this the right/fast way: Just type /nex in the transaction field. Thanks!
Update (11-2010): I added two fast shortcuts. TFTT @ron_nooren and @jurjen_heeck!
I listed the ‘session commands’ below:
/o Display list of all sessions
/o + transaction Open transaction in new session (/orsa1)
/n End transaction and go back to SAP Easy Access user menu
/n + transaction Open transaction in same session (/nrsa1)
/i Close current session
/i + number of transaction Close specific sessions (/i3)
/nend Close all sessions with prompt
/nex Close all sessions without a prompt
CTRL + (plus key) Open new session
CTRL / (forward slash) Put cursor in command field
Posted in: Knowledge sharing, Lifehacking, SAPSAP: “BEx Analyzer sucks”

When I first got into SAP BI a few years ago I followed this course on SAP BW 3.5 which took like 10 days or maybe even more. I do remember the first time I saw and used BEx Analyzer, the MS Excel plugin to view and analyze data from SAP BW. I was just shocked to see such a terrible user interface design and a tool that was not intuitive to use at all! And people were supposed to use this app for their daily work? OMG.
SAP now released a video that basically says that BEx Analyzer sucks. Too complex, too much end-user training needed, to much complaints, too expensive and so on. The solution? SAP BusinessObjects Analysis edition for Microsoft Office.
Have fun watching it.
Posted in: SAP, SAP BusinessObjects
More HTG from SAP: Setting up authorization for Xcelsius in SAP BW

SAP really is on a roll this month, publishing just another how-to guide on Xcelsius and SAP BW. This time the HTG covers the creation of authorization objects/roles that are required to view/create/change/deploy Xcelsius dashboards. This is now possible with the new authorization object for Xcelsius dashboards: “S_RS_XCLS”.
You can get this HTG here.
Posted in: Knowledge sharing, SAP, SAP BusinessObjects, SAP BusinessObjects Dashboards, SAP BW, XcelsiusMore HTG from SAP: Xcelsius transports in SAP BW

As mentioned in the previous post, with the new SAP BW integration in Xcelsius (Xcelsius 2008 sp2 or higher) we now have the possibility to use some features of SAP BW directly. We can now publish a Xcelsius dashboard back to the BW system and store it as an object (of type XCLS) in the BW system. These XCLS-objects could be transported to different system in the landscape, in the same way as any other standard BW objects (InfoCube, DataStore Objects etc).
SAP published a how-to guide on this subject. Get it here.
Posted in: Knowledge sharing, SAP, SAP BusinessObjects, SAP BusinessObjects Dashboards, SAP BW, XcelsiusXcelsius/SAP BW direct connection HTG

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