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 add a calculated SQL-based column in an OTBI Analysis?

Received Response
64
Views
8
Comments
edited Jan 23, 2020 12:20AM in Reporting and Analytics for ERP 8 comments

Summary

Need to return a segment value name in a column from an OTBI analysis using a SQL Query

Content

Hello, 

Our Financial users have created several OTBI reports based on standard Subject Areas. For many of those reports, they want to retrieve a column with the name of one of our Chart Of Account Segments (eg: DEPT). We can get the segment VALUE from one of the fields (eg: CONCATENATED_SEGMENT), but the Subject Area doesn't have any field showing the NAME for that value. 

Is there a way in OTBI where I could create a calculated field using SQL so I can retrieve the segment NAME from the database table passing as a parameter the segment VALUE?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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