Single Crystal Report based on Five different SAP BEx Quries.

Hi,

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