Showing results for 
Search instead for 
Did you mean: 

Single Crystal Report based on Five different SAP BEx Quries.

Former Member
0 Kudos


I need to create 5 different Charts (in a single report) based on five different SAP BW BEx Queries. These are charts with 3- axes i.e. X,Y,Z.

The example requirement is to create Line charts (Vertical Mixed Line Charts) and deatils are as follows: The chart should show CPU Utilization % for different servers (eg. Servers1,2,3,4,5) for each day in a particular month.

Axes details:

X- Axis - Date eg: 01 /09/2010 to 30/09/2010

Y-Axis - CPU Utilisation Percent

Z-Axis - Servers from 1 to 5

The above detailed chart comes from a BEx Query . In this way there are four more BEx queries which should give four other charts.

My queries are:

1. Is this possible to create a single report using five different BEx queries and Create 5 different charts(one chart from each BEx Query) in a single tab as in the current manual report.(All the five Line charts should be downloadable to a single sheet in Excel)

2. One more, should I use Crystal Reports only? The charts are of high format natute so Web Intelligence will not produce the same. Is any other tool that helps for this requirement.

3. I can create five different Universes based on BEx Queries. Is this possible to create a single report from five different Universes.

Please advise.

Nanda Kishore.

Edited by: Nanda Kishore B on Oct 21, 2010 8:05 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

To start with you cannot use SAP BW universes in Crystal Reports., YOu have to use the BW MDX driver.

For performance reasons I would suggest to add 4 subreports into your main reports containing each on of the 4 remaining charts.



Former Member
0 Kudos


Former Member
0 Kudos

Hi Nanda,

Have you already solved this problem.It seems more flexible of Multi-asis.In my opinion ,It seems easily to complish in xcelsius.And except your solution.


Former Member
0 Kudos

Hi Yanging Wang,

Could you please detail me more.

I still have this issue.

Nanda Kishore B