<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/SIG/Site.Master" CodeBehind="CuboPronosticoComparativo.aspx.vb" Inherits="SGHweb.CuboPronosticoComparativo" %>
<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid" tagprefix="dx" %>
<%@ Register assembly="DevExpress.XtraCharts.v13.1.Web, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts.Web" tagprefix="dxchartsui" %>
<%@ Register assembly="DevExpress.XtraCharts.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.XtraCharts" tagprefix="cc1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">


<div style="background-image: url(images/ImagenSuperior.JPG); width: 100%; height: 55px">
        <br />
        &nbsp; &nbsp; &nbsp; &nbsp;
        <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Times New Roman"
            Font-Size="16pt" Text=" Pronostico Comparativo :: CUBO  ">
        </asp:Label>&nbsp;
     </div>
     <br />
    <div>
        <%--<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>--%>
        
        <center>
        <asp:DropDownList ID="listExportFormat" runat="server">
            <asp:ListItem Value="0">Pdf</asp:ListItem>
            <asp:ListItem Value="1">Excel</asp:ListItem>
            <%--<asp:ListItem Value="2">Mht</asp:ListItem>
            <asp:ListItem Value="3">Rtf</asp:ListItem>
            <asp:ListItem Value="4">Text</asp:ListItem>
            <asp:ListItem Value="5">Html</asp:ListItem>--%>
        </asp:DropDownList>
        <br />
        <asp:Button ID="buttonSaveAs" runat="server" Text="Exportar" 
                    ToolTip="Exportar y Guardar" Width="77px" />
        <asp:Button ID="buttonOpen" runat="server" Text="Abrir" 
                    ToolTip="Exportar y Abrir" Width="77px"  />
        <br />
        <dx:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" ClientIDMode="AutoID" 
            EnableCallBacks="false"
            OLAPConnectionString="provider=MSOLAP;data source=http://192.168.1.5/olap/msmdpump.dll ;initial catalog=Cubo_Reporte_Pronostico_Comparativo;cube name=Shiol Datos 03" 
            Theme="Aqua">
            <Fields>
                <dx:PivotGridField ID="fieldCanal1" AreaIndex="0" 
                    FieldName="[CANALES].[Canal].[Canal]">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldRazonSocial1" AreaIndex="1" 
                    FieldName="[Empresas].[Razon Social].[Razon Social]">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldAo1" Area="ColumnArea" AreaIndex="0" 
                    FieldName="[Fecha Cubo].[Jerarquía].[Año]" GroupIndex="0" InnerGroupIndex="0">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldMes1" Area="ColumnArea" AreaIndex="1" 
                    FieldName="[Fecha Cubo].[Jerarquía].[Mes]" GroupIndex="0" InnerGroupIndex="1">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldDia1" Area="ColumnArea" AreaIndex="2" 
                    FieldName="[Fecha Cubo].[Jerarquía].[Dia]" GroupIndex="0" InnerGroupIndex="2">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldTipo1" Area="RowArea" AreaIndex="0" 
                    FieldName="[Productos].[Jerarquía].[Tipo]" GroupIndex="1" InnerGroupIndex="0">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldFamilia2" Area="RowArea" AreaIndex="1" 
                    FieldName="[Productos].[Jerarquía].[Familia]" GroupIndex="1" 
                    InnerGroupIndex="1">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldProducto1" Area="RowArea" AreaIndex="2" 
                    FieldName="[Productos].[Jerarquía].[Producto]" GroupIndex="1" 
                    InnerGroupIndex="2">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldSegmento1" AreaIndex="2" 
                    FieldName="[Segmentos].[Segmento].[Segmento]">
                </dx:PivotGridField>
                <dx:PivotGridField ID="fieldRECUENTO1" Area="DataArea" AreaIndex="0" 
                    DisplayFolder="VC Recuento Reserva Cubo" FieldName="[Measures].[RECUENTO]">
                </dx:PivotGridField>
            </Fields>
            <OptionsChartDataSource DataProvideMode="UseCustomSettings"/>
            <Groups>
                <dx:PivotGridWebGroup Hierarchy="[Fecha Cubo].[Jerarquía]" 
                    ShowNewValues="True" />
                <dx:PivotGridWebGroup Hierarchy="[Productos].[Jerarquía]" 
                    ShowNewValues="True" />
            </Groups>
        </dx:ASPxPivotGrid>

        <dx:ASPxPivotGridExporter ID="ASPxPivotGridExporter1" runat="server">
        </dx:ASPxPivotGridExporter>
        <br />
        <dxchartsui:WebChartControl ID="WebChartControl1" runat="server" 
            DataSourceID="ASPxPivotGrid1" Height="500px" 
            SideBySideEqualBarWidth="True" Width="800px" CrosshairEnabled="True">
            <diagramserializable>
                <cc1:XYDiagram>
                    <axisx title-text="[Productos].[Jerarquía].[Tipo] [Productos].[Jerarquía].[Familia] [Productos].[Jerarquía].[Producto]" 
                        visibleinpanesserializable="-1"><range sidemarginsenabled="True" 
                        alwaysshowzerolevel="True" /></axisx>
                    <axisy title-text="[Measures].[RECUENTO]" 
                        visibleinpanesserializable="-1"><range sidemarginsenabled="True" 
                        alwaysshowzerolevel="True" /></axisy>
                </cc1:XYDiagram>
            </diagramserializable>
            <FillStyle>
                <OptionsSerializable>
                    <cc1:SolidFillOptions></cc1:SolidFillOptions>
                </OptionsSerializable>
            </FillStyle>
            <legend maxhorizontalpercentage="30"></legend>

            <SeriesTemplate argumentdatamember="Arguments" argumentscaletype="Qualitative" 
                valuedatamembersserializable="Values">
                <ViewSerializable>
                    <cc1:SideBySideBarSeriesView></cc1:SideBySideBarSeriesView>
                </ViewSerializable>
                <LabelSerializable>
                    <cc1:SideBySideBarSeriesLabel LineVisible="True">
                        <FillStyle>
                            <OptionsSerializable>
                                <cc1:SolidFillOptions></cc1:SolidFillOptions>
                            </OptionsSerializable>
                        </FillStyle>
                        <PointOptionsSerializable>
                            <cc1:PointOptions></cc1:PointOptions>
                        </PointOptionsSerializable>
                    </cc1:SideBySideBarSeriesLabel>
                </LabelSerializable>
                <LegendPointOptionsSerializable>
                    <cc1:PointOptions></cc1:PointOptions>
                </LegendPointOptionsSerializable>
            </SeriesTemplate>

            <CrosshairOptions>
                <CommonLabelPositionSerializable>
                    <cc1:CrosshairMousePosition></cc1:CrosshairMousePosition>
                </CommonLabelPositionSerializable>
            </CrosshairOptions>

            <ToolTipOptions>
                <ToolTipPositionSerializable>
                    <cc1:ToolTipMousePosition></cc1:ToolTipMousePosition>
                </ToolTipPositionSerializable>
            </ToolTipOptions>
        </dxchartsui:WebChartControl>

        </center>
        <br />
        <br />
    </div>


</asp:Content>
