Crystal on Bex Query - getting only summary data

[Former Member]

Hi Gurus,

I am building crystal report on Bex Query using BW Query Driver ( i have no other choice, client experiencing issue in MDX driver and this report has to be done ASAP)

When i use the Bex objects in the crystal report, the result i am getting is just the summay data not the details

Example

The bex generate 3 dealers data i am not getting data for three dealers instend i am getting summary of all three dealers

Can anyone please help me out to get detail data.

Thanks

Vijay

[IngoH · Accepted solution]

Hi,

are you comparing the same level of characteristics and keyfigure.

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Thanks for your time,

Yes, I am using same level of characteristics and keyfigure, I donno much about BW. Basically i am BOBJ guy.

I have the Bex query result in Excel. which has basic view of data like

Dealer:1000 $23456

Dealer:1001 $34543

Dealer:1002 $56789

Overall Result $114788

But my report shows only the Overall Result data

Null $114788

Please help me out

Thanks

Vijay

[IngoH · Accepted solution]

Hi,

which fields are used in the Crystal REports report and where ?

ingo

[Former Member · Accepted solution]

Hi Ingo,

Once again thank you for your time.

I am using the dealer number, Dealer name and Reveneue in the crystal report and i placing them in details

Is anything i have to do changes in Bex Query

Thanks

Vijay

[IngoH · Accepted solution]

HI,

can you take the MDX statement from Crystal REports (in the menu Show SQL) and run the MDX Statement in transaction MDXTEST ?

what is the result ?

Ingo

[Former Member · Accepted solution]

Hi Ingo,

Since the client has problem in MDX driver and working on it past 2 weeks, I am using the BW Query driver to pull the BW query into the report

The SQL i am getting in report is

SELECT * FROM [Query Name]

Please advice me

is that because of BW Query driver i am getting Summary data in the report?

Thanks

Vijay

[IngoH · Accepted solution]

Hi,

as mentioned before the BW Query Driver has already been deprecated and should not be used anymore. The driver will not be there in 4.0 anymore.

You have to use the MDX Driver

ingo

[Former Member · Accepted solution]

HI Ingo,

Thanks for your advice, already informed my client.

Do we have any SAP docs which recommands to use MDX driver not the BW Query.

I will highly appriciate if you gave me the link for the doc so that i will provide to the client. I can'r able to find in the help.sap.com

Thanks

Vijay

[Former Member · Accepted solution]

Hi INgo,

I gone through one of your posting, taking about structure in Bex query will get single row of data in the crystal report.

In my case the bex query has the Stucture for the time dimention in the column and i am using BW Query Driver, Is that the reason i am getting single row of data in the report if so, Can anyone please advise me how the Bex query has to design so that i will get all my data in to the report.

Can someone please help me

Thanks

Vijay

[IngoH · Accepted solution]

Hi Vijay,

we are always coming back to the same point here. The BW query driver is already deprecated and should not be used. Items that I am describing are all based on the MDX Driver.

ingo