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


String Measures

We can display text (string) measure values in PowerPivot and we can write these string values back to the database using XLDB

To do this you will need to do the following:

  1. In SQL Server, create your table string measure. This can be named anything that you want, but like all measure names they must be unique.
    1. Right click on your cube name and select Add Measure

    2. Enter the formula pre the format example:
      =if(HASONEVALUE(Fact_AccountPlanMapping[AcctMapType]), Values(Fact_AccountPlanMapping[AcctMapType]),Blank())
    3. Important** for XLDB to read the string values, you must name the new measure the same name as the table measure with the prefix of “s” so in the above case, the field name is AccMapType and the new PowerPivot measure is sAccMapTyp


Suggest Edit