Is it possible to add a calculated SQL-based column in an OTBI Analysis?
SummaryNeed to return a segment value name in a column from an OTBI analysis using a SQL Query
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?