Popular Tags
- OTBI 1,446
- Reporting 1,392
- FDI 1,116
- Analysis and Data Visualization 986
- BI Publisher 854
- Analysis 682
- Oracle Fusion Analytics 585
- Administration 555
- OAC 449
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 356
- Security 293
- HCM 266
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 179
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Calculation
Discussion List
-
Expression Filter to Filter to MAX DateHi, Request any help the possibility for an expression filter to filter to the MAX Date. "SCST - Savings Impact Reporting"."Time"."Snapshot Date" -
6Treat numeric constant in calculation as a measureCurrently when a calculation is defined as a constant (simple number) the calculation is treated as an attribute instead of a measure. This makes it very inconvenient fo…Rob Roush 32 views 4 comments 6 points Most recent by Rob Roush Oracle Analytics Cloud and Server Idea Lab -
How to do this in Pivot graph in OAS BI ToolHi All, Please see the screenshot I am using pivot graph . But yoy and yoy% its repeating same in two columns, what i want yoy and yoy% to reflect after May-25 , so its … -
Pivot Table incorrect totalI created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly …Donna Fazio 11 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
2Waterfall Charts: X-Axis ModificationsCurrently to enable waterfall charts to walk from Plan to Actuals (within a single reporting period), I need to write a calculation to create an additional date column (… -
How to filter dynamically Oct 204 vs Nov 2024 and Nov 2023 vs Nov 2024 (YTD)Hi , I have a column called pro_dte and value inside like this 30/11/2023 12:00:00 am. It will only have last day of the month for all records. My question is, I have a …User_65OG0 31 views 3 comments 0 points Most recent by Rajakumar Burra Oracle Analytics Cloud and Server
-
I have created few calculation I want to use them in another calculation but its expanding the whoI have created few calculation I want to use them in another calculation but its expanding the whole formula which is making its mess and I am not able to write big comp…User_6Q5NK 11 views 1 comment 0 points Most recent by Rajakumar Burra Oracle Analytics Cloud and Server
-
How can I change the context to consider ALL the historyHello Oracle folks! I've been trying to calculate if the purchase made by a customer this month (the context is given by a report filter) is his/her first purchase and c…Adrian Coronado 22 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
April Virtual Webinars - Let's Go!April 1, 2025 at 9 AM MT - Calculations in Fusion Data Intelligence (FDI) - Intermediate Watch Replay April 14, 2025 at 10 AM MT - Create Your First Workbook in Fusion D…Aimee Williams-Oracle 151 views 0 comments 1 point 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 31 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 31 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 31 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