Enable users to export or view in a table format the forecasts generated from graphs using ETS, ARIMA, or Prophet models.
Brillant idea!
Loved the idea. Thinking of few use cases:
Edit:
Upvoted.
Yes this is a great idea and fits in with similar related submitted ideas elsewhere
As mentioned by @Gianni Ceresa , using the forecast function will allow to do the same. Basically surfacing this function as a feature with one-click would achieve what is requested:
@Benjamin Arnulf-Oracle @Gianni Ceresa
I am using the forecast function as shown above and running in to challenges when viewing multiple departments within one table. For example, forecasting FTE by department. If I look at one department at a time the forecast seems accurate, but when I add multiple departments, it shifts the forecast and seems like it is considering the FTE for all departments to forecast the FTE for one. Has anyone else experienced this? Example below.
When the table contains multiple departments, the forecast for one department is as follows (nothing in the data suggests we will be at 34.85 next month):
When we view this same department as the only department in the table, it seems accurate:
+ @Avinash Krishnaram-Oracle for additional expertise.
@Lalitha Venkataraman-Oracle - can you pls check if the customer needs to file a SR to triage this further?
@Lalitha Venkataraman-Oracle I wanted to check if there are any updates on this. We have a strong business need to use the forecasting feature within a table, but the current data accuracy is preventing us from moving forward. Could you advise on next steps or any actions we can take to resolve this?
@Gina DiVenti Hope you are doing wwell. I am trying to replicate the issue. I have tried few cases and could not narrow down to the scenario. In my dataset, I have 3 Departments: Furniture, Office Supplies and Technology. I am predicting Sales for each department.
Background:
Sales Overall Prediction (1 Period Ahead) - 223.68M Each Department Individually : Furniture (1 Period Ahead) - 66.6M Office Supplies (1 Period Ahead) - 126.2M Technology (1 Period Ahead) - 40M Sum = ~232.8M If you predict independently, you will always have some difference. That is the statistical variation. In simple words, Smaller Segments have high variation. I guess this is not what you are referring to.
Case
Descriptions
Observations
1
Forecast Calculation vs Right Click Forecast
Same values are reflected
2
Predicting Each department Independently and Summing them - All departments are just added to Color
Sales Overall Prediction (1 Period Ahead) - 223.68M
Each Department Individually :
Furniture (1 Period Ahead) - 66.6M
Office Supplies (1 Period Ahead) - 126.2M
Technology (1 Period Ahead) - 40MSum = ~232.8M
3
Predicting Each department Independently and Summing them
- All departments are just added to Trellis
Same behaviour as above
I am trying to replicate this Scenario you mentioned - "" When the table contains multiple departments, the forecast for one department is as follows (nothing in the data suggests we will be at 34.85 next month) "" Please share with me more details like - Formula( …) Model, preiods projected etc. This would help me narrow down and understand the issue better.
@Laxminag Mamillapalli thank you for helping look at this! I will try to explain better below what I am seeing.
The goal is to have a single consolidated table that includes multiple departments, with each department having its own independent forecast. The FTE values from other departments should not influence or alter the forecast for a department. We’ve observed that forecasts differ when multiple departments are included in a single table compared to when each department is analyzed individually. In the comparison below, the first table is filtered to three departments, while the second table is filtered to one department only. The individual department forecast (table 2) appears accurate, whereas the combined table seems to average across all departments, resulting in less accurate forecasts. We would expect that the forecasts for Department 3 would be the same across both tables, regardless of how many other departments are in the first table.
Department Name
Month
Assigned FTE
FTE Projection
Department 1
2024 / 10
4.00
2024 / 11
2024 / 12
2025 / 01
2025 / 02
2025 / 03
2025 / 04
2025 / 05
2025 / 06
2025 / 07
2025 / 08
2025 / 09
2025 / 10
2025 / 11
2025 / 12
5.00
2026 / 01
2026 / 02
2026 / 03
Department 2
37.10
37.50
40.20
40.95
43.00
43.30
42.60
42.30
44.70
42.00
43.70
42.80
44.75
38.85
40.16
40.93
Department 3
34.25
31.90
31.10
31.40
33.65
33.60
34.00
36.40
39.80
38.55
38.40
41.55
40.15
41.05
40.45
36.82
40.19
41.40
40.80
41.14
Currently using this formula, but I have seen similar issues when using ETS. I have also expanded the timeframe to include almost 3 years and have the same problem.
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.
