3 Replies Latest reply: Dec 10, 2012 2:53 PM by Jefferson Martins RSS

    Return Dimension with no data records

      Hi,

       

      I have had a look around and can't really find what I am looking for, I think it is a case of not knowing the exact question to ask.

       

      I have a Dimension where i want to display those that have no associated data rows.

        • Re: Return Dimension with no data records
          John Witherspoon

          I think you may be asking for one or the other of these:

           

          • On the Dimensions tab, checkmark "Show All Values"

           

          or

           

          • On the Presentation tab, uncheck "Suppress Zero-Values"
            • Re: Return Dimension with no data records

              Hi John,

               

              thanks for the reply.

               

              More specifically i have a dimension called Tool. Each tool can be mapped to 0 or many capabilities. Essentially what the tool can do. I have a Table Box which lists the following columns

               

              Tool Name | Capability

               

              If the Capbility is not mapped then a 'dash' is shown to represent a NULL value. A sample of the data is:

               

              Tool Name | Capability

              7Zip               -

              ACDC          Inbound

              Agility          Technical

               

              As the 'Dash' is a null value i can't select it to show all tools with no capability.

               

              Any help would be apprecaited.

                • Re: Return Dimension with no data records
                  Jefferson Martins

                  Hi Damian Waldron,

                   

                  To select the tools with no capability you have to follow the following steps:

                   

                  1) right click on capability list and choose "select possible" option.

                  2) right click on tool name list and choose "select excluded" option.

                   

                   

                  A different way to select the tools with no capability is changing the representation of the null value to a string 'NULL' using the following variables in the script:

                   

                  NULLASVALUE *;

                  Set NULLVALUE = 'NULL';

                   

                  Regards