xlbd-img

Online Product Manual

The Online Manual is the heart and soul of the site.

Here our aim is to make XLDB as easy to understand as possible. 

It is important to understand that  configuring XLDB requires some basic level of SQL programming; however provided that you have these skills or have access to someone who does (and we can arrange this for you too) then using the online guide, perhaps with some support from our YouTube page, Blog and Forum should be all that you need use XLDB.

Your experience is important to us. If there is anything unclear in the manual or indeed any part of the website, please let us know and we will do our best to help and in most cases will be more than happy to update our content

O

Dimension Element Aliases

One important design consideration for the ease of use of XLDB in phase one was the ability to accept aliases for writeback.

The star schema structure is based on Foreign Key / Primary Key links from Fact table (cubes) to dimension keys, and it is worth repeating that these links are integral to the way XLDB works. Only primary key elements are valid for writeback. This being said we can define Alias members from other columns as surrogates (not to be confused with surrogate keys, although they are conceptually similar). For instance, we can define the Account Name as an alias for Account Number.

Aliases, like primary keys must be unique.

Steps for setting up aliases:

  1. Set up a table called ADM.DimensionAttributes, note that for XLDB the ADM (short for “administration”) schema is important
  2. Then populate the values as follows:

You will then be able to use names as substitutes for keys in

Suggest Edit