The PERIOD and P_QUARTER fields are NULL in the BIZ_COM_PERIODS table

Document ID : KB000021747
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

I queried the BIZ_COM_PERIODS table and noticed the PERIOD and P_QUARTER fields are NULL. How are these fields populated?

SELECT * FROM BIZ_COM_PERIODS

Answer:

The PERIOD and P_QUARTER fields in the BIZ_COM_PERIODS table are no longer supported as of Clarity 8.0. These fields are not visible in the Entity Fiscal Time Periods view or when you create a new fiscal time period.

Due to these fields no longer being used, the Datamart job to populate the NBI_DIM_FISCAL_TIME table also changed and the formatting of the data stored in the table is changed as well.

BIZ_COM_PERIODS
PERIOD - Deprecated ; no longer used
P_QUARTER - Deprecated ; no longer used

NBI_DIM_FISCAL_TIME
PERIOD_KEY - This column refers to the period key in format <YYYY>-<nnnnnnn> where the number refers to the BIZ_COM_PERIOD.ID value. For example: 2015-5000000
QUARTER_KEY - This column refers to the quarter key in format <YYYY>-Q<nnnnnnn> where the number refers to the BIZ_COM_PERIOD.ID value. For example: 2015-Q5000000
TIME_KEY - This is the primary time key. This column refers to the time key in format <YYYY>-<nnnnnnn> where the number refers to the BIZ_COM_PERIOD.ID value. For example: 2015-5000000

Additional Information:

Refer to the current Technical Reference guide for more details.