HI Team,
we have exist interview status report but few days onwords we getting dupliacte reocrds nearly 700plus.
how can shorted out the issue ?
Thanks,
Ajay
Hi, You have not posted the logical query. It is a zero bytes empty file. But in any case for any analysis if you need to know what is going on then look in your session log. So go to the issue sql page at /analytics/saw.dll?issuerawsql. Cut paste your logical sql from the advanced tab of your analysis with any where clauses to get an example of a duplicate. Select logging level 2 then select issue sql then select view log. From the log cut paste the physical query or queries statements starting WITH. Look closely at the joins. Research the unique identifiers of the tables from the tables and views guide at docs.oracle.com. Run it in a data model. Comment lines in and out. Debug the code to work it out.
Many subject areas contains multiple stars with multiple facts and dimensions. So this is one of the reasons for your issue perhaps. Every query must include at least on fact measure column. If you do not include one then the default fact will be chosen for you. Onle some facts and dimensions are designed to work together. So you may need to add remove some presentation columns to get a logical query to work. So start with measure presentation columns from a single fact. Now keep adding different dimension attribute presentation columns until it goes wrong with duplicates. Keep looking at the physical queries in your session log as you go along.
Cheers, Nathan
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
We would like to understand the reason for the difference in configuration options for the “Send Message to Team” action across the Redwood VBCS Recruiting pages. Currently, we observe the following behavior: On the Job Requisition and Job Requisition List pages, it is possible to hide/remove the “Send Message to Team”…
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
