Popular Tags
- OTBI 1,507
- Reporting 1,423
- FDI 1,306
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,016
- BI Publisher 900
- Analysis 699
- Oracle Fusion Analytics 635
- OAC 590
- Administration 566
- Fusion HCM Analytics 459
- Analytics 454
- Fusion ERP Analytics 453
- OBIEE 444
- BI Publisher Data Models 371
- Security 305
- Oracle Analytics Cloud 300
- HCM 295
- Fusion Data Intelligence 289
- BIP 272
- Fusion Data Intelligence FDI 267
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
Calculation
Discussion List
-
1Building a Dynamic Reporting Period Parameter in Oracle AnalyticsOne challenge I encountered in Oracle Analytics was creating a DV that would automatically follow the current reporting period so that upon opening, it would already hav…Rob Toogood 51 views 0 comments 1 point Started by Rob Toogood Oracle AI and Analytics Sharing Center -
Is it possible to use Parameters to control the Format applied to dates?There's an interesting blog/video that shows how to use a combination of Parameters and Calculations to create "Dynamic Filters". Such as having a User be able to select… -
7Add the possibility to use Lag/Lead functions to DVAdd the possibility to use Lag/Lead functions to DVFrank Van Imschoot 41 views 0 comments 7 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…Kevin Riedy 82 views 4 comments 2 points Most recent by RVohra Oracle Fusion Data Intelligence Forum
-
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 51 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 64 views 3 comments 1 point Most recent by Jestin Rajan Oracle Fusion Data Intelligence 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 23 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 AI and 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…JobDeLuna 11 views 0 comments 0 points Most recent by JobDeLuna Oracle Fusion Data Intelligence 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 51 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Fusion Data Intelligence 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 AI and Analytics Trainings