Hi, Decent snippet on this: https://stackoverflow.com/questions/10426923/whats-the-suggested-order-of-extracting-dimension-fact-data# You also may want to go to the Kimball group blogs, and look around: https://www.kimballgroup.com/2003/01/fact-tables-and-dimension-tables/ Hope it helps! Charles

Ok, thanks Christian. I think I am understanding better it now. So, to make sure I am clear ... this has nothing to do with a slowly changing dimension (e.g. type 2), right? Like, these are not saying that this was the "time period" during which that attribute was the 'active' attribute? Charles

Good spot. I didn't even put that together . My favorite is if it is an actual command. I've done a few copy & pastes right from some product documentation pages, only to realize (eventually) that there was a typo.

You able to share some more details on this? Maybe some screenshots of the object's ownership/permissions (maybe even the folders it's path too ...). Do you have the underlying analyses in a separate folder? The more you can provide, the quicker we can determine where the issue is. Regards, Chalres

Ok, thanks for the version info. Any thoughts on the article? Do you think it could be a possibility?

Hi - What version is this? Is this something that can be done "behind the scenes" ... at the data row/column level? https://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-row-level-security/ Regards, Charles

Hi, There is another forum for OBIA. If you have access to My Oracle Support, you can access it too. So, I meant that you can also post this question there. There are other people, including Oracle folks, who frequent those boards. Charles

Hi - Seems like it may be referencing this note: Alert: OBIA 11g: Support of BI Applications 11g[11.1.1.9.2, 11.1.1.10.1 & 11.1.1.10.2] with OBIEE 12.2.1.x(12C) (Doc ID 2084688.1) Regards, Charles

Hi - Did you run the 'Domain-Only Extract (SDE and SIL)', before trying to generate this load plan? Also, maybe try putting this out on OBIA (MOSC). Perhaps, you'll get something over there ... Regards, Charles

Hi, Its hard to say how long your incremental could/should be taking. Maybe it would be useful to compare the loads in ODI (full vs. inc.). Go to the Operator tab and bring up the Load Plan Executions. Then, drill-down into the different phases/steps.You should be able to see where the time is being spent. Certain tasks…

Hi - Based on your versions, there is no need to "force" an incremental load after running the initial full load. The ETL logic will handle this. Why do you think it is doing another full load? Regards, Charles

According to MOS, DAC 11 is certified for Java 1.6.x. It (e.g. DAC 11) is not supported with Java 1.7 or 1.8 - Doc ID 2060109.1. Maybe this will be helpful for you. I did not see anyting on DAC 10. Also, that version of DAC went out of support in 2014. Oracle urges customers to upgrade/migrate to a newer version - Doc ID…

Ok, no worries. Thanks for the update! Charles

Hi - How'd everything work out with this? You get it resolved? You can share some of the outcomes, if you think they will be useful for others. Also, mark helpful to anything here if it made a difference ... and close it out, if you've been able to fix it. Regards, Charles

Certainly possible. We did quite a few customizations during our implementation, mostly Category 1, including many attribute columns. I was a technical-hand for those tasks (we had some functional folks who helped with the analysis part), so I cannot say which columns you may need. Maybe others here can speak more towards…

Hi, Which version of OBIA are you using? You could take a look at OBIA 11g: BI Applications 11.1.1.10.x Data Lineage Guides (Doc ID 2058613.1), specifically: Financial Analytics EBS2.xlsx (contains 12.2.x tables). I can see that ra_customer_trx_all is in there, but I didn't see ra_customer_trx_lines_all. Regards, Charles

Hi - How are you doing with this? Any questions/updates? Charles

Ok, thanks for the additional information. You'll probably need to go at this from the database tier to start with - do you have access to the database to look at parameters? (you may want to review all the parallel settings -> SQL> show parameter parallel); and, are you able to look at the alert log from the file system?…

I found this note on MOS: Alert: OBIA 11g: Support of BI Applications 11g[11.1.1.9.2, 11.1.1.10.1 & 11.1.1.10.2] with OBIEE 12.2.1.x(12C) (Doc ID 2084688.1) It was last updated in March of this year, and January 2018 before that. By no means a road map, but has some current information on options. Charles

... also, look in that W_ETL_EVENT_LOG table. That will give you some details on the error. Maybe try soemthing like this: select * from w_etl_event_logwhere event_result like '%ORA%'--where event_result like '%eadlock%'order by event_timestamp desc; You may also need to take a look at the database alert log, if you have…