Columns are
ACCOUNT_CLASS,
Distribution_Account,
description,
Invoice_Number,
Distribution_Amount,
Payment_Term,
Currency,
GL_DATE,
Error_Reason,
Ship_To_customer_Name,
Bill_To_customer_Name,
Bill_To_Site_Name,
Ship_To_Site_Name,
Oracle Division Number
Hi @User_14UAH,
It is always helpful to the community, if you describe the product/version you are using.
In your case, this sounds like a question for the OTBI , or perhaps the Fusion Data Intelligence Platform community , not the Oracle BI product community .
Please clarify, so a moderator can attempt to move your post to the proper community.
I want Bi report for this,(i need data model for this(query))
Please do not (double or) triple post.
https://community.oracle.com/products/oracleanalytics/discussion/20653/i-want-query-otbi-for-below-columns-ar-invoice-integration-exception-report-using-interface-tables#latest
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
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.
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,…
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."}
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…
