<%@ Page Title="" Language="VB" MasterPageFile="~/SIG/Site.master" AutoEventWireup="false" Inherits="SGHweb.SIG_pruebaCUBO" Codebehind="pruebaCUBO.aspx.vb" %>

<%@ 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.Web.ASPxPivotGrid.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid.Export" 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 />
        <br />
        &nbsp; &nbsp; &nbsp; &nbsp;
        <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Times New Roman"
            Font-Size="16pt" Text=" PUNTOS DE VENTAS :: CUBE ">
        </asp:Label>&nbsp;
     </div>
     <br />
<center>
    <table>
	    <tr>
		    <td>
			    <strong>Exportar a:</strong>
		    </td>
		    <td>
                <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>
		    </td>
		    <td>
                <asp:Button ID="buttonSaveAs" runat="server" Text="Exportar" 
                    ToolTip="Exportar y Guardar" Width="77px" />
		    </td>
		    <td>
			    <asp:Button ID="buttonOpen" runat="server" Text="Abrir" 
                    ToolTip="Exportar y Abrir" Width="77px"  />
		    </td>
	    </tr>
        <tr>
            <td colspan="4">
                <br />
                
            </td>
        </tr>
    </table>
<dx:ASPxPivotGrid ID="ASPxPivotGrid1" runat="server" ClientIDMode="AutoID" EnableCallBacks="false" 
        OLAPConnectionString="provider=MSOLAP;data source=SERVERSGH;initial catalog=ProyectoCubo;cube name=VOD_shiolDatos">
                    <Fields>
                        <dx:PivotGridField ID="fieldFacturables1" AreaIndex="0" 
                            FieldName="[Cuentas Corrientes].[Facturables].[Facturables]">
                        </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="fieldSemestre1" Area="ColumnArea" AreaIndex="1" FieldName="[Fecha Cubo].[Jerarquía].[Semestre]" 
                            GroupIndex="0" InnerGroupIndex="1">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldTrimestre1" Area="ColumnArea" AreaIndex="2" FieldName="[Fecha Cubo].[Jerarquía].[Trimestre]" 
                            GroupIndex="0" InnerGroupIndex="2">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldMes1" Area="ColumnArea" AreaIndex="3" 
                            FieldName="[Fecha Cubo].[Jerarquía].[Mes]" GroupIndex="0" 
                            InnerGroupIndex="3">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldDia1" Area="ColumnArea" AreaIndex="4" 
                            FieldName="[Fecha Cubo].[Jerarquía].[Dia]" GroupIndex="0" 
                            InnerGroupIndex="4">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldTipodeMoneda1" AreaIndex="1" 
                            FieldName="[Monedas].[Tipo de Moneda].[Tipo de Moneda]">
                        </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="fieldPuntodeVenta1" AreaIndex="2" 
                            FieldName="[Puntosventa].[Punto de Venta].[Punto de Venta]">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldCantidad1" Area="DataArea" AreaIndex="0" 
                            DisplayFolder="Cuentas Corrientes" FieldName="[Measures].[Cantidad]">
                        </dx:PivotGridField>
                        <dx:PivotGridField ID="fieldPrecioUnitario1" Area="DataArea" AreaIndex="1" 
                            DisplayFolder="Cuentas Corrientes" FieldName="[Measures].[Precio Unitario]">
                        </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>
                <br />
<dx:ASPxPivotGridExporter ID="ASPxPivotGridExporter1" runat="server">
</dx:ASPxPivotGridExporter>
    <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].[Cantidad] [Measures].[Precio Unitario]" 
                    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>
    <br />
    <br />
    <br />
</center>
</asp:Content>

