/
Input validation: Revenue contribution Override

Input validation: Revenue contribution Override

Columns

Validations

Columns

Validations

channel

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • channel must be present in the set of channel that are given in store master

store_code

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • store_code must be present in the store master

store

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

brand

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • brand should be present in the set of brands provided in style master.

  • It is a mandatory input

category

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • category must be present as the key in the style master.

sub_category

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • sub_category should be present in the style master

  • Cat subcat combination should be present in style master

brand_segment

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

price_bucket

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • price_bucket must be present in the Price bucket input mapped to given category

gender

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • gender must be present in the set of genders that are given in the style master.

attribute1

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute2

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute3

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute4

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute5

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute6

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute7

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute8

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

attribute9

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

forecast_period

  • channel, store_code, store, brand, category, sub_category, brand_segment, price_bucket, gender, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, forecast_period combination must be unique.

  • it should be an integer.

  • it should be present in the od input periods

revenue_contribution

  • it must be number.

Related content

MS Ent Input File Validations
MS Ent Input File Validations
Read with this
Runtime Validations- Optimum Width
Runtime Validations- Optimum Width
Read with this
Input Validations: Allocation & IST
Input Validations: Allocation & IST
Read with this
Input validations: Optimum Depth
Input validations: Optimum Depth
Read with this
Validations
Read with this