1 Reply Latest reply: May 29, 2017 10:15 AM by Felip Drechsler RSS

    Dim data not exists in FACT

    Meitar Goldenberg

      Hi,

      1.  I have Items Dimenssion and Companies Dimensions.

      2.  My Expression is 1.

       

      I think because I have no data in the FACT table about the Item name "Ki Net Profit",

      I see the 1 amount (from the expression)  under null Company.


      Any suggestion to solve that?


      *  When I put data for this item  in the FACT I see 1 under the companies Dim, But I want another solution if exist.

      * I need a  layout solution only.


       

      ThanksCommunity.png