Thanks for the quick answers, you two. I also checked and it looks like Flash is still around for another year, so we're good. Your info will help us decide what to do in the short term..

FYI, we have this problem with OBIEe 11.1.1.7: Exporting reports and dashboards  Exporting to Microsoft PowerPoint 2003 does not work correctly. Export only to Microsoft PowerPoint 2007 or later.  Exporting to Microsoft Excel 2003 does not format correctly for all reports. Microsoft Excel 2007 and later are recommended.…

Could you please say a bit more about this comment you made? I'm guessing we might need this advice. 'And #2: You'd safe yourself a lot of pain by decouplign OBIEE from the rest of the *cough cough* "product"."'

We are awaiting news as to whether Oracle will even keep the product. The extreme silence does not bode well for us existing customers.

We have the situation for certain source tables where the table does not have a datetime stamp. Therefore, the ETL treats any load as a full load, as it cannot tell if a record was updated or not. So one very simple check would be to see if your source does have a datetime stamp that the ETL can use.

There is another option, which is to stop anyone getting the tables directly, and only allow access via ODI. You can have one person, or a set of people, who enter the passwords for the appropriate connections and grant access to the developers to use those models, without having access to the password. I believe you can…

The point is that the poster wanted to know if it was possible, and I answered the question. Normally when someone asks a question like that, they want to know if there is enough possibility of making it work to pursue it. If we had all answered, for example, that you can only do this with a high-end system with very few…

I displayed 140,000 rows in our OBIA 11.1.1.8, OBIEE 11.1.1.7 with no problem - it took seconds on a test environment. We do this often when testing. This test used the Scholar dimension and I only placed the Scholar Number on the report. Then I placed a couple of fact columns, in addition, and got back 79,477 records in…

So it sounds like your experience is that you had no trouble with the source tables being split into two databases and with shared dimensions, such as biographical info being correctly put together. Can you tell me what scenarios you are basing your estimate on? Have you done a similar upgrade?

Here is a link for PeopleSoft: Implementing Human Resources Analytics using PeopleSoft Adaptors: https://www.scribd.com/document/281175540/Implementing-HR-Analytics-PeopleSoft-Adaptors

I believe I've found this in ODI. Still, it shows that studying the code, rather than having information presented in a manual, is the only way to find out how the system is supposed to work.

I am paying a lot of attention to what you said about "AS IS" and "AS WAS". However, I do not see that in the RPD. I see the WID of the dimension table linked to the WID of the fact table. So wouldn't the definitive join be in the ETLs that create the WIDs, rather than in the RPD?

We have all of that, and more. It seems that we have a difference of opinion on what knowledge we should need to implement. As I've said, we've had a tremendous number of bugs. But to me the most telling example remains Headcount in HR Analytics. When we run the ETLs and we bring up the dashboards and we see Headcount, we…

That is very well for implementation partners, but Oracle sold us the system as working OOTB. Even if that's false (and some of us knew it was) we do not have the option to get a such a partner. In any case, the system should still have some basic documentation. To deliver, for example, Headcount, with only reverse…

If you do that, won't it overwrite your custom mappings? I thought a domain load went to the source system to get the initial mappings, which you then customize.

You definitely do not need to do a domain load first. We do full loads all the time while we work out our ETLs.

I highly recommend you install and run the Data Lineage Subject Area. You will be able to generate any report like this that you want.