Hello All
Can someone provide any steps and methods to create Google Sheets as a Connection/Dataset in OAC?
Thanks for all your support.
Best
AK
Hello,
Welcome to the Oracle Analytics Community!
To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture.
Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
We have an existing Enhancement request for the same .
you may upvote and add your comment on the same thread.
https://community.oracle.com/products/oracleanalytics/discussion/19240/faw-google-sheets-for-use-in-a-dataset/p1
Thanks. This is for FAW right? I am asking about standalone OAC.
The user there asked for FAW, but all the question was about OAC itself (FAW is a package of tools: ETL, a data warehouse model and prepackaged content in OAC).
Up vote that idea, it will be doing the same you ask about.
Yes that's correct.
Initially FAW customer has raised this query and the Enhancement request has filed under OAC.
you can see the Idea lab request
OAC Documentation shows we can do this. I am looking for some configuration steps. Am I missing anything?
If you want to create a Google Drive connection, you can follow the steps documented: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-google-drive-or-google-analytics.html
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…
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…
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,…
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.
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…
