The DB formula

The DB function allows you to write a rule that references values in any other cube on the same TM1® server.

TM1 supports multiple interrelated cubes of differing but overlapping dimensionality, so there are all kinds of applications that benefit from DB functions.

In the following examples, you will connect purchases in the Purchase cube (dimensioned by fish, market, and date) to exchange rates in the ExchangeRate cube (dimensioned only by market and date). In other applications, you might apply commission rates varying by employee to a sales database dimensioned by employee, product, and time. Or you could use a cube containing percentages of active ingredients in pharmaceutical products to derive production statistics in another cube, which contains shipments by product.