This report is part of a series. See .
Actions
Supply results to application development and QA management.
Review lists of server environment counts by OS, purpose, and application to determine whether any dev to prod ratios are too high (and why).
If appropriate, take steps to reduce the dev to prod (or dev+test to prod) ratios to curtail server environment sprawl and reduce server cost.
When cost model is complete, add cost to this report.
Data
REQUIRED
Servers Master Data.Environment
Servers Master Data.Server Count
USEFUL
Servers Master Data.OS
Servers Master Data.Purpose
Servers Master Data.Application
Build the report
BUILD REPORT TITLE
(top) Ribbon > Report > HTML.
In Edit Content window, paste:
<span style="font-size:x-large">Server Environment Sprawl</span>
ADD COLUMNS TO SERVER DATA TABLE
(left) Project explorer > Tables > Servers Master Data: Check out table.
In transform pipeline, select FORMULAS step.
Add new columns:
(numeric) Dev Count =If(Environment="Development", Server Count, 0)
(numeric) Test Count =If(Environment="Test", Server Count, 0)
(numeric) Prod Count =If(Environment="Production", Server Count, 0)
BUILD MAIN KPI
(top) Ribbon > Report > HTML.
Paste this code into the Edit Content panel:
<div>
<table width="100%" style="border-bottom:2px solid #FF661C; margin-top:10px">
<tr>
<td align="left" class="apps-header-text" style="color:#E5E5E5">
<span style="float:right"></span>
</td>
</tr>
</table>
</div>
<div class="kpi-bar-horizontal" style="background-color:white; padding:2px; margin:0px; width:94%">
<div style="padding-left:5px; padding-right:5px">
<span style="color:#004C76"><B>Dev to Prod Ratio</B></span>
</div>
<div class="kpi-bar-value">
<span style="color:black">
<%=If(Eval(Servers Master Data.Dev Count / Servers Master Data.Prod Count) = 0, "", If(Eval(Servers Master Data.Dev Count / Servers Master Data.Prod Count) > 1, Round(Eval(Servers Master Data.Dev Count / Servers Master Data.Prod Count), 1) & " : 1", If(Eval(Servers Master Data.Dev Count / Servers Master Data.Prod Count) < 1, "1 : " & Round(Eval(Servers Master Data.Prod Count / Servers Master Data.Dev Count), 1), "1 : 1")))%>
</span>
</div>
<div>
<span style="font-size:90%; color:gray">
Dev and Test to Prod Ratio:
<%=If(Eval((Servers Master Data.Dev Count + Servers Master Data.Test Count) / Servers Master Data.Prod Count) = 0, "", If(Eval((Servers Master Data.Dev Count + Servers Master Data.Test Count) / Servers Master Data.Prod Count) > 1, Round(Eval((Servers Master Data.Dev Count + Servers Master Data.Test Count) / Servers Master Data.Prod Count), 1) & " : 1", If(Eval((Servers Master Data.Dev Count + Servers Master Data.Test Count) / Servers Master Data.Prod Count) < 1, "1 : " & Round(Eval(Servers Master Data.Prod Count / (Servers Master Data.Dev Count + Servers Master Data.Test Count)), 1), "1 : 1")))%>
</span>
</div>
(left) Project explorer > Tables > Servers > Environment: Drag to Rows area in HTML Configuration panel.
BUILD KPI x 3
(top) Ribbon > Report > KPI.
Select the newly added KPI.
(left) Project explorer > Tables > Servers > Dev Count: Drag to KPIs area in KPI Configuration panel.
(left) Project explorer > Tables > Servers > Test Count: Drag to KPIs area in KPI Configuration panel.
(left) Project explorer > Tables > Servers > Prod Count: Drag to KPIs area in KPI Configuration panel.
BUILD LINE CHART
(top) Ribbon > Report > Table.
(left) Project explorer > Tables > Servers > Dev Count: Drag to Values area in ad hoc component configuration (AHCC) panel.
(left) Project explorer > Tables > Servers > Test Count: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > Prod Count: Drag to Values area in AHCC panel.
(left) Project explorer > Time > Months (Yr): Drag to Columns area in AHCC panel.
(top) Ribbon > Ad hoc > Line.
Right-click table > Properties:
General > Name: Server Environment Count.
General > Show header: Check box.
Chart > Legend location: East.
BUILD OS TABLE
(top) Ribbon > Report > Table.
(left) Project explorer > Tables > Servers > OS: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > Dev Count: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > Test Count: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > Prod Count: Drag to Values area in AHCC panel.
(top) Ribbon > Data > Insert > Insert formula column:
Name: Dev to Prod Ratio
Enter formula: =Round(Servers Master Data.Dev Count / Servers Master Data.Prod Count,2)
Format: Advanced
User defined formula: =If({$_}=0, "", If({$_} > 1, {$_} & " : 1", If({$_} < 1, "1 : " & Round(1 / {$_}, 1), "1 : 1")))
(top) Ribbon > Data > Insert > Insert formula column:
Name: Dev and Test to Prod Ratio
Enter formula: =Round((Servers Master Data.Dev Count + Servers Master Data.Test Count) / Servers Master Data.Prod Count,1)
Format: Advanced
User defined formula: =If({$_}=0, "", If({$_} > 1, {$_} & " : 1", If({$_} < 1, "1 : " & Round(1 / {$_}, 1), "1 : 1")))
Right-click table > Properties:
General > Name: Server Environment Count by OS.
General > Show header: Check box.
BUILD PURPOSE TABLE
Right-click on OS table > Copy to clipboard.
(bottom right) Report clipboard > Paste all.
Drag pasted table to any new location.
(left) Project explorer > Tables > Servers > Purpose: Drag to Rows area in AHCC panel.
Remove OS from Rows area in AHCC panel.
Right-click table > Properties:
General > Name: Server Environment Count by Purpose.
BUILD APPLICATION TABLE
Right-click on OS table > Copy to clipboard.
(bottom right) Report clipboard > Paste all.
Drag pasted table to any new location.
(left) Project explorer > Tables > Servers > Application: Drag to Rows area in AHCC panel.
Remove OS from Rows area in AHCC panel.
Right-click table > Properties:
General > Name: Server Environment Count by Application.