SQL Script

The SQL Script for the COR Cubes has been updated (Version 9.5.0.2 Blue) to include several new fields along with the Parent COR Record for each set of cube pricing breakdown records.  A new REC_TYPE field will distinguish between Parent Records and Price Breakdown Records.  This will now help to identify ALL COR Log entries regardless if they have been priced out yet or not.  

These existing COR Library Cubes were renamed as follows:

oCOR Analysis

oCOR Accounting Variance

The Cube Settings Table that is generated with each Cube Refresh now has two new fields to hold the Transaction Cutoff Dates in case these need to be accessed in the underlying Cube Script.  These 2 new fields are string fields named as follows:

oabcTransDateStart - Transaction Starting Date for Cube Data

oabcTransDateEnd - Transaction Ending Date for Cube Data

 NOTE: These fields will be blank for Job and PO Cubes which are not trans date driven.