Return Dimension with no data records

[#1]

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.

[johnw]

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"

[#3]

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.

[jeffmartins · Accepted solution]

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