All pastes #919036 Raw Edit

Anonymous

public text v1 · immutable
#919036 ·published 2008-02-26 15:28 UTC
rendered paste body
<CalculatedMember name="TargetCF" dimension="Measures">
      <Formula>Iif(CoverageType.CurrentMember IS [CoverageType].[CARRETERA] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Centro], [Measures].[ValidCapex]/124, 
    Iif(CoverageType.CurrentMember IS [CoverageType].[CARRETERA] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Noroccidente], [Measures].[ValidCapex]/125.7,
    Iif(CoverageType.CurrentMember IS [CoverageType].[CARRETERA] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Costa], [Measures].[ValidCapex]/198.9,
    Iif(CoverageType.CurrentMember IS [CoverageType].[CARRETERA] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Suroccidente], [Measures].[ValidCapex]/337.1,
    Iif(CoverageType.CurrentMember IS [CoverageType].[CARRETERA] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Oriente], [Measures].[ValidCapex]/270.5,
    Iif (CoverageType.CurrentMember IS [CoverageType].[CIUDAD] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Centro], [Measures].[ValidCapex]/15.1,
    Iif (CoverageType.CurrentMember IS [CoverageType].[CIUDAD] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Noroccidente], [Measures].[ValidCapex]/12,
    Iif (CoverageType.CurrentMember IS [CoverageType].[CIUDAD] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Costa],[Measures].[ValidCapex]/23.4,
    Iif (CoverageType.CurrentMember IS [CoverageType].[CIUDAD] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Suroccidente],[Measures].[ValidCapex]/28.2,
    Iif (CoverageType.CurrentMember IS [CoverageType].[CIUDAD] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Oriente],[Measures].[ValidCapex]/23.3,
    Iif (CoverageType.CurrentMember IS [CoverageType].[MUNICIPIO] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Centro],[Measures].[ValidCapex]/137,
    Iif (CoverageType.CurrentMember IS [CoverageType].[MUNICIPIO] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Noroccidente],[Measures].[ValidCapex]/117.4,
    Iif (CoverageType.CurrentMember IS [CoverageType].[MUNICIPIO] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Costa],[Measures].[ValidCapex]/76.7,
    Iif (CoverageType.CurrentMember IS [CoverageType].[MUNICIPIO] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Suroccidente],[Measures].[ValidCapex]/211.2,
    Iif (CoverageType.CurrentMember IS [CoverageType].[MUNICIPIO] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Oriente],[Measures].[ValidCapex]/177.7,
    Iif (CoverageType.CurrentMember IS [CoverageType].[RURAL] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Centro], [Measures].[ValidCapex]/301.3,
    Iif (CoverageType.CurrentMember IS [CoverageType].[RURAL] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Noroccidente],[Measures].[ValidCapex]/111.2,
    Iif (CoverageType.CurrentMember IS [CoverageType].[RURAL] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Costa],[Measures].[ValidCapex]/249.1,
    Iif (CoverageType.CurrentMember IS [CoverageType].[RURAL] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Suroccidente],[Measures].[ValidCapex]/175.5,
    Iif (CoverageType.CurrentMember IS [CoverageType].[RURAL] AND ANCESTOR([RadioElement].CurrentMember,[RadioElement].[Region]) IS [RadioElement].[Oriente],[Measures].[ValidCapex]/173.6,0) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) )</Formula>
    </CalculatedMember>
    <CalculatedMember name="TargetUsers" dimension="Measures">
      <Formula>Iif([Measures].[TargetCF]-[Measures].[Cash_Flow]>0,([Measures].[TargetCF]-[Measures].[Cash_Flow])/([Measures].[Mou]*[Measures].[CashPerMin]),0)</Formula>
      <CalculatedMemberProperty name="FORMAT_STRING" value="########"/>
</CalculatedMember>