More than one SAP-BW Query

A normal Profit and Loss statement usually contain some Revenue portion, and some Cost portion, and most of the time, there's a section where you deduct the cost to get the net profit yada yada yada.

But to do that in SAP Business Explorer proves quite a challenge especially if the row is in some sort of hierarchy format. The work around this is, yes, you got it, to combine 2 or more query into one worksheet, to create the "illusion" of having it all in one statement.

So how do you combine more than one query into BEX? Simple. Follow this step:
  1. Click on "Tools" icon.
  2. Select "Insert Query..."

and Walla! You got more than one query into your workbook. Don't forget to save the workbook for later use.

See, nifty trick eh? But a better solution would be a way to have a calculated row that computes from the revenue portion, and the cost portion. Any SAP Guru out there willing to give some tips on how to achieve this? Oh well. For now I guess I have to be contented with this sort of "hack" :)


Thu May 08, 07:27:00 PM 2008 Naveen Kumar said...

Folks: Check out the site www.RamBPS.Com this has some good articles and step by step cook book kind of information on SEM BPS, BW and other stuff. The site also has some good best practices for Budgeting, Planning of capital & O&M etc.

Either click on e-book or download link. All the information is in PDF and the registration & articles are FREE. That’s too cool.

Hope it helps.