Explain the functionality of Quadrant Bubble Graph.
Please find the illustration below to better understand the functionality of the Quadrant Bubble graph: The horizontal line is 'Net Sales variance' and the vertical line is 'PVA Sales Variance' and the result is: (A) Top Left - (-) Net Sales variance & (+) PVA Sales Variance (B) Top Right - (+) Net Sales variance & (+) PVA Sales Variance (C) Bottom Left - (-) Net Sales variance & (-) PVA Sales Variance (D) Bottom Right - (+) Net Sales variance & (-) PVA Sales Variance Origin Calculation for Measures: The x and y plotting values for the quadrant bubble chart is calculated based on the measure origin calculation. By default it is set to average, and we have 4 different calculations such as average, sum, minimum and maximum defined for each measure. The tool tip represents the actual value of the x and y. Computations are done in the following manner: Average = Sum of the measure value / No of stores Sum = Sum of the measure value Minimum = minimum value among the measures Maximum = maximum value among the measures. Origin calculation for dimension: If you select the value for the dimension e.g: store (E309) then, the selected value will be considered for origin calculation and will override the measure defined calculations.
Related Articles
Please explain the functionality of Quadrant Bubble graph
Quadrant Bubble graph works in below manner: The horizontal line is Net Sales variance and the vertical line is PVA Sales Variance and the result is: (A) Top Left - (-) Net Sales variance & (+) PVA Sales Variance (B) Top Right - (+) Net Sales ...
What is the functionality of Quadrant Bubble Graph?
Please find the illustration below to better understand the functionality of the Quadrant Bubble graph: -------------------------------------- The horizontal line is Net Sales variance and the vertical line is. PVA Sales Variance and the result is: ...
Explain the functionality of 'After ETL'. How is it processed?
Functionality of After ETL Implementation: One quartz thread will be created at the start of the Tomcat. This thread will start running from midnight 12:00 AM till it finds the ETL status as YES for every 15 minutes. It will check the table ...
Explain the functionality of Global Default Management for filters.
Using the global default management for filters, we can define the default filters globally for all the users for: a) KPIs b) KPI Groups c) Modules Filter Precedence in ARC: ----------------------------------- Filters set at KPI level override the ...
Where do we use an Expression measure? Explain its functionality
Expression measure is used in instances where there is a necessity to satisfy conditions using certain conditional statements like IF-THEN-ELSE. A base measure as well as a computed measure can be used/referred within an expression measure; however ...