Popular Tags
- OTBI 1,468
- Reporting 1,404
- FDI 1,179
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 606
- Administration 556
- OAC 510
- 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
Calculation
Discussion List
-
How to exclude a specific value from an expression filterCurrently working on a report and coming across an instance in which I do not want NULLS included in my filter. One Assignment Number can have multiple Last Update Dates… -
In FDI using a custom subject area, how to perform detail calculations at a record level?In FDI using a custom subject area, how do I perform detail calculations at a record level before doing aggregation? We have customer shipments data; one line per shipme…Paul Therrien 1 view 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum -
Formula to to always aggregate by a dimension and allow other grouping in visualWe have a formula that should always be aggregated by the Ledger Currency in FDI but it also may need to be visualized by other dimensions: Fiscal Year, or Business Unit…Fred Kaffenberger-Oracle 49 views 1 comment 0 points Most recent by Chere-Oracle Oracle Analytics Forum -
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"JobDeLuna 41 views 3 comments 1 point Most recent by Jestin Rajan Oracle Fusion AI Data Platform Forum -
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… -
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 Forum
-
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 …
-
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…
-
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… -
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 and AI 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 41 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Fusion AI Data Platform Forum -
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 and AI 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 AI Data Platform Forum
-
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…Chelsea H. 124 views 5 comments 1 point Most recent by Chelsea H. Oracle Fusion AI Data Platform Forum -
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 and AI Trainings