5 Replies Latest reply: Oct 13, 2016 5:58 AM by Ajay Sarma RSS

    How to add a 'Unknown' value/record in dimension table?

    Koos Snoeks

      Dear Qlikviewers,

       

      I am designing and implementing a dimensional model in Qlikview. But I'm having some issues with empty fields in my fact table.

       

      The situation:

      I load a fact table with multiple sorts of costs, both actuals and budgets. This 'cost fact table' is a concatenation of the actuals and the budgets.

      However, all the budget records have a cost center, and the actuals don't.

      In my fact table I am perfectly able to populate these empty cost center fields with 'Unknown'. With something like => (if(isnull(costcenterKEY), 'Unknown', costcenterKEY))

      My dimension table 'cost center' does not have a record/value 'Unknown'.

       

      Question:

      How do I get this 'Unknown' record/value in my cost center dimension table? (which comes straight from a SAP DB)