Outer Join Error

[Cognos_Jan2017]

We have made a Table/ Query, for an Outer Join, to ensure all Conditions
and all Groups are displayed even where there would be no data for a
particular Condition / Group combination.  The Table/ Query is ...

Condition    Group
Severe         AAA
Severe         BBB
Severe         CCC
Moderate      AAA
Moderate      BBB
Moderate      CCC
Minor           AAA
Minor           BBB
Minor           CCC
Minimal        AAA
Minimal        BBB
Minimal        CCC

I am a Cognos novice.

I set New Links for both joining Condition and Group.

I tried these cardinality options ...
For left outer join (A-B)1:1-0:n A left outer join on B

For right Outer (A-B) 0:n-1:1 A right outer join on B

For full outer Join 0:n-0:n

All attempts error as ...
GEN-ERR-0016

The 'ces_currentmeasure' function is not supported in the context in which it is used.

What am I doing wrong?

TIA, Bob

[MFGF]

We have made a Table/ Query, for an Outer Join, to ensure all Conditions
and all Groups are displayed even where there would be no data for a
particular Condition / Group combination.  The Table/ Query is ...

Condition    Group
Severe         AAA
Severe         BBB
Severe         CCC
Moderate      AAA
Moderate      BBB
Moderate      CCC
Minor           AAA
Minor           BBB
Minor           CCC
Minimal        AAA
Minimal        BBB
Minimal        CCC

I am a Cognos novice.

I set New Links for both joining Condition and Group.

I tried these cardinality options ...
For left outer join (A-B)1:1-0:n A left outer join on B

For right Outer (A-B) 0:n-1:1 A right outer join on B

For full outer Join 0:n-0:n

All attempts error as ...
GEN-ERR-0016

The 'ces_currentmeasure' function is not supported in the context in which it is used.

What am I doing wrong?

TIA, Bob

Hi,

Rather than me explain, I'll point you to Craig's blog, which does so far more eloquently :)

http://craigrowland.co.uk/category/bi/cognos/

MF.

[Cognos_Jan2017]

MFGF - Beautiful.  Great to begin a Monday this way.

THANK you, Bob