Skip to Content
0
Former Member
Mar 13, 2010 at 11:37 PM

Crystal Report on a big cube

11 Views

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