Skip to Content
0
Jun 24, 2009 at 04:10 AM

report with multiple dimensions in Row and Column with EvEXP

72 Views

Hi

We are currently running BPC 7.0 SP3 and try to create the report(or schedule) with more 2 x 2 dimensions in the row and column.

e.g.

row dimension : Outer row is Entity, Inner row is Account

column dimension : Outer column is Time, Inner row is Category

We created the report with 2 x 2 dimensions like above e.g. with EvEXP and EvNXP, NOT EvDRE

based on default dynamic template:Template13.xlt(Nested Row, 2 x 1 dimensions defined by EvEXP and EvNXP formula).

However, when expanding the dimension with double click these dimensions or change CV of the report with 2 x 2 dimensions defined by EvEXP and EvNXP formula,

error occurs on EvEXP and EvNXP formula and can't retrieve the result correctly.

[Question]

Can't we create the report with more 2 x 2 dimensions in the row and column using EvEXP and EvNXP function ?

We understand that we can make the report with more 2 x 2 dimensions in the row and column if using EvDRE.

Thank You in advance

Kenya