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