Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2010 at 07:40 AM

    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.

    Ben

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2010 at 10:54 AM

    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.

    Regards,

    Stratos

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.