Welcome to the Oracle Analytics Community
Popular Tags
- OTBI 1,000
- Reporting 858
- Analysis and Data Visualization 671
- Analysis 583
- BI Publisher 538
- Administration 487
- reports 297
- obiee 288
- Oracle Fusion Analytics 287
- FAW 271
- Analyses 240
- BI Publisher Data Models 226
- Developers 220
- Data Connectivity 185
- Data Modelling and Datasets 164
- OBI Answers 153
- security 151
- Report Output 135
- Agents 134
- Packaging and Licensing 124
- Home and Catalog 117
- HCM 115
- ERP Analytics Content 114
- Access and Manage Data 107
- OBIEE Answers 105
Prepare and Model Data
Discussion List
-
Lookup the value from another column?Hi, Is there a way through calculation that will lookup the value from another column? For example, I want to add a new column that if China Region Part is present in Ot… -
2Set a Fiscal Start Month for Date FieldsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Worthington Industries Description (R…Will Wertz 11 views 0 comments 2 points Started by Will Wertz Oracle Analytics Cloud and Server Idea Lab -
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…Geethika Nimma-Oracle 91 views 2 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server -
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…Jahnavi-Oracle 233 views 6 comments 0 points Most recent by Jahnavi-Oracle Oracle Analytics Cloud and Server -
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…Jerry Ursetti 275 views 8 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
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 101 views 5 comments 0 points Most recent by Dalibor Vondros-Oracle Oracle Analytics Cloud and Server
-
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, …
-
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 73 views 3 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Cloud and Server
-
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…Jan Zahradka-Oracle 129 views 3 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
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…Jan Zahradka-Oracle 141 views 4 comments 0 points Most recent by Jan Zahradka-Oracle Oracle Analytics Cloud and Server
-
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 90 views 1 comment 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Cloud and Server
-
Oracle Analytics Cheat SheetsPlease find below some Oracle Analytics Cheat Sheets to help your usersBenjamin Arnulf-Oracle 111 views 2 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server -
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…Neeti Choksi-Oracle 594 views 2 comments 0 points Most recent by Neeti Choksi-Oracle Oracle Analytics Cloud and Server -
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 81 views 3 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server
-
Counting Attributes in a Column for Yield DataSummary Need help with count functionality Oracle Analytics Cloud Content I am trying to ultimately get yield percentages on a bar chart but for now i'm trying to figure…DiDio 61 views 1 comment 0 points Most recent by Neeti Choksi-Oracle Oracle Analytics Cloud and Server
-
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 systems Content Hi, Hope you are keeping well. I am trying to do sentiment an…Saumyadip Sarkar 325 views 21 comments 0 points Most recent by Kanyaka Sanjana Jupudi-256359 Oracle Analytics Cloud and Server
-
Oracle discoverer 10.1.2 to OAC migrationSummary Oracle discoverer 10.1.2 to OAC migration Content Hi All, One of our customer is looking to migrate Oracle Discoverer reports to Oracle Analytics Cloud(OAC). Cou…
-
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…Ankan Chanda 53 views 2 comments 0 points Most recent by Joshua C. Stewart Oracle Analytics Cloud and Server
-
OAC Workaround to bypass the data preparation limits on OCPU basisSummary data preparation Limits Content While data preparation customers hitting the limit 125,000 with 1OCPU which is expected. Customer asking, what if when a query re…BalaGuddeti-Oracle 47 views 1 comment 0 points Most recent by AnkitR Gupta Oracle Analytics Cloud and Server
-
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…Ankan Chanda 31 views 2 comments 0 points Most recent by Ankan Chanda Oracle Analytics Cloud and Server
-
OAC UI customizationsSummary OAC UI customizations Content Hi Team, We have developed an OAC application where 2 filters have been provided to users.There are 2 UI changes we want to impleme…Kumar Saurabh Srivastava 41 views 2 comments 0 points Most recent by Kumar Saurabh Srivastava Oracle Analytics Cloud and Server
-
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 it Content As pa…Ajith Ponnamaneni 31 views 2 comments 0 points Most recent by Ajith Ponnamaneni Oracle Analytics Cloud and Server
-
how to summarize data group by specific date range?Summary want to summarize not in a regular calendar date range Content In OAC or DVD For example, I have a table with detail data from Jan. 01~ Dec. 31. I have another t…Xin Xu-147583 139 views 3 comments 0 points Most recent by Neeti Choksi-Oracle Oracle Analytics Cloud and Server
-
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 E…Romeo Ekirapa 35 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Cloud and Server
-
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.7 Content Hi All, Can anyone give some insight on the following error? This is hap…Saumyadip Sarkar 40 views 1 comment 0 points Most recent by Juan Diego Ruiz-Oracle Oracle Analytics Cloud and Server
-
Relative time search in OAC Day by Day mobile applicationSummary Relative time search in OAC Day by Day mobile application Content Hi, Im looking for a possible way to search and ask queries based on relative time search in Or…
-
Dependent DFF Value Problem in AnalyticssSummary I can not see null values for dependent dff value in report Content Hi Dear All, I use two dff value in purchase order. Those are Member Type and Member. Member …Eren Göktepe-155015 45 views 3 comments 0 points Most recent by Alexandra Andrei-73074 Oracle Analytics Cloud and Server
-
Surface EPM Cloud data in OACSummary In order to surface EPM Cloud data in OAC do I need Professional or Enterprise edition OAC Content Hi, Can anyone tell me if I need to use OAC Professional or En…Brian Somers 31 views 2 comments 0 points Most recent by Brian Somers Oracle Analytics Cloud and Server -
OAC to onprem MySQL using RDGSummary OAC to onprem MySQL using RDG Content Hi All, we are trying to establish a connection from OAC to on-prem MySQL (version 5.6) database. As per OAC documentation,…Jeffy Joseph 75 views 2 comments 0 points Most recent by Jeffy Joseph Oracle Analytics Cloud and Server
-
OAS 5.5 Data Flow ErrorSummary OAS 5.5 Running Data Flow Error Content I have performed an out of place upgrade and imported a BAR file into the new OAS instance and all looks great. I am tryi…Joel Acha11111 88 views 8 comments 0 points Most recent by Joel Acha11111 Oracle Analytics Cloud and Server