Prepare and Model Data
Discussion List
-
How do we export a Dataset in OAC?Summary: How do we export a Dataset in OAC? Content (required): Is there a way we can export a dataset in OAC, to migrate it from one environment to another. My scenario… -
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… -
Error in Oracle Analytics Desktop ExplainsSummary: When using the Explains feature in Oracle Analytics Desktop getting Error for Key Drivers evaluations. For same data set uploaded to Oracle Analytics Cloud the …Dalibor Vondros-Oracle 11 views 5 comments 1 point Most recent by Dalibor Vondros-Oracle Oracle Analytics -
Network Days or Business Days CalculationSummary: Looking for advice on how to calculate network/business days. In excel it's super easy to calculate business days / holidays by using the networkdays function, … -
Sharing Data Flows in OACSummary: In OAC, if we want to share Dataflow with other user then we have to export Dataflow and import back. When we do this, all the datasets are exported and importe…
-
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 2 views 3 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics -
Error by import of CSV into OACSummary: Error "File Upload Failed - Number of Columns in CSV exceeds Max supported limit:250" by import of CSV file with 4 columns. Content (required): Error "File Uplo…
-
Load CSV data into OACSummary: I have a set of CSV data files generated daily. I need to find a solution how to load (import, synchronize, etc.) data into OAC tables. Content (required): I ha…
-
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 2 views 1 comment 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics -
Oracle Analytics Cheat SheetsPlease find below some Oracle Analytics Cheat Sheets to help your usersBenjamin Arnulf-Oracle 41 views 2 comments 3 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics -
BI Publisher - Selecting 'All' in Parameter does not return any dataSummary: We have created a BIP model parameter in such a way that when all values are selected, Null will be passed. We are handling this condition in the data model que… -
Is there a way to pivot columns into rows in dataset?Summary: I want to transform a group of columns with similar parameters into multiple rows. Content (required): I want to transform a group of columns with similar param…Persio DeLuca-Oracle 11 views 3 comments 1 point Most recent by Benjamin Arnulf-Oracle Oracle Analytics
-
Counting Attributes in a Column for Yield DataSummary Need help with count functionality Oracle Analytics CloudContent I am trying to ultimately get yield percentages on a bar chart but for now i'm trying to figure …
-
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
-
Oracle discoverer 10.1.2 to OAC migrationSummary Oracle discoverer 10.1.2 to OAC migrationContent Hi All, One of our customer is looking to migrate Oracle Discoverer reports to Oracle Analytics Cloud(OAC). Coul…
-
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…
-
Cannot produce a summation of values of a particular columnContent Hi team, I have created a pivot table consisting of attributes and values as percentage, in which I want to calculate grand total of values of a particular colum…
-
OAC Workaround to bypass the data preparation limits on OCPU basisSummary data preparation LimitsContent While data preparation customers hitting the limit 125,000 with 1OCPU which is expected. Customer asking, what if when a query ret… -
Cannot map model input data to my calculations while using predictive analysis modelContent Hi Team, As we have customized some rows and used a predictive analysis algorithm on a column resulting into a machine learning model, we are trying to create a …
-
Analyze Sentiment feature not working in Oracle Analytics DV Mac OSSummary Error occurred while processing the queryContent Hi, Machine: Macbook Pro OS: 10.15.7 Catalina Oracle Analytics Desktop Version 5.9 Installed Oracle Analytics De… -
OCI – OCI Analytics: Meet the Experts - A Product Deep Dive on Oracle Analytics Cloud, 13 April 2021Content Submit your questions for the OCI – OCI Analytics: Meet the Experts - A Product Deep Dive on Oracle Analytics Cloud session to have them answered during the live… -
Different canvases for different datasets under one projectContent Hi team, Can we create different visualizations for different datasets (data diagrams) under one project? The thing we are trying to achieve is that we are makin…
-
OAC UI customizationsSummary OAC UI customizationsContent Hi Team, We have developed an OAC application where 2 filters have been provided to users.There are 2 UI changes we want to implemen… -
Data Flow to load/save to Snowflake databaseSummary Data Flow to load/save to database currently works for only few, can have load/save to snowflake database an option and already logged an SR for itContent As par…
-
OCI – Oracle Analytics : Learn how to get started with Oracle Analytics Cloud, 11 February 2021, 10Content Submit your questions for the OCI – Oracle Analytics : Learn how to get started with Oracle Analytics Cloud session to have them answered during the live event. …
-
how to summarize data group by specific date range?Summary want to summarize not in a regular calendar date rangeContent In OAC or DVD For example, I have a table with detail data from Jan. 01~ Dec. 31. I have another ta…
-
Error when deploying BI Publisher user audit reportsSummary Error is cannot find the column "REQUESTID" from the bipublisher_v view. Where can i get the column "REQUESTID" form the bi publisher audit repository?Content Er…
-
I am getting this Error - Step |j| Execution failed. Status: FAILED. Message: An HSummary I am getting an error while running my ML models in Oracle Analytics Desktop 5.7Content Hi All, Can anyone give some insight on the following error? This is happ…
-
OAS 5.5: METRIC SEARCH PANEL IS NOT FUNCTIONALSummary Datamodel crawl is not consistent across environmentsContent We have IDCS enabled in our OAS 5.5 Environments. What is the expected USER and ROLES required to su… -
The value of R_EXECUTABLE_PATH is set to C:\Program Files\R\R-3.1.1\bin\x64\R which is invalid. (HY0Summary I am using Oracle Analytics Desktop 5.6 and getting R_EXECUTABLE_PATH error while running R-ScriptContent I am using Oracle Analytics Desktop 5.6 and getting the…