本文详细解释了在CUBE中分区（使用0CALMONTH和0FISCPER）如何影响性能，特别是在数据加载前进行分区时的注意事项。包括分区数量的确定、日期范围的划分（例如，1998年1月到2003年12月）、以及如何使用特定特性（如0FISCVARNT）进行有效分区。
2.0 CUBE-Partition (before data loaded into the CUBE)
Performance gain is only achieved for the partitioned InfoProvider if the time characteristics of the InfoProvider are consistent. This means that with a partition using 0CALMONTH, all values of the 0CAL x characteristics of a data record have to match.
you can only change the value range when the InfoProvider does not contain data. If data has already been loaded to the InfoProvider, you have to perform repartitioning.
You can partition InfoCubes using two characteristics – calendar month (0CALMONTH) and fiscal year/period (0FISCPER). The special feature of the fiscal year/period characteristic (0FISCPER) being compounded with the fiscal year variant (0FISCVARNT) means that you have to use a special procedure when you partition an InfoCube using 0FISCPER.
When partitioning using 0FISCPER values, values are calculated within the partitioning interval that you specified in the InfoCube maintenance. To do this, the value for 0FISCVARNT must be
InfoCube maintenance is displayed. Set the value for the 0FISCVARNT characteristic to constant. Carry out the following steps:
a. Choose the Time Characteristics tab page.
b. In the context menu of the dimension folder, choose Object specific InfoObject properties.
c. Specify a constant for the characteristic 0FISCVARNT. Choose Continue.
Choose Extras ® DB Performance ® Partitioning. The Determine Partitioning Conditions dialog box appears. You can now select the 0FISCPER characteristic under Slctn. Choose Continue.
分区的数量是根据CUBE的数据量决定的，一般单个分区的记录数在50M到80M之间性能比较好。可以根据具体机器性能做调整。
每个分区是包含3个月或者6个月，是由系统根据原有的期间数（如，74）和用户指定的最大分区数（如30或者16）计算出来的。
你的理解是对的。
日期： 01.1998--12.2003 ，最大区间数填写16，那就是按6个月为一个区间来算，实际分区数是14个。
日期： 01.1998--12.2003 ，最大区间数填写30，实际分区数是26个，3个月为一个分区。
一般分区数量就填写 50-80 之间
Performance gain is only achieved for the partitioned InfoProvider if the time characteristics of the InfoProvider are consistent. This means that with a partition using 0CALMONTH, all values of the 0CAL x characteristics of a data record have to match.
you can only change the value range when the InfoProvider does not contain data. If data has already been loaded to the InfoProvider, you have to perform repartitioning.
You can partition InfoCubes using two characteristics – calendar month (0CALMONTH) and fiscal year/period (0FISCPER). The special feature of the fiscal year/period characteristic (0FISCPER) being compounded with the fiscal year variant (0FISCVARNT) means that you have to use a special procedure when you partition an InfoCube using 0FISCPER.
When partitioning using 0FISCPER values, values are calculated within the partitioning interval that you specified in the InfoCube maintenance. To do this, the value for 0FISCVARNT must be
InfoCube maintenance is displayed. Set the value for the 0FISCVARNT characteristic to constant. Carry out the following steps:
a. Choose the Time Characteristics tab page.
b. In the context menu of the dimension folder, choose Object specific InfoObject properties.
c. Specify a constant for the characteristic 0FISCVARNT. Choose Continue.
Choose Extras ® DB Performance ® Partitioning. The Determine Partitioning Conditions dialog box appears. You can now select the 0FISCPER characteristic under Slctn. Choose Continue.
分区的数量是根据CUBE的数据量决定的，一般单个分区的记录数在50M到80M之间性能比较好。可以根据具体机器性能做调整。
每个分区是包含3个月或者6个月，是由系统根据原有的期间数（如，74）和用户指定的最大分区数（如30或者16）计算出来的。
你的理解是对的。
日期： 01.1998--12.2003 ，最大区间数填写16，那就是按6个月为一个区间来算，实际分区数是14个。
日期： 01.1998--12.2003 ，最大区间数填写30，实际分区数是26个，3个月为一个分区。
一般分区数量就填写 50-80 之间
扫一扫
2489
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
