MUX Reporting - Query is Defining String attribute as Large String

Products

• Clarity PPM SaaS

Issue/Introduction

Within the Reporting module, when a SELECT CASE query is used against a string field, the field is treated as a Large String field instead

Steps to Reproduce: 
1. Within the MUX access the Reporting module
2. Create a new Data Provider with Include Query checked
3. In the Query tab, create a new query, and define using a format like:

 SELECT CASE
    WHEN investment_type_key = 'project' THEN 'Project'
    ELSE investment_type_key
  END
FROM dwh_inv_investment

Expected Results:  
When you go to the Attributes tab, it should display the attribute as a String

Actual Results: 
The query is defined as a Large String - Plain Text

Environment

Clarity 16.4.2 SaaS environments

Resolution

This is under investigation and being tracked as DE207788.

Workaround:

The CASE expression must be explicitly cast to the original varchar length. For example:

CAST(
CASE
WHEN investment_type_key = 'project' THEN 'Project'
ELSE investment_type_key
END AS varchar(48)
) AS type_key