rendered paste body<?xml version="1.0"?><Schema name="Payback"><!-- Shared dimensions --> <Dimension name="RadioElement"> <Hierarchy hasAll="true" primaryKey="id"> <Table name="bus_sector"/> <Level name="Region" column="region" /> <Level name="Zone" column="zone" hideMemberIf="IfBlankName" /> <Level name="Territory" column="territory" hideMemberIf="IfBlankName" /> <Level name="Plotter" column="tipo_cobertura" hideMemberIf="IfBlankName" /> <Level name="Site" column="site_code" > <NameExpression> <SQL dialect="mysql"> CONCAT(`bus_sector`.`site_code`, ' ', LEFT(`bus_sector`.`site_name`,15)) </SQL> </NameExpression> </Level> <Level name="Sector" column="sector_number"> <Property name="Rural/Urbana" column="city_municipality" /> <Property name="Air_date" column="on_air" /> </Level> </Hierarchy> </Dimension> <Dimension name="Responsible"> <Hierarchy hasAll="true" primaryKey="id"> <Table name="bus_responsible"/> <Level name="Name" column="name" /> </Hierarchy> </Dimension> <Dimension name="Time" type="TimeDimension"> <Hierarchy hasAll="true" primaryKey="id"> <Table name="bus_date"/> <Level name="Year" column="x_year" type="Numeric" uniqueMembers="true" levelType="TimeYears"/> <Level name="Quarter" column="quarter" uniqueMembers="false" levelType="TimeQuarters"/> <Level name="Month" column="month_of_year" uniqueMembers="false" type="Numeric" levelType="TimeMonths"/> <Level name="Day" column="day_of_month" uniqueMembers="false" type="Numeric" levelType="TimeDays"/> </Hierarchy> </Dimension><!-- pyb_mss_capex --><Cube name="Capex" defaultMeasure="capex"> <Table name="pyb_mss_capex"> </Table> <DimensionUsage name="Time" source="Time" foreignKey="date_key"/> <DimensionUsage name="RadioElement" source="RadioElement" foreignKey="cid_key"/> <Measure name="Capex" column="capex" aggregator="sum" formatString="US$#,##0.00"/> <CalculatedMember name="AggCapex" dimension="Measures"> <Formula>Sum(PeriodsToDate([Time].[All Times], [Time].CurrentMember), [Measures].[Capex])</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="US$#,##0.00" /> </CalculatedMember></Cube><!-- Bts --><Cube name="Bts" defaultMeasure="min_mocE"> <Table name="pyb_mss_cell"> </Table> <DimensionUsage name="Time" source="Time" foreignKey="date_key"/> <DimensionUsage name="RadioElement" source="RadioElement" foreignKey="cid_key"/> <!--<DimensionUsage name="Responsible" source="Responsible" foreignKey="respoym_key"/>--> <Dimension name="ResponsibleOpt" foreignKey="respopt_key" usagePrefix="opt"> <Hierarchy hasAll="true" primaryKey="id"> <Table name="bus_responsibleopt"/> <Level name="Name" column="name" /> </Hierarchy> </Dimension> <Measure name="Cost" column="costo" aggregator="sum" formatString="US$#,##0"/> <Measure name="Revenue" column="revenue" aggregator="sum" formatString="US$#,##0"/> <Measure name="Min_moc" column="min_mocE" aggregator="sum" formatString="Standard"/> <Measure name="Min_mocTigo" column="min_mocE_tigo" aggregator="sum" formatString="Standard"/> <Measure name="Min_mocComcel" column="min_mocE_comcel" aggregator="sum" formatString="Standard"/> <Measure name="Min_mocMovistar" column="min_mocE_movistar" aggregator="sum" formatString="Standard"/> <Measure name="Min_mocFijo" column="min_mocE_Fijo" aggregator="sum" formatString="Standard"/> <Measure name="Min_mocLdi" column="min_mocE_Ldi" aggregator="sum" formatString="Standard"/> <Measure name="Min_mtc" column="min_mtc" aggregator="sum" formatString="Standard"/> <Measure name="Min_mtcTigo" column="min_mtc_tigo" aggregator="sum" formatString="Standard"/> <Measure name="Min_mtcComcel" column="min_mtc_comcel" aggregator="sum" formatString="Standard"/> <Measure name="Min_mtcMovistar" column="min_mtc_movistar" aggregator="sum" formatString="Standard"/> <Measure name="Min_mtcFijoLdi" column="min_mtc_fijo_ldi" aggregator="sum" formatString="Standard"/> <Measure name="Qt_mocSMS" column="qt_mocSMS" aggregator="sum" formatString="Standard"/> <Measure name="Qt_mtcSMS" column="qt_mtcSMS" aggregator="sum" formatString="Standard"/> <CalculatedMember name="Effective_minutes" dimension="Measures"> <Formula>[Measures].[Min_moc] + [Measures].[Min_mtc] - [Measures].[Min_mtcTigo]</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="Standard" /> </CalculatedMember> <CalculatedMember name="Gross_Margin" dimension="Measures"> <Formula>[Measures].[Revenue] - [Measures].[Cost]</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="US$#,##0"/> </CalculatedMember> <CalculatedMember name="Ebitda" dimension="Measures"> <Formula>[Measures].[Gross_Margin] - ([Measures].[Revenue]*.242) - ([Measures].[Revenue]*.083)</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="US$#,##0"/> </CalculatedMember> <CalculatedMember name="Cash_Flow" dimension="Measures"> <Formula>[Measures].[Ebitda] - ([Measures].[Ebitda]*0.022)</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="US$#,##0"/> </CalculatedMember></Cube><VirtualCube name="Payback" defaultMeasure="Payback"> <VirtualCubeDimension cubeName="Bts" name="RadioElement"/> <VirtualCubeDimension cubeName="Bts" name="Time"/> <VirtualCubeDimension cubeName="Capex" name="RadioElement"/> <VirtualCubeDimension cubeName="Capex" name="Time"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Cost]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Revenue]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_moc]" /> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mtc]" /> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mocTigo]" /> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mocComcel]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mocMovistar]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mocFijo]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Min_mocLdi]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Gross_Margin]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Ebitda]"/> <VirtualCubeMeasure cubeName="Bts" name="[Measures].[Cash_Flow]"/> <VirtualCubeMeasure cubeName="Capex" name="[Measures].[AggCapex]" visible="false"/><CalculatedMember name="ValidCapex" dimension="Measures"><Formula>[Measures].[AggCapex]</Formula></CalculatedMember> <CalculatedMember name="Payback" dimension="Measures"> <Formula>IIf([Measures].[Cash_Flow] IS EMPTY,NULL,[Measures].[ValidCapex] / [Measures].[Cash_Flow])</Formula> <CalculatedMemberProperty name="FORMAT_STRING" value="###.#"/> </CalculatedMember></VirtualCube></Schema>