Skip to Content
0
Former Member
Jun 04, 2008 at 08:55 AM

partitioning

27 Views

Hi BW experts,

Have a nice day!

when i try to execute the query on ods(0figl_o02) the result it taking lot of time almost 15 crore records. i decided to creating infocube. is there any way to improve the performance . i heard on base cube we can create multiple infocube

when i try to do partitioning on 0FISCPER for infocube it showing this error.Can any one suggest me on this issue.

this is the error .

You want to partition an InfoCube using time characteristic 0FISCPER or use 0FISCPER in multidimensional clustering (MDC). This is only permitted if you also assign a constant to the fiscal year variants (0FISCVARNT).

Procedure

Assign a constant to the characteristc 0FISCVARNT. To do this, choose "Object-Specific Properties" from the context menu for 0FISCVARNT.

Regards

Sivaraju