How does Velocity manage hierarchies within data that can be considered dimensional (product, customer, time, etc)?
Velocity has inherent dimensions of time, item, store (location), and customer. For time, Velocity provides fiscal periods based on both the customer (retailer) and your fiscal year so reports can be generated for different audiences. For each item, multiple “customer item” records store retailer-specific data. Attributes can be added to items and stores. Attributes are non-hierarchical, yet can be used in reports in levels of grouping that provide hierarchy. Item and store attributes can also be “master attributes” or “customer attributes”. Customer attributes are specific to each retailer, such as a retailer’s categories of items, or a retailer’s DC alignment of stores.
