Hi All - Haven't had very much time to work on this recently, but I did come across an interesting find earlier today while strolling through the RPD file (OBIA 11.1.10.1). I can see that there are some objects named 'Dim - ETL Load Dates' and 'Fact - ETL Load Dates' ... both under an object called 'Data Load Tracking' It…

Hi Sherry, I can see that there is a dynamic repository variable named 'LAST_REFRESH_DATE'. Here are a few details: It sounds like this would contain the correct information. Thoughts? Regards, Charles

Thanks Sherry. I'll look for the product documentation on this. Regards, Charles

Thanks Martin. We are using Oracle Data Integrator (ODI) as our ETL tool. I believe we can get the date/time from one of the ODI repository or warehouse tables. I think users would like to see this information located somewhere on the home page. That way, when they log in it is displayed prominently to them. I come from…

Hi BPradhan, Take a look at this thread: ODI installation on DR(disaster recovery) . It actually links to another discussion I have opened for this. I am looking to finish the steps in the near-term. That will prove/disprove this method ... Regards, Charles

Hi - Has this worked before? Also, kindly clarify this (you have Dev twice): Dev Master and Work Repository Number:- 501Dev Master and Work Repository Number:- 551 Regards, Charles

Try reviewing this note: Is there a Dashboard/Reports Content Guide For Fusion BI Applications which list the standard dashboards & Reports (OTBI, BIP, OBIA)? (Doc ID 1499772.1) Regards, Charles

Hi. - Do you have access to MOS? You could view: Fusion OTBI : RPD Documentation - Data Lineage (Doc ID 2166125.1) Regrads, Charles

Hi - Was this helpful? Please let me know if you have any further questions about this. You can mark the above as "helpful" or "correct", so others can also use for reference. Thanks!

Hi - Which product/version are you looking for? This type of information is available. Please provide some details of what you need ... For example, this note will get you everything you need fro OBIA 11.1.1.10.1 & 11.1.1.10.2: OBIA 11g: BI Applications 11.1.1.10.x Data Lineage Guides (Doc ID 2058613.1) Regards, Charles

Hi - Here is a summary, based on Oracle materials (you'll have to dig through to get a complete understanding). Functional configuration for OBIA is done using the following tools: * Configuration Manager (BIACM) * Functional Setup Manager (FSM) - This is what you are seeing when you click on: Functional Configurations >…

Hi CRX, Keep an eye on this note, if you have the same issue again: OBIEE 12c: Enterprise Deployment Installation Method Fails With 'Error 500--Internal Server Error' (Doc ID 2188244.1) Regards, Charles

Hi - I will also be doing this in another week, or so. But, only for MDS and BIPLATFORM accounts. I am at almost the exact same version as you (all but 11.1.1.10.2). I have created a document based on these notes: OBIEE: Where can I Find Information About BIPLATFORM And MDS Schema? (Doc ID 1579577.1) How To Update OBIEE…

Here are some of the repository tables that relate to load plans (based on 11.1.1.7, but should also work for 11.1.1.9): SNP_LP_INSTLoad Plan instance. When a load plan starts, this table acts as the running instance of this load planSNP_LP_STEPLoad Plan steps hierarchySNP_LP_STEP_VARLoad plan variables defined for a…

Default duration is in seconds. You can make these modifications to convert that into minutes or hours: -- "Duration in Minutes" select I_LP_INST, NB_RUN, START_DATE, END_DATE, round((duration/60),2) as "Duration in Minutes" from {your_odi_repository}.snp_lpi_run order by start_date desc; -- "Duration in Hours" select…

Hi Raghu, Try this (use a connection to your ODI repository): alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; select * from {your_odi_repository}.snp_lpi_run order by start_date desc; Let me know if this is what you need. Regards, Charles

Hi Venkata. I'll give this a try ... perhaps by doing so, I too will also learn something Conceptually, OBIA & OBIEE are two different things. OBIEE is the "platform", or architecture. OBIA is a "packaged" application/suite. So, OBIEE is a component within OBIA (along with a few others, like ODI - Oracle Data Integrator).…

Thanks Thomas. I agree. This may be better served in the database forum for a deeper dive. I created it here in case any similar situations have occurred with other OBIA implementations. I did find some information suggesting that the above parameters for GATHER_TABLE_STATS are the "recommended" ones. I will redirect this…

There are 175,226,008 rows in this table (W_GL_OTHER_F).