Hyperion Financial Close Management (FCM) (MOSC)

MOSC Banner

ARM Trial Balance Report with Questions

edited Jun 18, 2014 12:00PM in Hyperion Financial Close Management (FCM) (MOSC) 1 commentAnswered

We are trying to build OBIEE trial balance report from ARM table, ARM_BALANCES. Each reconciliation has questions/attributes attached to it and we want to display these questions and response in OBIEE trial balance report.

  It seems these questions are present in tables ARM_QUESTIONS and ARM_ATTRIBUTES. However, we do not see a foreign key in ARM_BALANCES that can be linked to ARM_QUESTIONS or ARM_ATTRIBUTES. How do we establish this join? Do we have to use any other fact table such as ARM_RECONCILIATIONS?


Attaching the screenshot of the report we are looking to build

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center