Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

gl_balance_F and Gl_other_F are not joined together for drill down????

DannyNov 16 2011 — edited Oct 23 2012
Hi ,

Isnt it a standard practice in organizations to see the summary/ balance sheet and wanting to drill down to the next level as to see the journal lines? I am not interested in knwing how to drill through/down from Journal lines till subledgers as we dont hv them here. Trying to find the source for the details though.

So my main requirement is when the client checks the balance sheet, he sees the summary dollar amounts in the report. If he clicks on any one amount, he should be able to see how that amount was arrived to i.e. the details/journal line entries. IS that not delivered by default in OOTB Financial Analytics or am I missing something here? Are GL_BALANCE_F and GL_OTHER_F not joined internally?

IF the above is the case, how do I achieve what the client requires? Just a valid real time idea required. I dont need step by step instructions.

Just in case its not clear, an ATM transaction is the best example I can think of. If I see my balance increase/reduce from prev month, I take a mini transaction which shows where all I spent my money.

Ahsan, any feedback on this?

Thanks,
Dan
This post has been answered by Ahsan Shah on Nov 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2012
Added on Nov 16 2011
8 comments
500 views