2 Replies Latest reply: Dec 13, 2013 7:08 AM by Vishnuram Jayaraman RSS

    In report display NULL in dimension against some specific condition

    Nidhi Gupta

      Hi,
      I have a scenario where I need to display Person,City,State, Sales1, Sales2 in a report in QV.

       

      At the Data Model Level, have 3 tables :

      1. Person

      2. Fact

      3. Address

       

      where Address and Person are joined to Fact Table based on AddressKey and PersonKey respectively.

       

      There is a Flag field in the Fact table with Y and N value.

       

      The report should be displayed such that, for all records with Flag=Y in Fact table,

      the identity (i.e. Person,City,State) should not be visible(NULL should be displayed) in report while Sales1, Sales2 should be displayed in report.

       

      NOTE : Blank or some other text can also be placed in place of NULL.

       

      e.g

       

      PersonStateFlagSales1Sales2
      AabcN100000565222
      NULLNULLY200000233556
      CxyzN300000225655
      NULLNULLY100000122555
      NULLNULLY500000122445

       

      Kindly suggest how to implement this.

      Thanks in advance !!