Popular Tags
- OTBI 1,417
- Reporting 1,378
- FDI 1,016
- Analysis and Data Visualization 971
- BI Publisher 834
- Analysis 669
- Oracle Fusion Analytics 566
- Administration 555
- OBIEE 427
- OAC 377
- Analytics 367
- BI Publisher Data Models 343
- Security 285
- Answers 264
- Analyses 253
- HCM 247
- Developers 241
- BIP 239
- Data Modelling and Datasets 221
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 192
- Report Output 181
- Customizing Reports 154
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Modelling and Datasets
Discussion List
-
DV dataset read flat files directly from an SFTP server?DV dataset read flat files directly from an SFTP server? Is this functionality already available ? We are not able to see the path in the upload files configuration, any…Kartik Mali-Oracle 15 views 1 comment 0 points Most recent by GayathriAnand-Oracle Oracle Analytics Cloud and Server -
NEW BLOG POST: Outlining the ability to change Db Connections for Dataset TablesHi community - Maintaining consistency across datasets while switching database connections can be a challenge—especially when downstream dependencies are involved. In m…Luis E. Rivas -Oracle 29 views 1 comment 4 points Most recent by Bhaskar Konar Oracle Analytics Lounge -
Importance of Defined IFRS Inclusions into ERP AnalyticsIn the old days, there were no global accounting standards. In jurisdictions such as India, Australia and US, we had to understand the business requirements from a compl… -
9OAS - DV Dataset scheduling and moving using FTP locationOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): ATC IP LLC Description (Required): Cu…Mallikarjuna Kuppauru-Oracle 44 views 1 comment 9 points Most recent by User_Z57T6 Oracle Analytics Cloud and Server Idea Lab -
24OAC Password Protected Export (Excel, PDF, etc)Organization Name Rogers Communications Canada Inc. Description Ability to Protect exported files with Passwords will be a great security feature to add to OAC. Currentl…AllwinJayapal 142 views 6 comments 24 points Most recent by Amanda Hope Oracle Analytics Cloud and Server Idea Lab -
34Check dependency between datasets and project/workbook in OACOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): Lets a…Deepa Mohan-Oracle 183 views 14 comments 34 points Most recent by SunilKE Oracle Analytics Cloud and Server Idea Lab
-
11OAS 2023: Connection should not get overwrite while importing the DVAWhile promoting/migrating any DVA file from one instance to another, the connection got write in the target instance. Example: I am using a Oracle Application connect wi…Kartik Mali-Oracle 64 views 9 comments 11 points Most recent by Chad Williams Oracle Analytics Cloud and Server Idea Lab
-
55Ability to Send Alerts/Notifications when Scheduled Jobs Fail in OAS DVOrganization Name Verizon Description Have the ability to send alerts/notification via email or text message when our scheduled jobs fail and why our scheduled jobs fail…Angel Shipp 252 views 3 comments 55 points Most recent by GabriellePrichard-Oracle Oracle Analytics Cloud and Server Idea Lab -
6JSON format files as dataset sourceI have seen that this 5 year old idea is marked as delivered but I don't believe that JSON files can be used as the data source for datasets (The REST API connection con…Joel 12 views 1 comment 6 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab -
11Create DATASET from JSON, XML or even a REST API (json, xml) outputOrganization Name Oracle OAC Development Description OAC support dataset creation only from tabular type data like txt, xls, csv but not from the hierarchical such as XM…Manish Krishan Agarwal-Oracle 241 views 8 comments 11 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Cloud and Server Idea Lab
-
8Enable custom calculation functions in OAC/DVDescription: Allow admins or users to create reusable functions for custom calculations inside OAC/DV. Use Case: Report developers want to run some logic against dataset…Rick195 34 views 2 comments 8 points Most recent by Rick195 Oracle Analytics Cloud and Server Idea Lab
-
Self Replacing Data in Data FlowHi , I am looking to implement a manual tracker for one of ongoing project. There is a time-series information that I would be manually upload to the system on a frequen…User_GBD0K 49 views 3 comments 1 point Most recent by GabriellePrichard-Oracle Oracle Analytics Cloud and Server
-
Payables Table for Prepayment InformationIn which Payables (A/P) table can I find information related to prepayments? I am currently developing a customized Aging report and need this information in order to mi… -
5Enable Automatic Attribute Capturing on Subject Area Date ColumnsRequest is to enable functionality in OAC to automatically derive date attributes (i.e. YEAR, MONTH, QUARTER) from DATE and TIMESTAMP type values in Subject Areas. This …Rick195 27 views 2 comments 5 points Most recent by Rajakumar Burra Oracle Analytics Cloud and Server Idea Lab
-
9Ability to create Catalog Report from OAC/OAS CatalogOrganization Name Rogers Communications Canada Inc. Description Ability to create catalog Report from OAC/OAS catalog. Currently if we have to export folder structure an…AllwinJayapal 58 views 1 comment 9 points Most recent by Andrew Desalme-Oracle Oracle Analytics Cloud and Server Idea Lab
-
FDI Dataset Editor Filter ConsiderationsReaching out to inquire re: anyone's experience running into filter limitations with FDI's dataset editor. We are trying to embed filters in the dataset editor page for … -
13Reference a dataset in another datasetUse case: I've create a dataset from a DB table and customized in data prep editor with custom column names, new columns etc. I would like to use that dataset as a table…Jim English-Oracle 55 views 1 comment 13 points Most recent by User9545855-Oracle Oracle Analytics Cloud and Server Idea Lab -
1Isolate Data Flow Records that did NOT JoinThe Join step within Data Flows should have the ability to show what records did NOT join. For example: A table that contains records from the L input that did NOT join …Matt_B 23 views 4 comments 1 point Most recent by Jamie Anderson-Oracle Oracle Fusion Data Intelligence Idea Lab
-
Suggestion required on modeling in analyticsI have a below tables Customer Product ARR (customer_id, quarter_id, product_id, arr) Dimensions: Customer Region (country, region) Product: (product_id, product_name, l…Pratap Kondamari-Oracle 22 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
Fusion Analytics Dataset Series: Dataset using queriesDatasets are self-service data models that you build specifically for your data visualization and analysis requirements. A dataset can be based on one table, spreadsheet…Abhishek Bajpai - CEAL Team-Oracle 167 views 4 comments 3 points Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Analytics Videos