<Database 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="http://schemas.microsoft.com/analysisservices/2003/engine"> <ID>MultidimensionalProject1</ID> <Name>MultidimensionalProject1</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> <LastUpdate>0001-01-01T00:00:00Z</LastUpdate> <DataSourceImpersonationInfo> <ImpersonationMode>Default</ImpersonationMode> <ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity> </DataSourceImpersonationInfo> <Dimensions> <Dimension> <ID>Group 2121507</ID> <Name>Group 2121507</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="2" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1874" scrolltop="-6223" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="6943" y="16552" 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="20" top="0" 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> </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>-1874</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name> <Value>-6223</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name> <Value>20</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name> <Value>0</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> <Source xsi:type="DataSourceViewBinding"> <DataSourceViewID>Health Care System</DataSourceViewID> </Source> <UnknownMember>Visible</UnknownMember> <ErrorConfiguration> <KeyNotFound>ReportAndStop</KeyNotFound> <KeyDuplicate>ReportAndStop</KeyDuplicate> <NullKeyNotAllowed>ReportAndStop</NullKeyNotAllowed> </ErrorConfiguration> <CurrentStorageMode>Molap</CurrentStorageMode> <Attributes> <Attribute> <ID>GROUP ID</ID> <Name>GROUP ID</Name> <Usage>Key</Usage> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>8</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>GROUP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> </Attributes> <ddl300:ProcessingState>Unprocessed</ddl300:ProcessingState> </Dimension> <Dimension> <ID>SUBGRP 2121507</ID> <Name>SUBGRP 2121507</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="5" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-1578" scrolltop="-3287" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="6943" 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="SUBGRP_2121507" left="20" top="0" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="3302" 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="000e0000e60c0000d30b0000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dbo_SUBGRP_2121507" vartype="8" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge" tooltip="Group_2121507" left="94" top="5427" logicalid="2" controlid="2" 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> </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>-1578</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name> <Value>-3287</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name> <Value>20</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name> <Value>0</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> <Source xsi:type="DataSourceViewBinding"> <DataSourceViewID>Health Care System</DataSourceViewID> </Source> <UnknownMember>Visible</UnknownMember> <ErrorConfiguration> <KeyNotFound>ReportAndStop</KeyNotFound> <KeyDuplicate>ReportAndStop</KeyDuplicate> <NullKeyNotAllowed>ReportAndStop</NullKeyNotAllowed> </ErrorConfiguration> <CurrentStorageMode>Molap</CurrentStorageMode> <Attributes> <Attribute> <ID>SUBGRP SK</ID> <Name>SUBGRP SK</Name> <Usage>Key</Usage> <KeyColumns> <KeyColumn> <DataType>Double</DataType> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBGRP_2121507</TableID> <ColumnID>SUBGRP_SK</ColumnID> </Source> </KeyColumn> </KeyColumns> <AttributeRelationships> <AttributeRelationship> <AttributeID>GROUP ID</AttributeID> <Name>GROUP ID</Name> </AttributeRelationship> </AttributeRelationships> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>GROUP ID</ID> <Name>GROUP ID</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>8</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>GROUP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> </Attributes> <ddl300:ProcessingState>Unprocessed</ddl300:ProcessingState> </Dimension> <Dimension> <ID>SUBSCRIBER 2121507</ID> <Name>SUBSCRIBER 2121507</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="39" scrolltop="-5072" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="75" x="6943" 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="1" 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="2794" top="0" 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="20" top="6506" 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="DdsShapes.DdsObjectManagedBridge" tooltip="SUBGRP_2121507" left="5420" top="7405" logicalid="3" controlid="3" masterid="0" hint1="0" hint2="0" width="3302" 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="000e0000e60c0000d30b0000" /> </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="1220" top="3607" logicalid="4" controlid="4" masterid="0" hint1="0" hint2="0" width="2451" height="3199" 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="1" destattachpoint="4" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="3271" y="4106" /> <point x="3271" y="5306" /> <point x="1520" y="5306" /> <point x="1520" y="6506" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="2720" top="8519" logicalid="6" controlid="6" masterid="0" hint1="0" hint2="0" width="3000" height="799" 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="3" destid="2" sourceattachpoint="14" destattachpoint="19" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="5420" y="8918" /> <point x="4220" y="8918" /> <point x="4220" y="8919" /> <point x="3020" y="8919" /> </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>39</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name> <Value>-5072</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name> <Value>20</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name> <Value>0</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name> <Value>75</Value> </Annotation> </Annotations> <LastProcessed>0001-01-01T00:00:00Z</LastProcessed> <State>Unprocessed</State> <Source xsi:type="DataSourceViewBinding"> <DataSourceViewID>Health Care System</DataSourceViewID> </Source> <UnknownMember>Visible</UnknownMember> <ErrorConfiguration> <KeyNotFound>ReportAndStop</KeyNotFound> <KeyDuplicate>ReportAndStop</KeyDuplicate> <NullKeyNotAllowed>ReportAndStop</NullKeyNotAllowed> </ErrorConfiguration> <CurrentStorageMode>Molap</CurrentStorageMode> <Attributes> <Attribute> <ID>SUB ID</ID> <Name>SUB ID</Name> <Usage>Key</Usage> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <AttributeRelationships> <AttributeRelationship> <AttributeID>SUBGRP ID</AttributeID> <Name>SUBGRP ID</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>GROUP ID</AttributeID> <Name>GROUP ID</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>GROUP NAME</AttributeID> <Name>GROUP NAME</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>SUBGRP NAME</AttributeID> <Name>SUBGRP NAME</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>CITY</AttributeID> <Name>CITY</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>STATE</AttributeID> <Name>STATE</Name> </AttributeRelationship> <AttributeRelationship> <AttributeID>STREET</AttributeID> <Name>STREET</Name> </AttributeRelationship> </AttributeRelationships> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>SUBGRP ID</ID> <Name>SUBGRP ID</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>4</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBGRP_2121507</TableID> <ColumnID>SUBGRP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>GROUP ID</ID> <Name>GROUP ID</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>8</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>GROUP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <OrderBy>Key</OrderBy> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>GROUP NAME</ID> <Name>GROUP NAME</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>30</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>GROUP_NAME</ColumnID> </Source> </KeyColumn> </KeyColumns> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>SUBGRP NAME</ID> <Name>SUBGRP NAME</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>30</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBGRP_2121507</TableID> <ColumnID>SUBGRP_NAME</ColumnID> </Source> </KeyColumn> </KeyColumns> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>CITY</ID> <Name>CITY</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>15</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>CITY</ColumnID> </Source> </KeyColumn> </KeyColumns> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>STATE</ID> <Name>STATE</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>20</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>STATE</ColumnID> </Source> </KeyColumn> </KeyColumns> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> <Attribute> <ID>STREET</ID> <Name>STREET</Name> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>35</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_Group_2121507</TableID> <ColumnID>STREET</ColumnID> </Source> </KeyColumn> </KeyColumns> <ddl200:ProcessingState>Unprocessed</ddl200:ProcessingState> <ddl300:AttributeHierarchyProcessingState>Unprocessed</ddl300:AttributeHierarchyProcessingState> </Attribute> </Attributes> <Hierarchies> <Hierarchy> <ID>Hierarchy</ID> <Name>Hierarchy</Name> <Levels> <Level> <ID>GROUP NAME</ID> <Name>GROUP NAME</Name> <SourceAttributeID>GROUP NAME</SourceAttributeID> </Level> <Level> <ID>SUBGRP NAME</ID> <Name>SUBGRP NAME</Name> <SourceAttributeID>SUBGRP NAME</SourceAttributeID> </Level> </Levels> </Hierarchy> </Hierarchies> <ddl300:ProcessingState>Unprocessed</ddl300:ProcessingState> </Dimension> </Dimensions> <Cubes> <Cube> <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> <ID>Group 2121507</ID> <Name>Group 2121507</Name> <DimensionID>Group 2121507</DimensionID> <Attributes> <Attribute> <AttributeID>GROUP ID</AttributeID> </Attribute> </Attributes> </Dimension> <Dimension> <ID>SUBSCRIBER 2121507</ID> <Name>SUBSCRIBER 2121507</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>CITY</AttributeID> </Attribute> <Attribute> <AttributeID>STATE</AttributeID> </Attribute> <Attribute> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> <Dimension> <ID>SUBGRP</ID> <Name>SUBGRP</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>CITY</AttributeID> </Attribute> <Attribute> <AttributeID>STATE</AttributeID> </Attribute> <Attribute> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> <Dimension> <ID>GRP</ID> <Name>GRP</Name> <DimensionID>SUBSCRIBER 2121507</DimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP ID</AttributeID> </Attribute> <Attribute> <AttributeID>GROUP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>SUBGRP NAME</AttributeID> </Attribute> <Attribute> <AttributeID>CITY</AttributeID> </Attribute> <Attribute> <AttributeID>STATE</AttributeID> </Attribute> <Attribute> <AttributeID>STREET</AttributeID> </Attribute> </Attributes> <Hierarchies> <Hierarchy> <HierarchyID>Hierarchy</HierarchyID> </Hierarchy> </Hierarchies> </Dimension> </Dimensions> <MeasureGroups> <MeasureGroup> <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> <ID>SUB SK</ID> <Name>SUB SK</Name> <Source> <DataType>Double</DataType> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_SK</ColumnID> </Source> </Source> </Measure> <Measure> <ID>SUBSCRIBER 2121507 Count</ID> <Name>SUBSCRIBER 2121507 Count</Name> <AggregateFunction>Count</AggregateFunction> <Source> <DataType>Integer</DataType> <DataSize>4</DataSize> <Source xsi:type="RowBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> </Source> </Source> </Measure> </Measures> <StorageMode>Molap</StorageMode> <ProcessingMode>Regular</ProcessingMode> <Dimensions> <Dimension xsi:type="RegularMeasureGroupDimension"> <CubeDimensionID>Group 2121507</CubeDimensionID> <Attributes> <Attribute> <AttributeID>GROUP ID</AttributeID> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>8</DataSize> <NullProcessing>UnknownMember</NullProcessing> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>GRP_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension"> <CubeDimensionID>SUBSCRIBER 2121507</CubeDimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension"> <CubeDimensionID>SUBGRP</CubeDimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> <Dimension xsi:type="DegenerateMeasureGroupDimension"> <CubeDimensionID>GRP</CubeDimensionID> <Attributes> <Attribute> <AttributeID>SUB ID</AttributeID> <KeyColumns> <KeyColumn> <DataType>WChar</DataType> <DataSize>9</DataSize> <Source xsi:type="ColumnBinding"> <TableID>dbo_SUBSCRIBER_2121507</TableID> <ColumnID>SUB_ID</ColumnID> </Source> </KeyColumn> </KeyColumns> <Type>Granularity</Type> </Attribute> </Attributes> </Dimension> </Dimensions> <Partitions> <Partition> <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> <Source xsi:type="DsvTableBinding"> <DataSourceViewID>Health Care System</DataSourceViewID> <TableID>dbo_SUBSCRIBER_2121507</TableID> </Source> <StorageMode>Molap</StorageMode> <CurrentStorageMode>Molap</CurrentStorageMode> <ProcessingMode>Regular</ProcessingMode> </Partition> </Partitions> </MeasureGroup> </MeasureGroups> <Source> <DataSourceViewID>Health Care System</DataSourceViewID> </Source> </Cube> </Cubes> <DataSources> <DataSource xsi:type="RelationalDataSource"> <ID>Health Care System</ID> <Name>Health Care System</Name> <CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp> <LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate> <ConnectionString>Provider=SQLNCLI11.1;Data Source=DESKTOP-CRD8C2K;Integrated Security=SSPI;Initial Catalog=HealthCareSystem</ConnectionString> <ConnectionStringSecurity>Unchanged</ConnectionStringSecurity> <ImpersonationInfo> <ImpersonationMode>ImpersonateAccount</ImpersonationMode> <Account>desktop-crd8c2k\hp</Account> <ImpersonationInfoSecurity>PasswordRemoved</ImpersonationInfoSecurity> </ImpersonationInfo> <Timeout>PT0S</Timeout> </DataSource> </DataSources> <DataSourceViews> <DataSourceView> <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:ShowFriendlyNames</Name> <Value>true</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:CurrentLayout</Name> <Value>_ALL_TABLES_</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:SchemaRestriction</Name> <Value></Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:RetrieveRelationships</Name> <Value>true</Value> </Annotation> <Annotation> <Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:Layouts</Name> <Value> <Layouts xmlns=""> <Diagram> <Name>_ALL_TABLES_</Name> <DiagramLayout> <dds> <diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="9" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-7575" scrolltop="22" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="95" x="18013" y="17844" 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="-6123" top="5406" 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="SUBGRP_2121507" left="6771" top="5372" logicalid="2" controlid="2" masterid="0" hint1="0" hint2="0" width="3302" 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="000e0000e60c0000d30b0000" /> </control> <layoutobject> <ddsxmlobj> <property name="LogicalObject" value="dbo_SUBGRP_2121507" vartype="8" /> </ddsxmlobj> </layoutobject> <shape groupshapeid="0" groupnode="0" /> </ddscontrol> <ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge" tooltip="SUBSCRIBER_2121507" left="310" top="2385" logicalid="3" controlid="3" 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="3010" top="6698" logicalid="6" controlid="6" masterid="0" hint1="0" hint2="0" width="4061" height="1137" 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="2" destid="3" sourceattachpoint="16" destattachpoint="27" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="6771" y="7435" /> <point x="5832" y="7435" /> <point x="5832" y="6998" /> <point x="3310" y="6998" /> </connector> </ddscontrol> <ddscontrol controlprogid="MSDDS.Polyline" left="-3269" top="5410" logicalid="7" controlid="7" masterid="0" hint1="0" hint2="0" width="3879" height="799" 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="3" sourceattachpoint="11" destattachpoint="22" segmenteditmode="0" bendpointeditmode="0" bendpointvisibility="0" relatedid="0" virtual="0"> <point x="-2969" y="5809" /> <point x="-90" y="5809" /> <point x="-90" y="5898" /> <point x="310" y="5898" /> </connector> </ddscontrol> </dds> </DiagramLayout> <ShowRelationshipNames>False</ShowRelationshipNames> <UseDiagramDefaultLayout>True</UseDiagramDefaultLayout> <DiagramViewPortLeft>-7575</DiagramViewPortLeft> <DiagramViewPortTop>22</DiagramViewPortTop> <DiagramBoundingLeft>0</DiagramBoundingLeft> <DiagramBoundingTop>0</DiagramBoundingTop> <DiagramZoom>95</DiagramZoom> </Diagram> </Layouts> </Value> </Annotation> </Annotations> <DataSourceID>Health Care System</DataSourceID> <Schema> <xs:schema id="Health_x0020_Care_x0020_System" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="Health_x0020_Care_x0020_System" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:design-time-name="de80c9fb-db66-4a4a-b8fa-fe858552d542"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="dbo_Group_2121507" msprop:design-time-name="a237a819-5d0e-4b48-8f52-b571c32a77c3" msprop:FriendlyName="Group_2121507" msprop:DbSchemaName="dbo" msprop:DbTableName="Group_2121507" msprop:TableType="Table"> <xs:complexType> <xs:sequence> <xs:element name="GRP_SK" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:design-time-name="8a025933-47f4-44dc-b6bb-7d4892b05909" msprop:DbColumnName="GRP_SK" msprop:FriendlyName="GRP_SK" type="xs:decimal" /> <xs:element name="GROUP_ID" msprop:design-time-name="f27314ca-fd66-4968-b944-d8696112b61e" msprop:DbColumnName="GROUP_ID" msprop:FriendlyName="GROUP_ID"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="8" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="GROUP_NAME" msprop:design-time-name="8e763e0a-3aa3-420b-af2b-1c1b582ff77f" msprop:DbColumnName="GROUP_NAME" msprop:FriendlyName="GROUP_NAME"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="EFF_DT" msprop:design-time-name="ee54803d-d38e-4497-ab91-42319f508408" msprop:DbColumnName="EFF_DT" msprop:FriendlyName="EFF_DT" type="xs:dateTime" /> <xs:element name="TERM_DT" msprop:design-time-name="2817826a-50f8-48cd-afbe-6700a9d6a973" msprop:DbColumnName="TERM_DT" msprop:FriendlyName="TERM_DT" type="xs:dateTime" /> <xs:element name="STREET" msprop:design-time-name="d039dded-23bc-4e0e-917b-541527f24a55" msprop:DbColumnName="STREET" msprop:FriendlyName="STREET" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="35" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="CITY" msprop:design-time-name="fb648479-54d3-4c55-b1ba-9a2e6bf9e452" msprop:DbColumnName="CITY" msprop:FriendlyName="CITY" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="15" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="STATE" msprop:design-time-name="c51af2b5-60b7-4c05-b5cd-27cbfd2db93f" msprop:DbColumnName="STATE" msprop:FriendlyName="STATE" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="ZIP" msprop:design-time-name="786b507e-09d9-462e-8fd6-73ab759a24b7" msprop:DbColumnName="ZIP" msprop:FriendlyName="ZIP" type="xs:decimal" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="dbo_SUBGRP_2121507" msprop:design-time-name="15bb538c-b752-4a04-a751-175a2a3368ff" msprop:FriendlyName="SUBGRP_2121507" msprop:DbSchemaName="dbo" msprop:DbTableName="SUBGRP_2121507" msprop:TableType="Table"> <xs:complexType> <xs:sequence> <xs:element name="SUBGRP_SK" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:design-time-name="94ed0482-ba93-4381-812a-7af0be0f0c87" msprop:DbColumnName="SUBGRP_SK" msprop:FriendlyName="SUBGRP_SK" type="xs:decimal" /> <xs:element name="SUBGRP_ID" msprop:design-time-name="3aa0a4de-8f0f-4610-9ce9-4565b1ea2ded" msprop:DbColumnName="SUBGRP_ID" msprop:FriendlyName="SUBGRP_ID" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="4" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SUBGRP_NAME" msprop:design-time-name="72a31e99-197c-473d-996b-2bb07f45c84e" msprop:DbColumnName="SUBGRP_NAME" msprop:FriendlyName="SUBGRP_NAME"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="EFF_DT" msprop:design-time-name="666440a9-9c90-46e5-801c-11ee8aebffeb" msprop:DbColumnName="EFF_DT" msprop:FriendlyName="EFF_DT" type="xs:dateTime" /> <xs:element name="TERM_DT" msprop:design-time-name="f3db346f-5658-4793-8e1a-b7993e27728c" msprop:DbColumnName="TERM_DT" msprop:FriendlyName="TERM_DT" type="xs:dateTime" /> <xs:element name="GROUP_ID" msprop:design-time-name="1c9994ce-cedc-45c0-8aa7-1868341094a3" msprop:DbColumnName="GROUP_ID" msprop:FriendlyName="GROUP_ID" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="8" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="dbo_SUBSCRIBER_2121507" msprop:design-time-name="0abe290e-3663-41dd-b8a4-14104ecab7fa" msprop:FriendlyName="SUBSCRIBER_2121507" msprop:DbSchemaName="dbo" msprop:DbTableName="SUBSCRIBER_2121507" msprop:TableType="Table"> <xs:complexType> <xs:sequence> <xs:element name="SUB_SK" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:design-time-name="7d1d6223-1820-4c03-b0a1-8637ca99b6ad" msprop:DbColumnName="SUB_SK" msprop:FriendlyName="SUB_SK" type="xs:decimal" /> <xs:element name="SUB_ID" msprop:design-time-name="cf8ff20b-e39c-4216-80de-5f829bcb0fb5" msprop:DbColumnName="SUB_ID" msprop:FriendlyName="SUB_ID"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="9" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="LAST_NAME" msprop:design-time-name="4d1fc1a8-c1e4-43ac-9b84-819cf7295504" msprop:DbColumnName="LAST_NAME" msprop:FriendlyName="LAST_NAME" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="FIRST_NAME" msprop:design-time-name="884d4e7c-119b-42f7-82b6-1f39e55def1c" msprop:DbColumnName="FIRST_NAME" msprop:FriendlyName="FIRST_NAME"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="30" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="GENDER" msprop:design-time-name="dc482676-d8b5-41ee-a22e-cac241b788ae" msprop:DbColumnName="GENDER" msprop:FriendlyName="GENDER"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="1" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="BIRTH_DT" msprop:design-time-name="e16b88d2-6ba7-47a6-9095-394d01e39425" msprop:DbColumnName="BIRTH_DT" msprop:FriendlyName="BIRTH_DT" type="xs:dateTime" /> <xs:element name="SUBGRP_ID" msprop:design-time-name="dd4f8c04-2dcb-4fcc-a27d-3abf716e54af" msprop:DbColumnName="SUBGRP_ID" msprop:FriendlyName="SUBGRP_ID" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="4" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="GRP_ID" msprop:design-time-name="3ea55397-0e76-43dc-9037-3a2b48ba043d" msprop:DbColumnName="GRP_ID" msprop:FriendlyName="GRP_ID" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="8" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="EFF_DT" msprop:design-time-name="9a07b75a-ff80-4e38-9280-fb71684d5913" msprop:DbColumnName="EFF_DT" msprop:FriendlyName="EFF_DT" type="xs:dateTime" /> <xs:element name="TERM_DT" msprop:design-time-name="956a380f-c9dd-4f0d-ba86-282c1973a471" msprop:DbColumnName="TERM_DT" msprop:FriendlyName="TERM_DT" type="xs:dateTime" /> <xs:element name="ELIG_IND" msprop:design-time-name="8309338d-ad40-45d4-a125-de589ef02437" msprop:DbColumnName="ELIG_IND" msprop:FriendlyName="ELIG_IND"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="1" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//dbo_Group_2121507" /> <xs:field xpath="GROUP_ID" /> </xs:unique> <xs:unique name="dbo_SUBGRP_2121507_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//dbo_SUBGRP_2121507" /> <xs:field xpath="SUBGRP_SK" /> </xs:unique> <xs:unique name="dbo_SUBSCRIBER_2121507_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//dbo_SUBSCRIBER_2121507" /> <xs:field xpath="SUB_ID" /> </xs:unique> <xs:keyref name="FK__SUBGRP_21__GROUP__48CFD27E" refer="Constraint1" msdata:ConstraintOnly="true"> <xs:selector xpath=".//dbo_SUBGRP_2121507" /> <xs:field xpath="GROUP_ID" /> </xs:keyref> </xs:element> <xs:annotation> <xs:appinfo> <msdata:Relationship name="SUBGRP_2121507-SUBSCRIBER_2121507" msdata:parent="dbo_SUBGRP_2121507" msdata:child="dbo_SUBSCRIBER_2121507" msdata:parentkey="SUBGRP_ID" msdata:childkey="SUBGRP_ID" msprop:IsLogical="True" msprop:Description="" /> <msdata:Relationship name="SUBSCRIBER_2121507-Group_2121507" msdata:parent="dbo_Group_2121507" msdata:child="dbo_SUBSCRIBER_2121507" msdata:parentkey="GROUP_ID" msdata:childkey="GRP_ID" msprop:IsLogical="True" msprop:Description="" /> </xs:appinfo> </xs:annotation> </xs:schema> <Health_x0020_Care_x0020_System xmlns="" /> </Schema> </DataSourceView> </DataSourceViews> </Database>