3286728 - Enable longtext of timesheet records in Custom Analytical Query

As we described in KBA: 3138813 - TimesheetNote field only displays 40 characters of the Note in CDS view I_TIMESHEETRECORD,
"Long Text is currently not supported in Custom Analytical Queries".

With discussion between developments of Timesheet and Framework,
There are detail workaround steps to enable longtext in Custom Analytical Query.
Note: There is one limitation which is that the longtext visible will be available in logon language. 
          Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP S/4HANA Cloud Public Edition

1. Create an Analytical Cube with an association to I_TimeSheetRecordLongText using Custom CDS View application as follows:

2. Add the entire association under Elements:

3. Finally add the association as the associated text view for the counter:

4. A custom analytical query can be created on top of an analytical cube using the app Custom Analytical Query. Add counter to the row of the query and select Dimension Format as ‘Key and Text’ to enable the text association that was added in Custom CDS View.

5. On click of preview should display the counter and the respective longtext that was created in the same ‘LOGON LANGUAGE’.
Longtext created in other languages will not be visible:

3138813 - TimesheetNote field only displays 40 characters of the Note in CDS view I_TIMESHEETRECORD

I_TimeSheetRecordLongText, longtext, I_TimesheetRecord, 40, timesheet , KBA , CA-TS-S4 , Cross Application Timesheet in S/4HANA , How To