nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OAS query filter with calculated field. Getting Bulk fetch failed.

Tony_OAS_Apex_User

have a calculated column that has bit more complex condition formula and i put filter items to use it as filter column

that caused the error --Bulk fetch failed.

So i put the calculated formula into two separated columns and put filters on them.. it's working now.

I am just curious that complicated calculated column (not that complicated, it's just concat with CASE with it)
can cause the bulk fetch error?

THanks for your help guys.!!

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet

Upcoming Event

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…

Top Leaders

Clare Murtagh 179

Michal Zima 55

Mallikarjuna Kuppauru-Oracle 51

Henrikues 35

User_IUZ26 30

Top Questions

Trying to match grain with TRENDLINE function in simple OAC analysis
I've been trying to add a trend line to my line graph in OAC, and it's driving me bonkers. The graph itself is pretty simple. The X-axis consists of days, one day at a time, that comes from a "load date" on each record. The Y-axis is a count of all the contracts in progress per a given load date. OAC easily constructs a…
Auditlog for Oracle Analytics objects in OAS
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
To Avoid the Null or "0" value columns from a Pivot Table View?
Hello Team, While building a Pivot Table view for my report, 2 out of the 4 metric columns contain completely null values. I'm looking for a way to automatically exclude or hide metric columns whenever they are entirely null or zero. Could you please advise on how to achieve this? Thanks.
How can I resolve this error when I try to index a Local Subject Area?
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
Case statements in OAC
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…