Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Calculation
Discussion List
-
2Add the possibility to use Lag/Lead functions to DVAdd the possibility to use Lag/Lead functions to DVFrank Van Imschoot 5 views 0 comments 2 points Started by Frank Van Imschoot Oracle Analytics Idea Lab -
Using LOCATE() with WildcardsIs it possible to use LOCATE(), or a similar function, with wildcards? For example, if i'm searching in a string for '%N.___.3__%'. Is it possible to use an existing fun… -
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 2 views 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 54 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 13 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 Most recent 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…JobDeLuna 11 views 0 comments 0 points Most recent by JobDeLuna Oracle Fusion AI Data Platform Forum
-
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 42 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 Most recent 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…