Need to see the filter criteria value of the filter
Data Sync Question
Where do i see date-time stamp of the criteria / filter
Oracle Analytics Cloud Data Sync (2.5)
Jobs->Runs->Tasks subtab. Choose the row you are interested. Click on details. Choose the row that reads INSERT_UPDATE_DATACOPY. Double click on Additional Info/Log. There is a log file name published like so:
\datasync\log\ReadFromOracle-Oracle12c.25944081\CR_AB_DATA_FROM_OCS-AB_OCS_TARGET.20190430.1020.log
That log file will contain the filter criteria used.
Thank You. I can see my Prune time had no effect. Do I need to select / click "Generate" after I select my Prune time?
You dont have to regenerate, this should be automatic runtime behavior. I just tried it with 2.6. It works.
Sorry, I should have mentioned this before... Go to Views->System Properties. Set the Server Log Level to FINEST. Rerun the job. This information is printed in the FINE log level. Inspect the log file. You should see the statements like below:
378 FINE 2019-05-01 10:19:56.274 PST Executing query : SELECT "SHIPTO_ADDR_KEY","OFFICE_KEY","EMPL_KEY","PROD_KEY","ORDER_KEY","UNITS","DISCNT_VALUE","BILL_MTH_KEY","BILL_QTR_KEY","BILL_DAY_DT","ORDER_DAY_DT","PAID_DAY_DT","DISCNT_RATE","ORDER_STATUS","CURRENCY" FROM "SAMP_REVENUE_F" WHERE 1=1 AND ("ORDER_DAY_DT" > ?) 379 FINE 2019-05-01 10:20:04.594 PST Bind parameters : Type: java.sql.Timestamp Value: 2019-04-30 17:15:02.0
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
