Skip to Content
Former Member
Nov 24, 2009 at 05:25 PM

Limited fields being retrieved from BW



We have designed reports in Crystal 2008 using BEx queries. There is a calculation logic defined in BEx due to which we have a huge number of Key figures out of which 34 are being displayed on the report (actuals & budgets for each month; 4 quarters and Total) Also, the report consists of two groups - Cost centre's and Cost elements; cost elements nested within Cost centre's. The report appears as below

Apr May June July Aug Sept

Finance x x x x x x

Manpower Cost x x x x x x

Travel Cost x x x x x x

Operations x x x x x x

Manpower Cost x x x x x x

Travel Cost x x x x x x

The issue that we are facing is that as we increase the number of columns, some of the rows or the cost centre's being displayed on the report automatically get suppressed. For example if in the parameter 10 cost centre's are selected, the report displays only 6; if we display all 34 key figures. However If we reduce the key figures being displayed, then all 10 cost centre's get displayed. Is this due to a limitation on the data that can be fetched from BW? Is there any patch that can be applied or any registry that can be increased so that all the required details can be displayed..Also, the performance of the report is very slow, it takes about 12 mins to open. Kindly help.