Multiple Dimension in report ...BPC NW 10.1

[manish_kale]

Hello,

I am trying to create report, using multiple dimension in Row and time dimension in Column e.g.

Page Axis	Company code and Profit centre
Row Axis	Planat,Material,UoM,Sales org and value type
Column Axis	TIME

Whereas system is checking all the permutation and combination for this, and unable to execute the report due to error of exceeding the no. of rows in excel. 

Can anybody suggest how will I go ahead to create the report into SAP BPC10.1

Appreciate your reply..

[manish_kale]

Thanks Got The answer ..

[manish_kale]

Thanks Vaim,

I have gone through the EPM help, It suppress empty lines once execute the report at back end and it will show output by suppressing the lines..     here issue is report not able to execute at back end due to more lines than in excel ,,once it execute at back end then it will hide or remove the empty lines.

Regards

Manish

[former_member186338]

Incorrect! Set both options and test! And please search the forum - this question was discussed many times.

Vadim

[former_member186338]

"unable to execute the report due to error of exceeding the no. of rows in excel" - number of rows is huge! And report is not working... But what do you want? Can you limit the scope?

Vadim

P.S. What type of environment you are talking about? Standard or embedded?

[manish_kale]

Thanks for your Prompt Reply...

I want to execute report... and once done asked user to do the monthly adjustment.  But due to these multiple combinations excel is unable to execute the report.. So wanted to understand can I execute the report for those combinations which has data..and system will exclude those combination where there is no data, and execute the report only for those combination, where the signdata is available.

Regards

Manish

[former_member186338]

Hi Manish,

Please read at least EPM help! There is the report option to suppress empty lines! Also >Force Symmetric Refresh for Larger Asymmetric...

Vaim