<Cube xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="fd18731f-ba16-4721-91c9-b5b60062c461" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <ID>Health Care System</ID> <Name>Health Care System</Name> <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp> <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate> <Annotations> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name> <Value> <dds xmlns=""> <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="7" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-6890" scrolltop="-2387" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="17420" y="15833" backcolor="16777215" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}"> <font> <ddsxmlobjectstreamwrapper binary="010000009001b0300100065461686f6d61" /> </font> <mouseicon> <ddsxmlobjectstreamwrapper binary="6c74000000000000" /> </mouseicon> </diagram> <layoutmanager> <ddsxmlobj /> </layoutmanager> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge" tooltip="Group_2121507" left="6477" top="7201" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="3154" height="4106" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000e0000520c00000a100000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dbo_Group_2121507" vartype="8" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge" tooltip="SUBSCRIBER_2121507" left="1939" top="-403" logicalid="2" controlid="2" masterid="0" hint1="0" hint2="0" width="3000" height="4826" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000e0000b80b0000da120000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dbo_SUBSCRIBER_2121507" vartype="8" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="4239" top="4123" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3115" height="3578" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dataSet.Relations[SUBSCRIBER_2121507-Group_2121507]" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="MSDDS.Rectilinear" sourceid="1" destid="2" sourceattachpoint="0" destattachpoint="9" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="6954" y="7201" /> <point x="6954" y="5812" /> <point x="4539" y="5812" /> <point x="4539" y="4423" /> </connector> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge" tooltip="SUBGRP_2121507" left="-6755" top="2236" logicalid="4" controlid="4" masterid="0" hint1="0" hint2="0" width="3069" height="3027" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobjectstreaminitwrapper binary="000e0000fd0b0000d30b0000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dbo_SUBGRP_2121507" vartype="8" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-3986" top="2250" logicalid="5" controlid="5" masterid="0" hint1="0" hint2="0" width="6225" height="2260" noresize="0" nomove="0" nodefaultattachpoints="1" autodrag="0" usedefaultiddshape="0" selectable="1" showselectionhandles="0" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0"> <control> <ddsxmlobj> <polyline endtypedst="6" endtypesrc="3" usercolor="0" linestyle="0" linerender="1" customendtypedstid="0" customendtypesrcid="0" adornsvisible="1" /> </ddsxmlobj> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dataSet.Relations[SUBGRP_2121507-SUBSCRIBER_2121507]" vartype="8" /> <property name="Virtual" value="0" vartype="11" /> <property name="VisibleAP" value="0" vartype="3" /> </ddsxmlobj> </layoutobject> <connector lineroutestyle="MSDDS.Rectilinear" sourceid="4" destid="2" sourceattachpoint="11" destattachpoint="26" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="-3686" y="2649" /> <point x="-175" y="2649" /> <point x="-175" y="4210" /> <point x="1939" y="4210" /> </connector> </ddscontrol> </dds> </Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name> <Value>true</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name> <Value>false</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name> <Value>true</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name> <Value>-6890</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name> <Value>-2387</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name> <Value>-6755</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name> <Value>-403</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name> <Value>100</Value> </Annotation> </Annotations> <LastProcessed>0001-01-01T00:00:00Z</LastProcessed> <State>Unprocessed</State> <Dimensions> <Dimension dwd:design-time-name="95883b08-cbc6-4df1-8f14-6ea2eba68e22"> <ID>Group 2121507</ID> <Name>Group 2121507</Name> <DimensionID>Group 2121507</DimensionID> <Attributes> <Attribute dwd:design-time-name="d529fa03-3fc1-43a4-a951-1b4e5efd6320"> <AttributeID>GROUP ID</AttributeID> </Attribute> </Attributes> </Dimension> <Dimension dwd:design-time-name="4777c142-142e-4c95-85f4-76b8bb617dfe"> <ID>SUBSCRIBER 2121507</ID> <Name>SUBSCRIBER 2121507</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute dwd:design-time-name="bcc8b744-4111-43f6-9ad5-590072d17b25"> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="ba78d154-5f16-4679-8326-463ab0df966a"> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="677a0c7d-6a0d-45a3-b87d-c411701fecb4"> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="a6f71285-e429-4544-b3d5-901b70b8dcf4"> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="f1b44b43-8eee-4150-aa34-ad565d9f14e8"> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="2a984795-79a1-454e-94fd-7b926ab7ec36"> <AttributeID>CITY</AttributeID> </Attribute> <Attribute dwd:design-time-name="7d668b4a-acda-4745-9ca3-1bae597b9d93"> <AttributeID>STATE</AttributeID> </Attribute> <Attribute dwd:design-time-name="808eb3f8-8f19-4280-b458-fa221e2f26b0"> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy dwd:design-time-name="cc8a2add-6022-4020-bea6-ece6fb9977af"> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> <Dimension dwd:design-time-name="2bbce993-a7a2-44ec-befe-b63f1361faed"> <ID>SUBGRP</ID> <Name>SUBGRP</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute dwd:design-time-name="38cebbb7-0a0c-4f22-aa18-8525e4016b9b"> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="bb4e6280-ef5d-45e6-afb0-f2d25bd8fce3"> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="ddb11307-f173-44e3-a71b-4b8c2d04880b"> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="e5d4b53e-3e1c-47b8-a734-7d979c1ca202"> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="bef050bf-95af-4d78-9638-723a517f6f2f"> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="24c7677b-5bdc-4c50-a95f-f9486b8a2c74"> <AttributeID>CITY</AttributeID> </Attribute> <Attribute dwd:design-time-name="a5edf9b6-18ae-4bdf-b8e9-1f75fce79094"> <AttributeID>STATE</AttributeID> </Attribute> <Attribute dwd:design-time-name="b65f7f01-e1c2-43c9-871a-4efaa7063b2c"> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy dwd:design-time-name="3961d192-d7b6-4975-922e-ebda13791b9e"> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> <Dimension dwd:design-time-name="a096a370-197d-41de-a8a2-39e74be99fec"> <ID>GRP</ID> <Name>GRP</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute dwd:design-time-name="bc44d69e-c569-4ec4-8a5d-63c811688ab7"> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="84d19ace-25a6-4e21-b675-137e902758e2"> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="fda4d5ca-ad10-4794-b264-b25ed6ab3891"> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute dwd:design-time-name="bdd9a447-3a22-4b28-827b-85e0a00c252f"> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="d34ecdc9-0565-4326-8e67-7ba7247b2cbb"> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute dwd:design-time-name="8a620ffe-1b61-4e08-96f1-f4c859eee693"> <AttributeID>CITY</AttributeID> </Attribute> <Attribute dwd:design-time-name="da6f6722-a942-4c1c-bfdc-6352c5aa1051"> <AttributeID>STATE</AttributeID> </Attribute> <Attribute dwd:design-time-name="633f2c1c-bc64-4466-aaaa-5898ee1ed6d7"> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy dwd:design-time-name="08b451cb-c517-4455-b846-2545d60aeccc"> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> </Dimensions> <MeasureGroups> <MeasureGroup dwd:design-time-name="44c91b2f-1ed6-42ba-8018-c5db4b54976c"> <ID>SUBSCRIBER 2121507</ID> <Name>SUBSCRIBER 2121507</Name> <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp> <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate> <LastProcessed>0001-01-01T00:00:00Z</LastProcessed> <State>Unprocessed</State> <Measures> <Measure dwd:design-time-name="5851dae9-8af6-4694-a113-91e8756dd9a2"> <ID>SUB SK</ID> <Name>SUB SK</Name> <Source dwd:design-time-name="3a3640cc-f9a1-4820-b19a-1262c3171887"> <DataType>Double</DataType> <Source xsi:type="ColumnBinding" dwd:design-time-name="da5224fd-85f3-43d5-913f-5dcbe6a4a3fa"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_SK</ColumnID> </Source> </Source> </Measure> <Measure dwd:design-time-name="794441f0-55bd-48a0-ba4a-9dcec16dbf39"> <ID>SUBSCRIBER 2121507 Count</ID> <Name>SUBSCRIBER 2121507 Count</Name> <AggregateFunction>Count</AggregateFunction> <Source dwd:design-time-name="1722b4c0-1f22-4bf2-976d-12c17c626a66"> <DataType>Integer</DataType> <DataSize>4</DataSize> <Source xsi:type="RowBinding" dwd:design-time-name="2a7bc3d8-7a7b-44e8-8795-8e61d86f3481"> <TableID>dbo_SUBSCRIBER_2121507</TableID> </Source> </Source> </Measure> </Measures> <StorageMode>Molap</StorageMode> <ProcessingMode>Regular</ProcessingMode> <Dimensions> <Dimension xsi:type="RegularMeasureGroupDimension" dwd:design-time-name="da318fd6-8c84-4d92-a5d4-eec8a86e667b"> <CubeDimensionID>Group 2121507</CubeDimensionID> <Attributes> <Attribute dwd:design-time-name="db360620-e311-434d-a272-f3e6240d58e7"> <AttributeID>GROUP ID</AttributeID> <KeyColumns> <KeyColumn dwd:design-time-name="de7db4f0-99d6-43c8-b0cb-df9a9b8e6a52"> <DataType>WChar</DataType> <DataSize>8</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding" dwd:design-time-name="ff6c739a-ab21-499d-a659-1848db41c5d9"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>GRP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension" dwd:design-time-name="3c3e005f-dc6a-4e60-bd3c-f24fe4097711"> <CubeDimensionID>SUBSCRIBER 2121507</CubeDimensionID> <Attributes> <Attribute dwd:design-time-name="4910edbb-b99c-4442-901c-8615605463db"> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn dwd:design-time-name="d48bbfcc-7330-4d10-88fe-d797d0b55336"> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding" dwd:design-time-name="04902bc7-334d-4e8f-b660-62f7b360bd5f"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension" dwd:design-time-name="1eecce84-79bf-45bb-a2ff-a8a065d0496a"> <CubeDimensionID>SUBGRP</CubeDimensionID> <Attributes> <Attribute dwd:design-time-name="8f0af927-1dea-4da8-8532-a82d1e74cba1"> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn dwd:design-time-name="9c400538-da67-4288-aa72-c7c4d015ccd1"> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding" dwd:design-time-name="dae0407c-ef20-4384-b50b-f2e82573a715"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension" dwd:design-time-name="1361fb32-4d0b-4a9f-9601-f709d05daee7"> <CubeDimensionID>GRP</CubeDimensionID> <Attributes> <Attribute dwd:design-time-name="79193a90-7d7b-4474-b22c-7edb1c95cf68"> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn dwd:design-time-name="3a0e1e2b-363b-4d58-9e9d-d87b810ffae3"> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding" dwd:design-time-name="e6ff2e51-171f-450e-a683-f4d2db619f03"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> </Dimensions> <Partitions /> </MeasureGroup> </MeasureGroups> <Source dwd:design-time-name="870e3d12-fe8e-4615-bf43-ddfb1bf88ae9"> <DataSourceViewID>Health Care System</DataSourceViewID> </Source> </Cube>