HI All,
I have done the BI apps installations and configuration of version 10.1 i.e OBIA 11.1.1.10.1 .I would like to know thee difference between the Domain loading and Full loading how the both of the things are different from each other .
Thanks
DW fundamentals ...
Domain values are values sourced outside the warehouse so that integration can happen from various sources. Example: you might source financial transactions from both EBS and PSoft ... your warehouse domain values allow you to map the statuses from each system to a common warehouse value. a closed transaction in EBS might have a status value of 'C' and in PSoft it might be a number 10.
Domains are reloaded on a warehouse reset.
Full Load is a non-incremental load of all the dimensions and facts (after a domain only load is run) where you specify the initial extract data for your source(s).
Look on this http://apps2fusion.com/oracle-fusion-online-training/fusion-middleware-development/odi-obiee/820-functional-setup-manage…
Thanks for your replay and I am currently using OBIA 11.1.1.10.1 .If am having the only one source i.e Oracle EBS , still I need to do domain load before the full load ?.Please comment on this .Means is it mandatory to do the domain load even if I am having only one single source for my ware house.If am going for full load by skipping the domain load then what would be the results ?.Please suggest .
Yes ... there are warehouse specific values that still apply when you only have a single source. Do the mappings first, then run the domain only load plan. Take a look at the internal (_G) tables to make sure what you put in BIACM found its way to the OBAW schema - then you can run a test full run (set your initial extract date to something more recent than all of history). Now verify your dimensions and facts.
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
