BOOK_DESK_MAPPING

The BOOK_DESK_MAPPING table contains the mappings for books to desks

Column Name Type Not Null Cube Field Description
BOOK STRING Y Leaf node of the book hierarchy.
DESK STRING Y [Booking].[Desks] The desk to which the book belongs.
AS_OF_DATE DATE Y See field in joined table (SASENSITIVITIES) Timestamp (at close of business) for the data.

Unique Key

Columns
AS_OF_DATE
BOOK

Incoming Joins

Source Table Source Columns Target Columns
TRADE_MAPPING AS_OF_DATE
BOOK
AS_OF_DATE
BOOK