Execute What-If Analysis
Description
This activity runs the user-defined What-If analysis, utilizing predefined formulas to fetch and process data from a data source.
Input
What-If Analysis configuration
Output
Processed data based on the What-If analysis
Configuration Fields
What-if analysis Specifies the predefined What-If analysis aligned with the analysis goals. Export format Determines the export format for the analysis results. Scenario Defines the parameter configuration for the What-If analysis. Query Serves as the foundation for executing the What-If analysis. Filters Adds dimension filters to refine the data for the analysis.
Sample Input
Not Applicable
Sample Configuration
Sample Output
| Scenario Name | Region | Year | Revenue Impact | Cost Impact | Profit Margin |
|---|---|---|---|---|---|
| Base Case | North America | 2024 | 1,500,000 | 500,000 | 30% |
| Best Case | North America | 2024 | 2,000,000 | 450,000 | 40% |
| Worst Case | North America | 2024 | 1,200,000 | 550,000 | 25% |