You are here:
Data Lake Object Structure
When you create a data stream, Data 360 attempts to detect the data type of each field. When mapping the data lake object (DLO) to a data model object (DMO), the data type of the DLO field must match the data type of the DMO field.
The DLOs have the following structure in Data 360 after the data transfer.
Promotion Measures DLO
Object Name: promotionmeasures_<organization_id>
The object contains these fields.
- rowid: the unique row identifier, typically structured as <promotionid>/<tacticid>/<measurecode>/<productid>/<year>
- sfdcorganizationid: source Salesforce organization ID
- salesorg: sales organization name
- promotionid: promotion Salesforce ID
- categoryid: category Salesforce ID
- tacticid: tactic Salesforce ID
- measurecode: measure code
- productid: product Salesforce ID
- startdate: promotion start date
- enddate: promotion start date
- year: The year. If the business year is enabled for the sales organization, the system uses the business year. Otherwise, the system uses the calendar year.
- period1 … period70: The measure values for each period. Custom calendars support a maximum of 70 periods. The system stores each value in the corresponding period. For example, if a promotion spans periods 4 through 8, the promotion records contain measure data for those periods. Period 1 represents the first period of the business year or standard calendar.
- timestamp: Last updated timestamp for the promotion writeback
- lastmodified: The timestamp when the record was exported
- isdeleted: Indicates whether the record is deleted
Accountplan Measures DLO
Object Name: accountplanmeasures
The object contains these fields.
- rowid: the unique row identifier, typically structured as accountid>/<categoryid>/<measurecode>/<productid>/<year>
- sfdcorganizationid: source Salesforce organization ID
- salesorg: sales organization name
- accountId: account Salesforce ID
- categoryid: category Salesforce ID
- measurecode: measure code
- productid: product Salesforce ID
- year: The year. CBP is enabled only when the business year is activated.
- period1 … period70: The measure values for each period. Custom calendars support a maximum of 70 periods. The system stores each value in the corresponding period. For example, Period 1 represents the first period of the business year or standard calendar.
- timestamp: Last updated timestamp for the promotion writeback
- lastmodified: The timestamp when the record was exported
- isdeleted: Indicates whether the record is deleted
Did this article solve your issue?
Let us know so we can improve!
