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