Current Position:Home > Financial Analytics - limiting load to specific set of books

Financial Analytics - limiting load to specific set of books

Update:10-11Source: network consolidation
Advertisement
Hi all,
we are running POC for Financial Analytics BI Apps 7.9.6 and we are limiting load into OBAW tables to specific set of books from source EBS (using SET_OF_BOOKS_ID_LIST and $$FILTER_BY_SET_OF_BOOKS_ID DAC parameters) - I was a litlle bit digging in Informatica mappings definition and suprisingly found, that those parameters are just used for load of some fact tables (e.g. W_GL_BALANCE_F etc... ), but is not used to load corresponding dimension tables - like W_LEDGER_D or W_GL_ACCOUNT_D or W_GL_GROUP_ACCOUNT_D - which I would expect to be filtered by specified set of books as well - does anybody know, what tables are filtered by those parameters and what is the reason for not restricting all corresponding tables ?
Thanks very much for your responses
Michal Zima

The Best Answer

Advertisement
Hi Michal,
I think you're saying that you noticed that the mappings/mapplets that load some of the tables (W_GL_ACCOUNT_D or W_GL_BALANCE_F, etc) are not using any logic to filter by your "set of books id list."
Have you checked the mappings that load the staging and temp tables?
For example: W_GL_BALANCE_F_TMP, W_GL_BALANCE_FS
The reason you're not seeing the "set of books id list" might be that the logic was applied to one of the staging or temp tables (a source for the _f table). Thus it would be redundant to re-apply this logic.
For example:
Notice that SIL_GLBalanceFact uses W_GL_BALANCE_FS as a source table (and loads the W_GL_BALANCE_F table).
But, SDE_ORA_GLBalanceFact is the mapping that loads the W_GL_BALANCE_FS table. The logic for "set of books id list" is included in this mapping (or actually, mapplet).
Hope this helps!
Thanks,
Austin
Edited by: Austin W on Nov 3, 2009 6:58 AM
  • Financial Analytics - limiting load to specific set of books Update:10-11

    Hi all, we are running POC for Financial Analytics BI Apps 7.9.6 and we are limiting load into OBAW tables to specific set of books from source EBS (using SET_OF_BOOKS_ID_LIST and $$FILTER_BY_SET_OF_BOOKS_ID DAC parameters) - I was a litlle bit diggi

  • Regarding Financial Analytics Full Load in DAC Update:10-11

    Hi All, Today i have started full Load for financial analytics for subject areas : "Revenue, Receivables, Paybles, General Ledger, Cost of goods Sold". The issue is "SDE_ORA_GLBlanceFact_Full", "SDE_ORA_GLJournals_Full" these

  • OBIA 7.9.5 "Financial Analytics" Full load fails Update:11-30

    Hi All , we are implementing OBIA7.9.5 for Oracle Vision instance 11.5.10 , Installation of the components were successful. We followed the respective Configuration steps for the Analytics module and configured it. when we start the Full load for Fin

  • Project/Financial Analytics- DAC - Include Project - Finance Int sub area? Update:11-30

    Hi I am running the Project and Financial Analytics DAC Load after integrating the Financials and Project Subject areas, I noticed there is an additional subject area called Project-Finance Integration(Oracle R12) Subject area in the Out of the Box D

  • DAC Execution plan for financial analytics keeps running (OBIA 7.9.4) Update:10-11

    Hi Gurus, I have problem when tried to run full load on financial analytics execution plan. I used OBIA 7.9.4, Informatica 8.6.1 and DAC 10.1.3.4.1.patch.20100901.0520. This runs on Windows Server 2008 Service Pack 2 with 6 GB of memory. I set $$INIT

  • Financial Analytics 7.9.6 - Reconciling to EBS 11.5.10 Data Source Update:10-11

    Hi all, Thank you for taking the time to review this post. Environment BI Apps: Financial Analytics 7.9.6 Source system: EBS 11.5.10 Question I have completed the BAW ETL load from my EBS 11.5.10 source system and am trying to reconcile the data in t

  • Financial Analytics: GL Balance query Update:11-30

    Hello, Does anyone if the project to date DR/CR balances as represented in the GL_BALANCES table in Oracle GL is represented in Financial Analytics 7.9.6.3. Specifically, I want to know where we have the situation where GL is enabled for basic projec

  • 7.9.6.1 Financial Analytics - JDE - Extract Dates question Update:10-11

    Hi all, Implementation of 7.9.6.1 Financial Analytics + Procurement and Spend Analytics OLTP: JDE E9 OLAP DB: Oracle 11g We were trying to adjust the # of prune days for an incremental load, when we discovered the change was having no effect. Our sit

  • Financial Analytics Reports in Local Currency Update:10-11

    Advise needed to help in configuring BI Apps such that the Financial Analytics reports (GL, Payables, Profitability & Receivables) show the transaction values in local currency i.e. INR instead of the default global currency USD. I have changed the s

  • Financial Analytics Implementation Update:11-30

    Hi guys I am looking for generic implementation plans for Financial Analytics to validate the assumption the product can be installed in around 3 months. Any assistance would be greatly appreciated.This is one of the plan (partial), but hopefully you