Which task level parameter(s) control(s) the granularity of data in Aggregate tables?
A.
TIME_GRAIN only
B.
GRAIN_LEVEL only
C.
GRAIN only
D.
TIME_GRAIN or GRAIN
Which task level parameter(s) control(s) the granularity of data in Aggregate tables?
Which task level parameter(s) control(s) the granularity of data in Aggregate tables?
A.
TIME_GRAIN only
B.
GRAIN_LEVEL only
C.
GRAIN only
D.
TIME_GRAIN or GRAIN
D
D
D
(This issue applies to Versions 7.9.6, 7.9.6.1, and 7.9.6.2) In Section 6.3.1.2 Process of Aggregating Oracle Supply Chain and Order Management Analytics Tables, Section “About Configuring the Sales Invoice Lines Aggregate Table” and “About Configuring the Sales Order Lines Aggregate Table” section , ‘Day’ should be removed from the possible values for the TIME_GRAIN parameter as below.
The TIME_GRAIN parameter has a preconfigured value of Month. The possible values for the GRAIN parameter are: ‘WEEK’, ‘MONTH’, ‘QUARTER’, and ‘YEAR’.
In “To configure the Sales Order Lines Aggregate Table” section, PLP_SalesOrderLinesAggregate_Derive_PostLoadImage and PLP_SalesOrderLinesAggregate_Load should be read as below.
For each of the following tasks, display the Parameters tab and specify an appropriate value in the Value field for the TIME_GRAIN parameter: SIL_SalesOrderLinesAggregate_Derive_PreLoadImage , SIL_SalesOrderLinesAggregate_Derive_PreSoftDeleteImage, PLP_SalesOrderLinesAggregate_Derive_PostLoadImage, PLP_SalesOrderLinesAggregate_Load