Access and Manage Data
Discussion List
-
Guest Access to BIP reports in OASSummary: Need Access to reports without login for BIP reports. Content (required): We have a requirement where we have to generate BIP reports as part of external applic…SiddharthDang-Oracle 21 views 4 comments 0 points Most recent by SiddharthDang-Oracle Oracle Analytics
-
Oracle Analytics Cloud: RPD Subject Area SecuritySummary: Subject Area Security Model in OAC Content (required): I'm looking to implement an object level security model. For example purposes, I will reference 2 users (…
-
Connection from OAC to DENODO modelSummary: Can OAC connect to a Denodo data model Content (required): Hi there a connector or a workaround to connect OAC to Denodo. The objective is to establish a connec…
-
Best practices for continuous planningSummary: As our FP&A business evolves to a continuous planning model, I am looking to hear from others as to what best practice is regarding scenarios and which scenario…
-
Unable to revive workbooks after deleting one of the accounts.Summary: Hi team, After deleting one of the two accounts of the single OAC instance, I am unable to get the data from the deleted account. Will I be able to revive the d…
-
CloudFish- cloud database direct query toolSummary: Tool for ad-hoc queries off of saas/cloud tables http://cloudfish.slpmicrosystems.net/ Content (required): I am using CloudFish tool without login into cloud PO…
-
Does anyone know when the OAC Connector OData will get upgraded from 2.0 to the latest version 4.0?Summary: OAC Connector OData for OpenAir Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support…Mark T Jackson-Oracle 41 views 1 comment 1 point Most recent by Alan Lee - Oracle-Oracle Oracle Analytics
-
How to prevent multiple logins of a single user in OACSummary: We are implementing OAC for a large bank where OAC is integrated with IDCS with SSO enabled along with ADFS for user federation. We have a situation where due t…Venkat Koduvayur-Oracle 31 views 2 comments 1 point Most recent by Venkat Koduvayur-Oracle Oracle Analytics
-
Anyone else experience extremely slow response when creating a new dataset in DV?Summary: Sometimes when creating a new dataset in DV, the system seems to just hang when trying to profile the data or save the dataset. I can query the data directly an…
-
OAC Connection with Oracle Cloud ERP General Ledger Balances CubeSummary: Has anyone tried creating a connection in OAC DV with Oracle Cloud ERP General Ledger Balances Cube? The requirement is to access a cube via OAC which currently…
-
Does anyone know when the OAC Connector OData will get upgraded from 2.0 to the latest version 4.0?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
OAC Dataset feeding back into an Oracle table (Tableau access workaround)Summary: OAC Dataset feeding back into an Oracle table (Tableau access workaround) Content (required): Much of our company is heavily vested in Tableau. We are in the pr…Robert Corrieri-281169 1 view 21 comments 0 points Most recent by Robert Corrieri-281169 Oracle Analytics
-
Transfer Excel formula and sheet to OACSummary: Hi user is share complex exel file formula and it's need see the same format and layout in OAC please advise me for best way to do this i already prpare data in…Mahgoub S.Mohamed 1 view 3 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics
-
Preflight CORS error when trying to embed DV content to another siteSummary: Getting a Preflight CORS error when trying to embed DV content to another site SR 3-28568263651 Content (required): Error message from Chrome Dev tools: Error: …
-
Set own Quarter definitionSummary: Hi, in our company we are using shifted quarters (for instance Q3 is from December to February). In case I use in report column Quarter of Year, I get standard …
-
Deleting a column permanently from OACSummary: This may be a stupid question but I cannot figure out how to delete a column completely from a dataset once the initial load is made via xlsx. or csv. Content (…
-
OAC DV Dataset not visible in BIP Data ModelI've created a data set in OAC DV which is based on Essbase cube, the data set is accessible from DV and Analytics but when I'm trying to create a Data Model using DV Da…SaurabhJaiswal-Oracle 1 view 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics
-
How to tell when Data is Refreshed in a ProjectSummary: Looking for a way to add to each project or canvas some type of code that can tell the user when the data set was last refreshed Content (required): I've seen p…
-
Can OAC Desktop Client (DV Desktop) connect to Oracle EPM CLOUD ?Summary: In OAC cloud, I can create a connection to 'Oracle EPM Cloud' and do reporting from Hyperion PBCS application. But in OAC Desktop (or DV Desktop) I am not seein…
-
How can I recover my OAC project instance after it was deleted from OCI without warning?Summary: Hi, we created multiple oracle analytics projects which we accessed using this link: https://sdav1-idmnz5eedtyk-ia.analytics.ocp.oraclecloud.com/ui/dv/?pageid=h…Safwan Sayef-Oracle 11 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics
-
Run an Union in dataflow with two datasets with different columnsSummary: I want to run an Union operation in dataflow with two datasets with different groups of columns and some columns (date and filtering dimensions) in common. Cont…Persio DeLuca-Oracle 1 view 1 comment 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics
-
Is there a way to check dependency between datasets and projects in OAC ?Summary: Content (required): Lets assume have 100+ datasets on OAC(majority of them being XLS files as source) taking good amount of the storage space. Now I have delete…
-
Oracle Analytics Server - Catalog objects Security ConcernSummary: For saved Data Connection and Data Sets There does not seem to be a way to force users to enter their own credentials when looking to refresh the data. Example …
-
Access OAC data from Rest APISummary How we can access OAC data (from classic dashboard or DV) from Rest APIContent What are the available options to access OAC data (both classic dashboard and DV p…
-
MS Power BI to connect to RPD (OAC)Summary: Ways of connecting MS Power BI to OAC RPD Content (required): How can we connect Power BI to a OAC RPDs? Would BIConnector (https://www.biconnector.com/power-bi…
-
Cannot create Essbase connectionContent Hi Folks, I'm trying to create an Essbase connection in my Analytics instance but I'm getting the following error( the error takes at least a minute to show up):…Omar Shubeilat - ACE Pro 6 views 3 comments 0 points Most recent by Omar Shubeilat - ACE Pro Oracle Analytics
-
Dataset storageContent As our understandings, with OAC on cloud infrastructure, data from csv and xls files are stored in the XSA area in disk files. It's also possible to store the da…
-
Editing the Title - Bug in Sentiment Analysis using Oracle Analytics Desktop even after latest upgraSummary Error occurred while processing the query. - It seems a bug as it got failed in two systemsContent Hi, Hope you are keeping well. I am trying to do sentiment ana…Saumyadip Sarkar 83 views 21 comments 2 points Most recent by Kanyaka Sanjana Jupudi-256359 Oracle Analytics
-
Required a new API to retrieve the whole catalog from a given rootSummary Required a new API to retrieve the whole catalog from a given rootContent As part of our portal we embed OAS objects (reports, widgets, dashboards) in customer's…
-
Can I use BVT for regression testing of dashboards/analysis in OASContent Hi, We're using Oracle Analytics Server(OAS) for PO reporting. I'm trying to validate the dashboards and analysis through regression testing in both the cases of…