Hello Anaplan community, I'd like to create a model that stores prices for my items, and the evolution of these prices. A few constraints though: Prices can evolve with time, and the applicable price at one date can be different from the applicable price at another date. Products don't change prices at the same time, and changes in prices don't happen so often (perhaps once a year or once every two years). The active price is the latest price input. I'd like to be able to easily gather the current price for one or more products, or their prices at a specific date. I'd also like to keep track of the history of price changes to have a neat view of the price evolution of a product. It must be quite simple to input the prices for many products in bulk. I thought about a few solutions: Create a module where time is a dimension, and products also, with a line item with the product price, but: I find it really heavy to maintain the price for each day/week/month/year (depending on the time granularity) for each product The price may change at a specific date/time, in the middle of the week/month/year Create a numbered list where each item would be the n-th price of the product, and create a module with that list and the list of products and two line items (one with the product price, one with the effective date), but: Getting the current active price, or the price at a specific date seems complicated, as it may be on a different item of the n-th change list. Changing latest prices in bulk seems complicated too. What would be your recommendation on how to handle this? Thanks a lot, FX
... View more
