Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
I think you may be asking for one or the other of these:
or
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.
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