Popular Tags
- OTBI 1,366
- Reporting 1,352
- Analysis and Data Visualization 899
- FDI 890
- BI Publisher 791
- Analysis 654
- Administration 542
- Oracle Fusion Analytics 536
- OBIEE 415
- BI Publisher Data Models 324
- Analytics 309
- OAC 271
- Answers 259
- Security 253
- Analyses 251
- Developers 235
- HCM 221
- BIP 214
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 179
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Calculation
Discussion List
-
April Virtual Webinars - Let's Go!April 1, 2025 at 9 AM MT - Calculations in Fusion Data Intelligence (FDI) - Intermediate April 14, 2025 at 10 AM MT - Create Your First Workbook in Fusion Data Intellige…Aimee Williams-Oracle 33 views 0 comments 0 points Started by Aimee Williams-Oracle Oracle Analytics Trainings -
Multi-Select Values in Parameter to show in tableHi, Is it possible to show multiple rows in the table based on selected values from the Row Selector? Currently though I selected 2 rows, only the first value appears on… -
Create a column that show/filter only the MAX Date of Date field on each monthHi, I just want to request your help on how can I create a column that show/filter only the MAX Date of Date field on each month "SCV - Material Sourcing Impact - Curren…
-
This Calculation is brokenI imported this Excel with 2 checks names: It gives me 2 lines: For line 1 (i.e. check 1) I want to check how many persons have birth date less than 1940. For line 2 (i.…Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Fusion Data Intelligence -
Upcoming Webinars Week of January 20Tuesday, January 21 at 7 AM MT Custom Calculations using Oracle Analytics Presented by: Lucian Dinescu Tuesday, January 21 at 9 AM MT Data Flows in Fusion Data Intellige…Aimee Williams-Oracle 33 views 0 comments 7 points Started by Aimee Williams-Oracle Oracle Analytics Trainings
-
Broken Key MetricHello, I'm trying to count all User Person Type set as "Somministrato" and I made de below Key Metric. As you can see I'm filtering by month 2024/06 and the assignment s…Stefano_Mazzocca 32 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion Data Intelligence
-
Logical SQL in calculation validated ok but Query Error in Visualization.Hi Group, I've tried a Logical Sql in calculation in OAC, it showed validate OK,like below part1, but have Query Error in visualization like below part2. And if we use V… -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each employee (C… -
Upcoming Webinars Week of December 9Calculations in FDI Tuesday, December 10 at 7:00 AM MT Presented by Miles Novotny and Lucian Dinescu Semantic Model Extensions – Part 1 Tuesday, December 10 at 9:00 AM M…Aimee Williams-Oracle 32 views 0 comments 4 points Started by Aimee Williams-Oracle Oracle Analytics Trainings
-
2Need Global variable/Calculation that can be used in all canvasesWe have a header and footer with our confluence page link. Currently when ever a new page/canvas is created , we have to manually add the hyperlink. But suppose if the c…Ancy Paul-Oracle 11 views 0 comments 2 points Started by Ancy Paul-Oracle Oracle Analytics Cloud and Server Idea Lab -
Count the number of HIRES in a specific wayHi, I need to create a line chart showing the number of hires for each company year by year. One of these companies, let's say company "A", should also add the hires of …Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence
-
How to create a % columnHello, I have a custom field which can assume 4 values, one for each of these columns: I need to add a column where I show the percent of RETE column compared to the sum…Stefano_Mazzocca 21 views 1 comment 1 point Most recent by Stefano_Mazzocca Oracle Fusion Data Intelligence
-
Why this division doesn't work?I have these yellow key metrics: Why the green calculation, which is simply a division between the 2, always returns 0?Stefano_Mazzocca 12 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence
-
December Webinars - Registrations Open!December 3 at 9 AM MT - Parameters in Fusion Data Intelligence (FDI) December 10 at 7 AM MT - Calculations in Fusion Data Intelligence (FDI) December 10 at 7 AM MT - Sem…Aimee Williams-Oracle 121 views 0 comments 5 points Started by Aimee Williams-Oracle Oracle Analytics Trainings
-
Filter function for date condition error in OAC calculationHello Group! I use the Filter function in OAC calculation,and use Date Related fields as the filter expression, but it shows the below error message,please help! Or any …
-
Can FMT be included in the CAST function? or set the internal date format in a data set?Hello everyone! A few days ago there was apparently a change in Analytics and since then, the data sets (based on excel or csv), now internally store the date format dif…user7093388 61 views 4 comments 0 points Most recent by user7093388 Oracle Analytics Cloud and Server -
Custom field calculations at total levelNA version, CLOUD: Reporting / Dashboards ACTUAL BEHAVIOR -------------- When creating a custom column defined as "Units"."Remaining Units"/"Units"."Limit" the summary h…User_H0QFW 41 views 1 comment 0 points Most recent by Christian Berg-0racle Oracle Analytics Cloud and Server
-
TimeStampDiff in Hours Excluding WeekendsHi, Anyone can help how can I get the timestampdiff in hours between two dates: ("Procurement - Purchase Orders"."Requisition Lines"."DW_FA_X_REQ_LINE_TIMESTAMPS_LASTAPP…JobDeLuna 31 views 4 comments 0 points Most recent by JobDeLuna Oracle Transactional Business Intelligence