Clarity: How to populate slice tables for TSV Audit data

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

Description:

We want to develop our own user-defined reporting to view the 'sliced' value in the ODF_SL_OLD_VALUE & ODF_SL_NEW_VALUE tables. Currently, those tables are not being populated with any values. How do we populate these tables?

Steps to Reproduce:

  1. Enable Audit Trail for a Time-Varying Attribute (TSV)

    1. Administration, Studio: Objects, Cost Plan Detail Object, Audit Trail

    2. In the 'Auditing on Updates' section, select some of the TSV attributes, such as planned units, planned cost

      Figure 1

  2. Create a Project detailed Cost Plan and enter in planned units, planned costs for a few periods in the TSV cells

  3. Edit the cost plan TSV values and change the original values to different values

  4. Administration, Audit Trail - see TSV data appears in the Audit Trail

    Figure 2

  5. Query the slice table for the TSV 'sliced' values

    1. SELECT * FROM ODF_SL_AUD_OLD_VALUE

    2. SELECT * FROM ODF_SL_AUD_NEW_VALUE

      Figure 3

Expected Result: We can see the data in the UI, therefore we expected to see data in the slice table

Actual Result: We do not see any sliced data in the tables

Solution:

The data for these tables are not sliced unless a new Time Slice definition has been created.

Steps to Setup TSV Audit Slice Data:

  1. Login to Clarity as an administrator user

  2. Administration, Time Slices, click 'New' button to create a definition for Old Audit Values

  3. Fill in the required fields, selecting 'Time scaled value audits::Old Value' and save the definition

    Figure 4

  4. Click 'New' button to create another definition for New Audit Values

  5. Fill in the required fields, selecting 'Time scaled value audits::Old Value' and save the definition

    Figure 5

  6. Now the data will appear in the tables:

    Figure 6

Keywords: CLARITYKB, how-to, configuration, timeslicing, nab, CLRT-73098.