Popular Tags
- OTBI 1,459
- Reporting 1,399
- FDI 1,155
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 994
- BI Publisher 868
- Analysis 685
- Oracle Fusion Analytics 599
- Administration 556
- OAC 491
- OBIEE 435
- Fusion HCM Analytics 417
- Analytics 411
- Fusion ERP Analytics 393
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 230
- Oracle Analytics Cloud 221
- ERP Analytics Content 215
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Data Modelling and Datasets
Discussion List
-
Dataset having single record but when added to dataflow shows inflated dollar valueHas anyone faced this issue ? We have data sets (Mode-Live) using LSQL and that does not have any duplicates, in this example we specifically added more filters to deal …Rupak C 33 views 1 comment 1 point Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum -
15OACS: When more than one person working simultaneously on the same Data Visualization, DV changes geOrganization Name Accenture Description We've recently came across a situation, when I and my teammate was making modification to the same DV but to different Canvases, … -
5Creating Datasets - Full DISTINCT List of Values for ColumnsCurrently, when creating datasets, the dataset size limit is also limiting the list of values users can see in the column distribution and filter values available. This …
-
32Create hierarchies from DV front end, Data Set, or Data FlowOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): HID Global Description (Required): Ne…Robert Corrieri-281169 436 views 9 comments 32 points Most recent by Bhaskar Konar Oracle Analytics Idea Lab -
5Ability to Arbitrarily Order Visualization Data ColumnsCurrently, visualizations (stacked Bars for this example) have limited options for ordering- alphabetical or reverse alphabetical only. However, oftentimes neither of th…
-
4Ability to choose how the Multi-sheet excel data interpreted when importedIt is curretly possibly to import an excel file with multi-sheets however all the sheets are interpreted and model as a data mart model and the relevant joins are also s…mgoswami 72 views 5 comments 4 points Most recent by Luis E. Rivas -Oracle Oracle Analytics Idea Lab -
Data Flow Step Names & DescriptionsIt would be helpful to be able to name individual Data Flow steps and assign descriptions to each. Is this a feature we can expect in the near term and does anyone have …Matt_B 12 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum -
1When uploading an Excel file, having the ability to load all sheets instead of loading one at a timeIt will be ideal if FDI can upload all Excel sheets within the file itself instead of doing this manually one by one. It will cut time and give the user more selections …Juan Hurtado 51 views 3 comments 1 point Most recent by Benjamin Arnulf-Oracle Oracle Fusion AI Data Platform Idea Lab -
Help with Receivables transaction queryI'm creating a transaction attributes report, and I need to bring the CNPJ (Brazilian company identification number). I have two queries, which I will leave below, but I…Kauan_Bohn 75 views 8 comments 0 points Most recent by Kauan_Bohn Oracle Fusion AI Data Platform Forum -
Giving access to workbooks but not datasetsI have the following use case: -I want to share a workbook in a catalog folder with some consumers. -These consumers may have author access in other folders -Currently, …
-
Promoting Workbooks/Datasets up tiers (Dev>Test>Staging>Prod, but can't change Dataset's connection)We have an issue that seems like something others would also be encountering. Our systems generally have 4 Database tiers, with the same tables etc. in each; Dev, Test, … -
Upcoming Webinars Week of November 18Data Modeling for Business Solutions Monday, November 18 at 6 AM MT Presented by Shiva OletiAimee Williams-Oracle 31 views 0 comments 2 points Started by Aimee Williams-Oracle Oracle Analytics and AI Trainings -
Help with Transaction History Report in DMI need to find the table that have this information: Transaction Source Could someone kindly help me?
-
1OAS 6.4/2023:Needed a configuration setting to update the parallel reload of more than 2 DSET tablesWhile executing reload of a dataset in OAS 6.4 or OAS 2023, at a time only 2 DSET tables reload will trigger. As per the database capacity, we can execute multiple DSET … -
Help in Branch information SQLI’m having trouble finding fields related to "branch" (in my query, this field is represented by different paths: rcta.attribute15 AS BRANCH,inv.organization_code AS BRA…Kauan_Bohn 121 views 9 comments 0 points Most recent by Kauan_Bohn Oracle Fusion AI Data Platform Forum
-
4Union Tables within A DV DatasetWhen creating a dataset in DV mode, it would be helpful to add a Union option, in addition to Join.
-
Subject Area -- Custom Column Formula IssueWe have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time." Results return on a data tabl…JPorisVU 32 views 2 comments 0 points Most recent by JPorisVU Oracle Transactional Business Intelligence Forum
-
1Data Validation - Detailed Validation FeaturesFor subject areas 'PPM - Project Costs' it would be helpful to add in Top Task Name as a optional feature. Since business drives into the task hierarchy, it will be usef…Juan Hurtado 33 views 0 comments 1 point Started by Juan Hurtado Oracle Fusion AI Data Platform Idea Lab
-
4OAS 2023: DV Dataset should be accessible using catalog managerDV dataset is not accessible or found using catalog manager as it is not a OBI catalog object. It would be very good if the dataset XML can be accessible using catalog m…Kartik Mali-Oracle 21 views 1 comment 4 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Idea Lab
-
3OAS 2023: Dataset XML should be updatable for all underlying tables - Apply button not enabledOAS Dataset/Inspect/Developer/Metadata Developer can view the metadata XML of the dataset and all its underlying tables but can only edit the XML for each individual und…Kartik Mali-Oracle 22 views 0 comments 3 points Started by Kartik Mali-Oracle Oracle Analytics Idea Lab