di97mni/pricelistexample.md

## pricelistexample.md

      
    Raw
  

              pricelistexample.md
            
          
    Example

Product A

Pricelist 1


1/1
2/1
3/1
4/1
5/1
...


$100
-
$120
$100
$90
..


Pricelist 2


1/1
2/1
3/1
4/1
5/1
...


$110
$100
$140
$110
$100
...


Product B

Pricelist 1


1/1
2/1
3/1
4/1
5/1
...


$200
$200
$220
$200
$140
...


Pricelist 2


1/1
2/1
3/1
4/1
5/1
...


$210
$200
-
-
$200
...


Example of Queries


Prices for period 2/1-4/1
Prices for Product A/Pricelist 2 for period 2/1-4/1

Output of query 1:
Product A
  Pricelist 1 - missing price
  Pricelist 2 - $350

Product b
  Pricelist 1 - $620
  Pricelist 2 - missing price

Right now the document looks like this:
Product
  Pricelists*
        Prices* {Day;Price}

Denormalized Index

ProductId
PriceListId
Day
Price