Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,178
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 606
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 417
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 275
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Prepare and Model Data
Discussion List
-
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… -
Comparison of the model with the database in Oracle Developer Data ModelerIn Oracle Developer Data Modeler, I have a problem where a string of constrein is evaluated as not matching in the model and in the database based solely on the model mi… -
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…JobDeLuna 141 views 1 comment 0 points Most recent by JoseP-Oracle Oracle Fusion AI Data Platform Forum -
3Set 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 3 points Started by Will Wertz Oracle Fusion AI Data Platform 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 121 views 2 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Forum
-
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 192 views 5 comments 0 points Most recent by Dalibor Vondros-Oracle Oracle Analytics Forum
-
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 101 views 3 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Forum
-
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 231 views 3 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Forum
-
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 362 views 4 comments 0 points Most recent by Jan Zahradka-Oracle Oracle Analytics Forum
-
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 121 views 1 comment 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Forum
-
Oracle Analytics Cheat SheetsPlease find below some Oracle Analytics Cheat Sheets to help your usersBenjamin Arnulf-Oracle 282 views 2 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Forum -
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 2.6K views 2 comments 0 points Most recent by Neeti Choksi-Oracle Oracle Analytics Forum -
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 341 views 3 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Forum
-
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…
-
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 541 views 21 comments 0 points Most recent by Kanyaka Sanjana Jupudi-256359 Oracle Analytics Forum
-
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…