Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Budgetary Control - Transactions Real Time Subject Area to include Chart of Account Segment Values
Organization Name
NatureScot
Description
I want to use the OTBI subject areas to create analysis reports that can be used in the organisation. However, the "Budgetary Control - Transactions Real Time" subject area only includes the concatenated segments of the chart of accounts or the Department, fund or object (inour case natural account) details.
We need to be able to report on any of the segments used in budgetary control.
Also the Account Description field doesn't show the whole description. I raised an SR about this and was told "this is how Essbase cube works and you cannot obtain the entire string in a report."
Use Case and Business Need
We are trying to use OTBI analysis for the organisation however, drawbacks like this mean we have to use BI Publisher for most of the reports we use.
I can't even find a subject area that lets me create analysis of the chart of account segments at all. Only where CoA data is available as part of another process e.g. GL journals.
More details
The Chart of Accounts is the fundamental way we report our Fusion data to the organisation however, OTBI analysis is not proving to be very useful in this regard.
Original Idea Number: b226030c55