<report xmlns="http://developer.cognos.com/schemas/report/11.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name=&apos;Packages&apos;]/package[@name=&apos;Inventory&apos;]/model[@name=&apos;model&apos;]</modelPath>
				<drillBehavior/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								</style>
								<pageBody>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pb"/>
										</defaultStyles>
									</style>
									<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Operational Health - Thin Pools nearing Full Capacity in &lt;90 Days</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="padding-left:24px;height:36px;background-color:#FBFBFB"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Query1" rowsPerPage="20000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Array"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Array"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Pool"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Pool"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Usable (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Usable (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Utilization (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Utilization (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Expected Date to Full Utilization"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Expected Date to Full Utilization"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Expected Days to Full Utilization"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Expected Days to Full Utilization"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Expected Days to Full Utilization"/></sortList></list></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							<pageFooter><contents><table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																
															<image>
			<dataSource>
				<staticValue>/reporting/sanscreen/images/netapp_logo.png</staticValue>
			</dataSource>
		<style><CSS value="width:90px;height:36px"/></style></image></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:left;width:30%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																
															<textItem><dataSource><staticValue>OnCommand Insight 7.1. © 2014-15 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%;height:32px"/>
											</style>
										</table></contents><style><CSS value="padding:10px 15px 10px 15px;background-color:#FBFBFB"/></style></pageFooter></page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2015-04-14T12:20:59.758Z" output="no"/></XMLAttributes><reportName>Operational Health - Thin Pools nearing Full Capacity in &lt;90 Days</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Query1"><source><sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	dwh_capacity.storage_dimension.name AS &apos;Array&apos;,
	dwh_capacity.storage_pool_dimension.name AS &apos;Pool&apos;,
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB/1024,2) AS &apos;Usable (GB)&apos;,
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1024,2) AS &apos;Used (GB)&apos;,
	ROUND(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB, 4) AS &apos;Utilization (%)&apos;,
	dwh_capacity.sp_time_to_fill.dateAtStoragePoolFull AS &apos;Expected Date to Full Utilization&apos;,
	dwh_capacity.sp_time_to_fill.daysToStoragePoolFull AS &apos;Expected Days to Full Utilization&apos;
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
JOIN 	dwh_capacity.storage_pool_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
AND 	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 1
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN 	dwh_capacity.sp_time_to_fill
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tk = dwh_capacity.sp_time_to_fill.saspFactTk
WHERE 	dwh_capacity.sp_time_to_fill.daysToStoragePoolFull &lt;= 90</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Pool"/><mdProjectedItem name="Usable (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Utilization (%)"/><mdProjectedItem name="Expected Date to Full Utilization"/><mdProjectedItem name="Expected Days to Full Utilization"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Array"><expression>[SQL1].[Array]</expression></dataItem><dataItem name="Pool"><expression>[SQL1].[Pool]</expression></dataItem><dataItem name="Usable (GB)"><expression>[SQL1].[Usable (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL1].[Used (GB)]</expression></dataItem><dataItem name="Utilization (%)"><expression>[SQL1].[Utilization (%)]</expression></dataItem><dataItem name="Expected Date to Full Utilization"><expression>[SQL1].[Expected Date to Full Utilization]</expression></dataItem><dataItem name="Expected Days to Full Utilization"><expression>[SQL1].[Expected Days to Full Utilization]</expression></dataItem></selection></query></queries></report>