Time Sheet | LongText | STRG(0) | Unable to use in Custom CDS ( Analytical Cube )

[Vivek0459]

Hi SAP Folks,

I have developed a custom analytical query to create a time sheet report using CDS 'I_TimeSheetRecord' and it has a association with 'I_TimeSheetRecordLongText" which stores long text in string data type but when i try to use same in Custom CDS ( Analytical Cube) this field is not allowed to be added.

Is there a way to display this long text in Analytical Query .

Thanks

Vivek Singh

[thomas_hechtel]

So now its already close to the 2105 release and i still cant see a way how to get the plain long text in a analytical context. I can look at it in the preview of the basic cds view but thats it.

Any changes ive overseen? or is there still no way to handle strings in the analytical engine (i would be happy if casting it to a smaller type would work)

[bschmid]

Hi folks,

Are there any news?

Thanks

Bianca

[Amith_Nair · Accepted solution]

Hi Vivek,

You have a valid point, and it is learned that I_TimeSheetRecordLongText is not yet part of the analytical Query option and this is why, you and I could not reflect the same in the analytical Query.

Product Development Team have planned to incorporate I_TimeSheetRecordLongText on our 2011 release plan. I hope this will resolve your issue with the analytical reporting.

Hope this helps!

Thank you!

Amith Nair

Reference: 31000 / 2020

[Aniketos23 · Accepted solution]

Hi Amith,

[Tayane]

Dear Vivek,

You can try the below steps:

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

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

Thanks.

[Aniketos23]

Hi Tayane,

[Aniketos23]

Hi Tayane, Thank you for your suggestion. This brings only the counter twice but unfortunately no longtext becomes visible. Any other suggestion ?

[Vivek0459]

I also tried to add calculation to cast this string to some other data type with specified length that is also not possible getting error while casting 'CAST: Source type STRING is not supported DDLS/342'.

thanks

[former_member132363]

Please see the note on [Creating Custom CDS Views for Analytical Scenarios] (https://launchpad.support.sap.com/#/notes/2657021)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.