Crystal Report on a big cube

[Former Member]

Hi,

We are trying to create a Crystal report on a large cube 7 millions row in fact tables.

There are multiple dimension, some with several millions as well.

The report will use filters on Navigational Attribute of the dimensions.

I tried MDX query, it run for a while and give database error.

No more storage space available for extending an internal tablee.

This is because it's running as dialog (DIA) in SAP BW.

Is there a way to run this query as background in BW so we'll have more time and memory?

I know we can do this with Infoset and OpenSQL driver by setting Windows Environment variables,

but those are not for cubes.

Our system is SAP BW 7.01 EhP1 SP5.

Crystal Report 2008 SP2

BOE 3.1 SP2 (we'll schedule crystal reports on BOE)

Any help would be greatly appreciated.

Thank you,

Henry Le.

Edited by: Henry Le on Mar 14, 2010 12:43 AM

[IngoH]

Hi,

the error has nothing to do with a dialog process. the error indicates that you are running out of memory. Are you trying to show all data from your cube in a report ? Remember that Crystal REports is a reporting tool and not an ETL tool.

Ingo

[Former Member]

Hi Ingo,

Thank you for your quick response.

There are 2 requirements:

1) Summary report

2) You were right, extract lot's of data. I think BW limit to about 0.5GB for this right?

For 1) I will try to simplify the report, reduce number of rows coming back to see if it works.

For 2) we need to extract such data then load to Oracle for the business to do analytic on. We know that this is not standard SAP practice, and decided that this is only an interim solution till we have all requirements and move the reports, analytic back to BW - BOBJ route.

The extract expected to be 6.5 millions rows with 70+ fields. 3.5GB to 5GB of data.

_ OpenHub - not fit because to my knowledge Open Hub does not support Navigational Attributes

_ We have Data Services 3.2 - I can try to join the transparent tables (the cube's fact table and dimension tables for Navigational Attributes) and load directly to Oracle.

_ We also have Data Federator 3.0 SP2 - but I heard Data Federator does not fair well with large volume.

_ We do not want to enhance DSO at this point as this is only interim solution.

Do you have any suggestion?

Thank you very much,

Henry Le

[IngoH]

Hi Henry,

For 2) we need to extract such data then load to Oracle for the business to do analytic on. We know that this is not standard SAP practice, and decided that this is only an interim solution till we have all requirements and move the reports, analytic back to BW - BOBJ route.

The extract expected to be 6.5 millions rows with 70+ fields. 3.5GB to 5GB of data.

>> Data Extraction and loading is not something for Crystal Reports > That is were you have to look at Data Integrator & Data Services

Ingo