Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it possible to split a concatenated segment (accounting combination) in an OTBI report

in Reporting and Analytics for ERP 1 comment

Summary:

I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately

Content (please ensure you mask any confidential information):

Currently, only the balancing segments exist as a separate column in OTBI, the other COA segments are concatenated together. I tried playing with conditions of the concat column to split them but it doesn't seem to work. Any ideas please?

Example:


Version (include the version you are using, if applicable):

24A

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!