Skip to main content
Question

Slowly Changing Dimensions

  • September 12, 2022
  • 0 replies
  • 119 views
Hello Community,

I need to be able to have different versions of parameters in a dimension table, depending on a given time period. I wonder how to solve this in Quickbase.

Simplified example:

T_PRODUCT_PRICES
ID, NAME, PRICE, VALID_FROM, VALID_TO
1, Milk, 2.00$, 2022-01-01, 2022-03-31
1, Milk, 2.50$, 2022-04-01, 2022-09-30
1, Milk, 3.00$, 2022-10-01, <<null>>

T_ORDER
PRODUCT_ID, PRICE
1, 2.50$

=> How can I get the currently valid price and use it in a relationship with a facts table?

Are there any best practices in Quickbase?

Kind regards,
Martin


------------------------------
Martin Suske
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • September 12, 2022
Martin -

You'll probably want to have a Products table as a parent to the Product Prices table. Your "Current Price" would be a summary field from the Product Prices to Products. Most likely, you'd also want a Line Items table as a child to an Order table. Then, you would have Line Items as a child of the Products table and bring over that "Current Price" as a lookup.

------------------------------
Blake Harrison
bharrison@datablender.io
/
------------------------------
Terms & ConditionsAccessibility statement