<DataSources> <SqlDataSource Name="SQL Data Source 1" ComponentName="dashboardSqlDataSource1" DataProcessingMode="Client"> <Connection Name="localhost_HQR_Connection" ProviderKey="MSSqlServer"> <Parameters> <Parameter Name="server" Value="10.10.0.63" /> <Parameter Name="database" Value="HQR" /> <Parameter Name="useIntegratedSecurity" Value="False" /> <Parameter Name="read only" Value="1" /> <Parameter Name="generateConnectionHelper" Value="false" /> <Parameter Name="userid" Value="" /> <Parameter Name="password" Value="" /> </Parameters> </Connection> <Query Type="StoredProcQuery" Name="pdn_POSDashBoardKPI"> <Parameter Name="@Parity" Type="DevExpress.DataAccess.Expression">(System.Boolean)(?Parity)</Parameter> <Parameter Name="@FromDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@ToDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@Period" Type="DevExpress.DataAccess.Expression">(System.String)(?Period)</Parameter> <Parameter Name="@ComparePeriod" Type="DevExpress.DataAccess.Expression">(System.String)(?ComparePeriod)</Parameter> <ProcName>pdn.POSDashBoardKPI</ProcName> </Query> <Query Type="StoredProcQuery" Name="pdn_POSDashBoardPayments"> <Parameter Name="@Parity" Type="DevExpress.DataAccess.Expression">(System.Boolean)(?Parity)</Parameter> <Parameter Name="@FromDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@ToDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@Period" Type="DevExpress.DataAccess.Expression">(System.String)(?Period)</Parameter> <Parameter Name="@ComparePeriod" Type="DevExpress.DataAccess.Expression">(System.String)(?ComparePeriod)</Parameter> <ProcName>pdn.POSDashBoardPayments</ProcName> </Query> <Query Type="StoredProcQuery" Name="pdn_POSDashBoardSalesman"> <Parameter Name="@Parity" Type="DevExpress.DataAccess.Expression">(System.Boolean)(False)</Parameter> <Parameter Name="@FromDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@ToDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@Period" Type="DevExpress.DataAccess.Expression">(System.String)(?Period)</Parameter> <ProcName>pdn.POSDashBoardSalesman</ProcName> </Query> <Query Type="StoredProcQuery" Name="pdn_POSDashBoardProducts"> <Parameter Name="@Parity" Type="DevExpress.DataAccess.Expression">(System.Boolean)(?Parity)</Parameter> <Parameter Name="@FromDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@ToDate" Type="DevExpress.DataAccess.Expression">(System.DateTime)(NULL)</Parameter> <Parameter Name="@Period" Type="DevExpress.DataAccess.Expression">(System.String)(?Period)</Parameter> <Parameter Name="@ComparePeriod" Type="DevExpress.DataAccess.Expression">(System.String)(?ComparePeriod)</Parameter> <ProcName>pdn.POSDashBoardProducts</ProcName> </Query> <ResultSchema> <DataSet Name="SQL Data Source 1"> <View Name="pdn_POSDashBoardKPI"> <Field Name="Parity" Type="String" /> <Field Name="Period" Type="String" /> <Field Name="FromDate" Type="DateTime" /> <Field Name="ToDate" Type="DateTime" /> <Field Name="ComparePeriod" Type="String" /> <Field Name="FromDateLp" Type="DateTime" /> <Field Name="ToDateLp" Type="DateTime" /> <Field Name="ParityTime" Type="DateTime" /> <Field Name="SalesValue" Type="Decimal" /> <Field Name="SalesQuantity" Type="Decimal" /> <Field Name="TicketCount" Type="Int32" /> <Field Name="ReferenceCount" Type="Int32" /> <Field Name="ReturnValue" Type="Decimal" /> <Field Name="ReturnQuantity" Type="Decimal" /> <Field Name="ReturnTicketCount" Type="Int32" /> <Field Name="ReturnReferenceCount" Type="Int32" /> <Field Name="AveragePrice" Type="Decimal" /> <Field Name="AverageTicket" Type="Decimal" /> <Field Name="PiecesPerTicket" Type="Decimal" /> <Field Name="SalesValueIncrement" Type="Decimal" /> <Field Name="SalesQuantityIncrement" Type="Decimal" /> <Field Name="TicketCountIncrement" Type="Single" /> <Field Name="SalesValueLastPeriod" Type="Decimal" /> <Field Name="SalesQuantityLastPeriod" Type="Decimal" /> <Field Name="TicketCountLastPeriod" Type="Int32" /> <Field Name="ReferenceCountLastPeriod" Type="Int32" /> <Field Name="ReturnValueLastPeriod" Type="Decimal" /> <Field Name="ReturnQuantityLastPeriod" Type="Decimal" /> <Field Name="ReturnTicketCountLastPeriod" Type="Int32" /> <Field Name="ReturnReferenceCountLastPeriod" Type="Int32" /> <Field Name="AveragePriceLastPeriod" Type="Decimal" /> <Field Name="AverageTicketLastPeriod" Type="Decimal" /> <Field Name="PiecesPerTicketLastPeriod" Type="Decimal" /> <Field Name="CountIn" Type="Int32" /> <Field Name="CountInLastPeriod" Type="Int32" /> <Field Name="CR" Type="Single" /> <Field Name="CRLastPeriod" Type="Single" /> <Field Name="ContactCount" Type="Int32" /> <Field Name="ContactCountLastPeriod" Type="Int32" /> </View> <View Name="pdn_POSDashBoardPayments"> <Field Name="Period" Type="String" /> <Field Name="Payment" Type="String" /> <Field Name="Value" Type="Decimal" /> </View> <View Name="pdn_POSDashBoardSalesman"> <Field Name="Parity" Type="String" /> <Field Name="Period" Type="String" /> <Field Name="FromDate" Type="DateTime" /> <Field Name="ToDate" Type="DateTime" /> <Field Name="UserName" Type="String" /> <Field Name="SalesValue" Type="Decimal" /> <Field Name="SalesQuantity" Type="Decimal" /> <Field Name="TicketCount" Type="Int32" /> <Field Name="ReferenceCount" Type="Int32" /> <Field Name="ReturnValue" Type="Decimal" /> <Field Name="ReturnQuantity" Type="Decimal" /> <Field Name="ReturnTicketCount" Type="Int32" /> <Field Name="ReturnReferenceCount" Type="Int32" /> <Field Name="AveragePrice" Type="Decimal" /> <Field Name="AverageTicket" Type="Decimal" /> <Field Name="PiecesPerTicket" Type="Decimal" /> </View> <View Name="pdn_POSDashBoardProducts"> <Field Name="Parity" Type="String" /> <Field Name="Period" Type="String" /> <Field Name="FromDate" Type="DateTime" /> <Field Name="ToDate" Type="DateTime" /> <Field Name="FamilyCode" Type="String" /> <Field Name="SubfamilyCode" Type="String" /> <Field Name="ProductTypeCode" Type="String" /> <Field Name="Family" Type="String" /> <Field Name="Subfamily" Type="String" /> <Field Name="Type" Type="String" /> <Field Name="SalesValue" Type="Decimal" /> <Field Name="SalesQuantity" Type="Decimal" /> <Field Name="ReferenceCount" Type="Int32" /> <Field Name="ReturnValue" Type="Decimal" /> <Field Name="ReturnQuantity" Type="Decimal" /> <Field Name="ReturnReferenceCount" Type="Int32" /> <Field Name="AveragePrice" Type="Decimal" /> </View> </DataSet> </ResultSchema> <ConnectionOptions CloseConnection="true" /> </SqlDataSource> </DataSources> <Parameters> <Parameter Name="Period" Value=""> <StaticListLookUpSettings> <Values> <Value>Today</Value> <Value>This Week</Value> <Value>This Month</Value> <Value>This Year</Value> </Values> </StaticListLookUpSettings> </Parameter> <Parameter Name="ComparePeriod" Value=""> <StaticListLookUpSettings> <Values> <Value>Last Year</Value> <Value>Last Month</Value> <Value>Last Week</Value> </Values> </StaticListLookUpSettings> </Parameter> <Parameter Name="Parity" Type="System.Boolean" Value="true" /> </Parameters> <Items> <Card ComponentName="cardDashboardItem1" Name="Instant BI" ParentContainer="dashboardTabPage1" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardKPI"> <DataItems> <Measure DataMember="SalesValue" Name="Sales Value" DefaultId="DataItem0" /> <Measure DataMember="SalesValueLastPeriod" Name="LP Sales Value" DefaultId="DataItem1" /> <Measure DataMember="SalesQuantity" Name="Sales Quantity" DefaultId="DataItem2"> <NumericFormat FormatType="Number" /> </Measure> <Measure DataMember="SalesQuantityLastPeriod" DefaultId="DataItem3" /> <Measure DataMember="TicketCount" Name="Ticket Count" DefaultId="DataItem4" /> <Measure DataMember="TicketCountLastPeriod" DefaultId="DataItem5" /> <Measure DataMember="AveragePriceLastPeriod" DefaultId="DataItem7" /> <Measure DataMember="AveragePrice" DefaultId="DataItem6" /> <Measure DataMember="PiecesPerTicket" DefaultId="DataItem8"> <NumericFormat FormatType="Number" /> </Measure> <Measure DataMember="PiecesPerTicketLastPeriod" DefaultId="DataItem9" /> <Measure DataMember="AverageTicket" DefaultId="DataItem10" /> <Measure DataMember="AverageTicketLastPeriod" DefaultId="DataItem11" /> </DataItems> <Card Name="Sales Value vs Last Period"> <ActualValue DefaultId="DataItem0" /> <TargetValue DefaultId="DataItem1" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> <Card Name="Sales Quantity vs Last Period"> <ActualValue DefaultId="DataItem2" /> <TargetValue DefaultId="DataItem3" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> <Card Name="Ticket Count vs Last Period"> <ActualValue DefaultId="DataItem4" /> <TargetValue DefaultId="DataItem5" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> <Card Name="Average Ticket vs Last Period"> <ActualValue DefaultId="DataItem10" /> <TargetValue DefaultId="DataItem11" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> <Card Name="Average Price vs Last Period"> <ActualValue DefaultId="DataItem6" /> <TargetValue DefaultId="DataItem7" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> <Card Name="UPT vs Last Period"> <ActualValue DefaultId="DataItem8" /> <TargetValue DefaultId="DataItem9" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> <LayoutTemplate MinWidth="270" MaxWidth="270" Type="Centered"> <MainValue Visible="true" ValueType="Title" DimensionIndex="0" /> <SubValue Visible="true" ValueType="Subtitle" DimensionIndex="0" /> <BottomValue Visible="true" ValueType="ActualValue" DimensionIndex="0" /> <BottomSubValue1 Visible="true" ValueType="AbsoluteVariation" DimensionIndex="0" /> <BottomSubValue2 Visible="true" ValueType="PercentVariation" DimensionIndex="0" /> <DeltaIndicator Visible="true" /> <Sparkline Visible="true" /> </LayoutTemplate> </Card> </Card> <Grid ComponentName="gridDashboardItem1" Name="Period" ParentContainer="dashboardTabPage1" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardKPI"> <DataItems> <Dimension DataMember="FromDate" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem0" /> <Dimension DataMember="ToDate" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem2" /> <Dimension DataMember="FromDateLp" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem1" /> <Dimension DataMember="ComparePeriod" DefaultId="DataItem3" /> <Dimension DataMember="ToDateLp" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem4" /> <Dimension DataMember="Period" DefaultId="DataItem5" /> </DataItems> <GridColumns> <GridDimensionColumn> <Dimension DefaultId="DataItem5" /> </GridDimensionColumn> <GridDimensionColumn> <Dimension DefaultId="DataItem3" /> </GridDimensionColumn> <GridDimensionColumn Name="From Date"> <Dimension DefaultId="DataItem0" /> </GridDimensionColumn> <GridDimensionColumn Name="To Date"> <Dimension DefaultId="DataItem2" /> </GridDimensionColumn> <GridDimensionColumn Name="LP From Date "> <Dimension DefaultId="DataItem1" /> </GridDimensionColumn> <GridDimensionColumn Name="LP To Date"> <Dimension DefaultId="DataItem4" /> </GridDimensionColumn> </GridColumns> <GridOptions /> </Grid> <Gauge ComponentName="gaugeDashboardItem1" Name="Sales Value vs Last Period" ParentContainer="dashboardTabPage1" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardKPI" ViewType="CircularHalf" ShowGaugeCaptions="false"> <DataItems> <Measure DataMember="SalesValue" Name="Sales Value" DefaultId="DataItem0" /> <Measure DataMember="SalesValueLastPeriod" Name="LP Sales Value" DefaultId="DataItem1" /> <Measure DataMember="TicketCount" Name="Tickets" DefaultId="DataItem2" /> <Measure DataMember="TicketCountLastPeriod" DefaultId="DataItem3" /> <Measure DataMember="SalesQuantity" DefaultId="DataItem4" /> <Measure DataMember="SalesQuantityLastPeriod" DefaultId="DataItem5" /> </DataItems> <GaugeElement> <ActualValue DefaultId="DataItem0" /> <TargetValue DefaultId="DataItem1" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> </GaugeElement> <GaugeElement Name="Tickets vs LP Tickets"> <ActualValue DefaultId="DataItem2" /> <TargetValue DefaultId="DataItem3" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> </GaugeElement> <GaugeElement Name="Quantity vs LP Quantity"> <ActualValue DefaultId="DataItem4" /> <TargetValue DefaultId="DataItem5" /> <AbsoluteVariationNumericFormat /> <PercentVariationNumericFormat /> <PercentOfTargetNumericFormat /> </GaugeElement> </Gauge> <TabContainer ComponentName="tabContainerDashboardItem1" Name="Tab Container 1"> <Pages> <Page ComponentName="dashboardTabPage1" Name="Daily Instant BI" /> <Page ComponentName="dashboardTabPage2" Name="Payments BI" /> <Page ComponentName="dashboardTabPage3" Name="Salesman BI" /> <Page ComponentName="dashboardTabPage4" Name="Products BI" /> </Pages> </TabContainer> <Pie ComponentName="pieDashboardItem1" Name="Payments" ShowCaption="false" ParentContainer="dashboardTabPage2" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardPayments"> <DataItems> <Measure DataMember="Value" Name="Value" DefaultId="DataItem0" /> <Dimension DataMember="Payment" DefaultId="DataItem1" /> <Dimension DataMember="Period" DefaultId="DataItem2" /> </DataItems> <SeriesDimensions> <SeriesDimension DefaultId="DataItem2" /> </SeriesDimensions> <Arguments> <Argument DefaultId="DataItem1" /> </Arguments> <Values> <Value DefaultId="DataItem0" /> </Values> </Pie> <Pivot ComponentName="pivotDashboardItem1" Name="Payments " ParentContainer="dashboardTabPage2" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardPayments"> <DataItems> <Dimension DataMember="Payment" DefaultId="DataItem0" /> <Dimension DataMember="Period" SortOrder="Descending" DefaultId="DataItem1" /> <Measure DataMember="Value" Name="Value" DefaultId="DataItem2" /> </DataItems> <Columns> <Column DefaultId="DataItem1" /> </Columns> <Rows> <Row DefaultId="DataItem0" /> </Rows> <Values> <Value DefaultId="DataItem2" /> </Values> </Pivot> <Image ComponentName="imageDashboardItem2" Name="Image 1" ShowCaption="false" Url="C:\Users\PC-ABIAGI-HP\Desktop\PD\Primadonna.png" VerticalAlignment="Top" /> <Grid ComponentName="gridDashboardItem2" Name="Sales" ParentContainer="dashboardTabPage3" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardSalesman"> <DataItems> <Dimension DataMember="UserName" DefaultId="DataItem0" /> <Measure DataMember="SalesValue" DefaultId="DataItem1" /> <Measure DataMember="SalesQuantity" DefaultId="DataItem2"> <NumericFormat FormatType="Number" CustomFormatString="" /> </Measure> <Measure DataMember="TicketCount" DefaultId="DataItem3" /> <Measure DataMember="AverageTicket" DefaultId="DataItem4" /> <Measure DataMember="AveragePrice" DefaultId="DataItem5" /> <Measure DataMember="PiecesPerTicket" DefaultId="DataItem6"> <NumericFormat FormatType="Number" CustomFormatString="" /> </Measure> </DataItems> <FormatRules> <GridItemFormatRule Name="FormatRule 1" DataItem="DataItem1" DataItemApplyTo="DataItem1"> <FormatConditionGradientRangeBar ValueType="Percent"> <RangeSet> <Ranges> <RangeInfo> <Value Type="System.Double" Value="0" /> <BarStyleSettings PredefinedColor="GradientYellow" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="20" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="40" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="60" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="80" /> <BarStyleSettings PredefinedColor="GradientGreen" /> </RangeInfo> </Ranges> </RangeSet> <BarOptions /> </FormatConditionGradientRangeBar> </GridItemFormatRule> <GridItemFormatRule Name="FormatRule 2" DataItem="DataItem2" DataItemApplyTo="DataItem2"> <FormatConditionRangeGradient ValueType="Percent"> <RangeSet> <Ranges> <RangeInfo> <Value Type="System.Double" Value="0" /> <AppearanceSettings AppearanceType="GradientGreen" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="10" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="20" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="30" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="40" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="50" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="60" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="70" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="80" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="90" /> <AppearanceSettings AppearanceType="GradientTransparent" /> </RangeInfo> </Ranges> </RangeSet> </FormatConditionRangeGradient> </GridItemFormatRule> <GridItemFormatRule Name="FormatRule 3" DataItem="DataItem6" DataItemApplyTo="DataItem6"> <FormatConditionRangeSet ValueType="Percent"> <RangeSet> <Ranges> <RangeInfo> <Value Type="System.Double" Value="0" /> <IconSettings IconType="DirectionalRedDownArrow" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="50" /> <IconSettings IconType="DirectionalGreenArrowUp" /> </RangeInfo> </Ranges> </RangeSet> </FormatConditionRangeSet> </GridItemFormatRule> <GridItemFormatRule Name="FormatRule 4" DataItem="DataItem5" DataItemApplyTo="DataItem5"> <FormatConditionRangeSet ValueType="Percent"> <RangeSet> <Ranges> <RangeInfo> <Value Type="System.Double" Value="0" /> <IconSettings IconType="ShapeRedCircle" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="50" /> <IconSettings IconType="ShapeGreenCircle" /> </RangeInfo> </Ranges> </RangeSet> </FormatConditionRangeSet> </GridItemFormatRule> <GridItemFormatRule Name="FormatRule 5" DataItem="DataItem4" DataItemApplyTo="DataItem4"> <FormatConditionRangeSet ValueType="Percent"> <RangeSet> <Ranges> <RangeInfo> <Value Type="System.Double" Value="0" /> <IconSettings IconType="IndicatorRedCross" /> </RangeInfo> <RangeInfo> <Value Type="System.Double" Value="50" /> <IconSettings IconType="IndicatorGreenCheck" /> </RangeInfo> </Ranges> </RangeSet> </FormatConditionRangeSet> </GridItemFormatRule> <GridItemFormatRule Name="FormatRule 6" DataItem="DataItem3" DataItemApplyTo="DataItem3"> <FormatConditionTopBottom RankType="Number" Rank="1"> <AppearanceSettings AppearanceType="Green" /> </FormatConditionTopBottom> </GridItemFormatRule> </FormatRules> <GridColumns> <GridDimensionColumn Name="Salesman" Weight="66.1353032659409"> <Dimension DefaultId="DataItem0" /> </GridDimensionColumn> <GridMeasureColumn Name="Sales Value" Weight="82.465007776049774"> <Measure DefaultId="DataItem1" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Sales Quantity" Weight="64.502332814930014"> <Measure DefaultId="DataItem2" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Ticket Count" Weight="61.236391912908246"> <Measure DefaultId="DataItem3" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Average Ticket" Weight="90.6298600311042"> <Measure DefaultId="DataItem4" /> <Totals> <Total Type="Avg" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Average Price" Weight="87.363919129082433"> <Measure DefaultId="DataItem5" /> <Totals> <Total Type="Avg" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="UPT" Weight="72.667185069984441"> <Measure DefaultId="DataItem6" /> </GridMeasureColumn> </GridColumns> <GridOptions ColumnWidthMode="Manual" /> </Grid> <Pie ComponentName="pieDashboardItem2" Name="Pies 2" ParentContainer="dashboardTabPage3" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardSalesman"> <DataItems> <Dimension DataMember="UserName" DefaultId="DataItem0" /> <Measure DataMember="SalesValue" DefaultId="DataItem1" /> <Measure DataMember="ReturnValue" DefaultId="DataItem2" /> </DataItems> <Arguments> <Argument DefaultId="DataItem0" /> </Arguments> <Values> <Value DefaultId="DataItem1" /> <Value DefaultId="DataItem2" /> </Values> </Pie> <Grid ComponentName="gridDashboardItem3" Name="Returns" ParentContainer="dashboardTabPage3" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardSalesman"> <DataItems> <Dimension DataMember="UserName" DefaultId="DataItem0" /> <Measure DataMember="ReturnValue" DefaultId="DataItem1" /> <Measure DataMember="ReturnQuantity" DefaultId="DataItem2" /> <Measure DataMember="ReturnTicketCount" DefaultId="DataItem3" /> </DataItems> <GridColumns> <GridDimensionColumn Name="Salesman"> <Dimension DefaultId="DataItem0" /> </GridDimensionColumn> <GridMeasureColumn Name="Return Value"> <Measure DefaultId="DataItem1" /> </GridMeasureColumn> <GridMeasureColumn Name="Return Quantity"> <Measure DefaultId="DataItem2" /> </GridMeasureColumn> <GridMeasureColumn Name="Return Ticket Count"> <Measure DefaultId="DataItem3" /> </GridMeasureColumn> </GridColumns> <GridOptions /> </Grid> <Grid ComponentName="gridDashboardItem4" Name="Period" ShowCaption="false" ParentContainer="dashboardTabPage3" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardSalesman"> <DataItems> <Dimension DataMember="FromDate" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem0" /> <Dimension DataMember="Period" DefaultId="DataItem1" /> <Dimension DataMember="ToDate" DateTimeGroupInterval="DayMonthYear" DefaultId="DataItem2" /> </DataItems> <GridColumns> <GridDimensionColumn> <Dimension DefaultId="DataItem1" /> </GridDimensionColumn> <GridDimensionColumn> <Dimension DefaultId="DataItem0" /> </GridDimensionColumn> <GridDimensionColumn> <Dimension DefaultId="DataItem2" /> </GridDimensionColumn> </GridColumns> <GridOptions /> </Grid> <Grid ComponentName="gridDashboardItem5" Name="Sales Products List" ParentContainer="dashboardTabPage4" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardProducts"> <InteractivityOptions IsDrillDownEnabled="true" /> <DataItems> <Dimension DataMember="Type" DefaultId="DataItem2" /> <Measure DataMember="SalesValue" DefaultId="DataItem3" /> <Measure DataMember="SalesQuantity" DefaultId="DataItem4"> <NumericFormat FormatType="Number" CustomFormatString="" /> </Measure> <Dimension DataMember="Family" DefaultId="DataItem5" /> <Dimension DataMember="Subfamily" DefaultId="DataItem6" /> </DataItems> <GridColumns> <GridDimensionColumn Weight="147.68615946260505"> <Dimension DefaultId="DataItem5" /> </GridDimensionColumn> <GridDimensionColumn Weight="101.36532384938693"> <Dimension DefaultId="DataItem6" /> </GridDimensionColumn> <GridDimensionColumn Weight="79.6441830245183"> <Dimension DefaultId="DataItem2" /> </GridDimensionColumn> <GridMeasureColumn Name="Sales Value" Weight="51.8265414472994"> <Measure DefaultId="DataItem3" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Sales Quantity" Weight="43.6434033240416"> <Measure DefaultId="DataItem4" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> </GridColumns> <GridOptions ColumnWidthMode="Manual" /> </Grid> <Pie ComponentName="pieDashboardItem3" Name="Returns" ParentContainer="dashboardTabPage4" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardProducts"> <InteractivityOptions IsDrillDownEnabled="true" /> <DataItems> <Measure DataMember="ReturnValue" Name="Returns Value" DefaultId="DataItem2" /> <Measure DataMember="ReturnQuantity" Name="Return Quantity" DefaultId="DataItem3" /> <Dimension DataMember="SubfamilyCode" DefaultId="DataItem5" /> <Dimension DataMember="FamilyCode" DefaultId="DataItem4" /> <Dimension DataMember="Type" DefaultId="DataItem6" /> </DataItems> <Arguments> <Argument DefaultId="DataItem4" /> <Argument DefaultId="DataItem5" /> <Argument DefaultId="DataItem6" /> </Arguments> <Values> <Value DefaultId="DataItem2" /> <Value DefaultId="DataItem3" /> </Values> </Pie> <Pie ComponentName="pieDashboardItem4" Name="Sales" ParentContainer="dashboardTabPage4" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardProducts"> <InteractivityOptions IsDrillDownEnabled="true" /> <DataItems> <Measure DataMember="SalesValue" Name="Sales Value" DefaultId="DataItem0" /> <Measure DataMember="SalesQuantity" Name="Sales Quantity" DefaultId="DataItem1" /> <Dimension DataMember="SubfamilyCode" DefaultId="DataItem5" /> <Dimension DataMember="FamilyCode" DefaultId="DataItem4" /> <Dimension DataMember="Type" DefaultId="DataItem6" /> </DataItems> <Arguments> <Argument DefaultId="DataItem4" /> <Argument DefaultId="DataItem5" /> <Argument DefaultId="DataItem6" /> </Arguments> <Values> <Value DefaultId="DataItem0" /> <Value DefaultId="DataItem1" /> </Values> </Pie> <Grid ComponentName="gridDashboardItem6" Name="Returns Products List" ParentContainer="dashboardTabPage4" DataSource="dashboardSqlDataSource1" DataMember="pdn_POSDashBoardProducts"> <InteractivityOptions IsDrillDownEnabled="true" /> <DataItems> <Dimension DataMember="Subfamily" DefaultId="DataItem0" /> <Dimension DataMember="Type" DefaultId="DataItem2" /> <Measure DataMember="ReturnQuantity" DefaultId="DataItem4" /> <Measure DataMember="ReturnValue" DefaultId="DataItem3" /> <Dimension DataMember="Family" DefaultId="DataItem5" /> </DataItems> <GridColumns> <GridDimensionColumn Weight="135.57692307692307"> <Dimension DefaultId="DataItem5" /> </GridDimensionColumn> <GridDimensionColumn> <Dimension DefaultId="DataItem0" /> </GridDimensionColumn> <GridDimensionColumn> <Dimension DefaultId="DataItem2" /> </GridDimensionColumn> <GridMeasureColumn Name="Return Value" Weight="42.908653846153847"> <Measure DefaultId="DataItem3" /> <Totals> <Total Type="Sum" /> </Totals> </GridMeasureColumn> <GridMeasureColumn Name="Return Quantity" Weight="46.51442307692308"> <Measure DefaultId="DataItem4" /> <Totals> <Total Type="Auto" /> </Totals> </GridMeasureColumn> </GridColumns> <GridOptions ColumnWidthMode="Manual" /> </Grid> </Items> <LayoutTree> <LayoutGroup Weight="100"> <LayoutTabContainer DashboardItem="tabContainerDashboardItem1" Weight="85.46052631578948"> <LayoutTabPage DashboardItem="dashboardTabPage1" Weight="100"> <LayoutGroup Orientation="Vertical" Weight="53.929961089494164"> <LayoutItem DashboardItem="gridDashboardItem1" Weight="11.223203026481714" /> <LayoutItem DashboardItem="cardDashboardItem1" Weight="88.776796973518287" /> </LayoutGroup> <LayoutItem DashboardItem="gaugeDashboardItem1" Weight="46.070038910505836" /> </LayoutTabPage> <LayoutTabPage DashboardItem="dashboardTabPage2" Weight="100"> <LayoutItem DashboardItem="pieDashboardItem1" Weight="62.568093385214006" /> <LayoutItem DashboardItem="pivotDashboardItem1" Weight="37.431906614785994" /> </LayoutTabPage> <LayoutTabPage DashboardItem="dashboardTabPage3" Weight="100"> <LayoutGroup Orientation="Vertical" Weight="50.350194552529182"> <LayoutItem DashboardItem="gridDashboardItem4" Weight="11.223203026481714" /> <LayoutItem DashboardItem="gridDashboardItem2" Weight="44.388398486759144" /> <LayoutItem DashboardItem="gridDashboardItem3" Weight="44.388398486759144" /> </LayoutGroup> <LayoutItem DashboardItem="pieDashboardItem2" Weight="49.649805447470818" /> </LayoutTabPage> <LayoutTabPage DashboardItem="dashboardTabPage4" Weight="100"> <LayoutGroup Orientation="Vertical" Weight="46.7704280155642"> <LayoutItem DashboardItem="gridDashboardItem5" Weight="49.306431273644385" /> <LayoutItem DashboardItem="gridDashboardItem6" Weight="50.693568726355615" /> </LayoutGroup> <LayoutGroup Orientation="Vertical" Weight="53.2295719844358"> <LayoutItem DashboardItem="pieDashboardItem4" Weight="44.136191677175283" /> <LayoutItem DashboardItem="pieDashboardItem3" Weight="55.863808322824717" /> </LayoutGroup> </LayoutTabPage> </LayoutTabContainer> <LayoutItem DashboardItem="imageDashboardItem2" Weight="14.539473684210526" /> </LayoutGroup> </LayoutTree> </Dashboard>