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


The Dim_Version dimension

In future phases, we hope to accommodate more sophisticated security, leveraging row level security. However for phase one of XLDB, the only security / writeback control available is via the version dimension.

All cubes (fact tables) that you intend to write back to MUST contain the Dim_Version dimension

The version dimension needs to contain a field called “IsStatic” and this is a bit field and is binary in nature; with versions set to 1 being static (read only) and those set to 0 available for writeback. In the below example, you cannot write back to the “Actual” version

Suggest Edit