How to create your own SAH Term Sort in Cognos

Scenario 1 - You want to see Summer terms in order.

Step 1: Create a calculated item to sort based on Term Code

For ISIS

CASE
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'FA%') THEN ('002')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'WI%') THEN ('003')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'SP%') THEN ('004')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'S1%') THEN ('005')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'S2%') THEN ('006')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Code] like 'S3%') THEN ('007')
ELSE ('009')
END

For TSS

Term Session Code

Step 2: Create a calculated item to sort Year and Term Code

CAST([Application Narrow].[Term Set - Admit Term].[Admit Term Year (YYYY)], char) || '-' || [Admit Term Qtr Num 2]

Scenario 2 - You want to see Summer terms grouped into one.

Step 1: Create a calculated item to sort based on Term Code

CASE
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Qtr] like 'Fall%') THEN ('002')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Qtr] like 'Winter%') THEN ('003')
WHEN ([Application Narrow].[Term Set - Admit Term].[Admit Term Qtr] like 'Spring%') THEN ('004')
ELSE ('005')
END

Step 2: Create a calculated item to sort Year and Term Code

CAST([Application Narrow].[Term Set - Admit Term].[Admit Term Year (YYYY)], char) || '-' || [Admit Term Qtr Num]

How to create your own SAH Term Sort in Tableau

coming soon