Partitioning Guidelines For Large Fact Tables
Preinstallation and Deployment Requirements for Oracle BI Applications
3-21
2.
Go to the Design view, and select the appropriate custom container from the
drop-down list.
3.
Click the Source System Parameters tab.
4.
In the toolbar, click New to open a new record.
5.
For yearly partitions:
a.
Create a parameter with the following values:
-Name: $$CURRENT_YEAR_WID
-Data Type: SQL
-Value: SELECT TO_CHAR(ROW_WID) FROM W_YEAR_D WHERE W_
CURRENT_CAL_YEAR_CODE = 'Current'
-Logical Data Source: DBConnection_OLAP
b.
Create a second parameter with the following values:
-Name: $$PREVIOUS_YEAR_WID
-Data Type: SQL
-Value: SELECT TO_CHAR(ROW_WID) FROM W_YEAR_D WHERE W_
CURRENT_CAL_YEAR_CODE = 'Previous'
-Logical Data Source: DBConnection_OLAP
6.
For monthly partitions:
a.
Create a parameter with the following values:
-Name: $$CURRENT_MONTH_WID
-Data Type: SQL
-Value: SELECT TO_CHAR(ROW_WID) FROM W_MONTH_D WHERE W_
CURRENT_CAL_MONTH_CODE = 'Current'
-Logical Data Source: DBConnection_OLAP
b.
Create a second parameter with the following values:
-Name: $$PREVIOUS_MONTH_WID
-Data Type: SQL
-Value: SELECT TO_CHAR(ROW_WID) FROM W_MONTH_D WHERE W_
CURRENT_CAL_MONTH_CODE = 'Previous'
-Logical Data Source: DBConnection_OLAP
7.
For quarterly partitions:
a.
Create a parameter with the following values:
-Name: $$CURRENT_QTR_WID
-Data Type: SQL
-Value: SELECT TO_CHAR(ROW_WID) FROM W_QTR_D WHERE W_
CURRENT_CAL_QTR_CODE = 'Current'
-Logical Data Source: DBConnection_OLAP
b.
Create a second parameter with the following values:
-Name: $$PREVIOUS_QTR_WID