<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hi all,</div><div class=""><br class=""></div><div class="">I'm trying to create a VirtualCube, combining two other Cubes in my schema.</div><div class="">However, it seems that the slicer axis on queries made against this VirtualCube</div><div class="">are being ignored.</div><div class=""><br class=""></div><div class="">This query returns the expected results:</div><div class=""><br class=""></div><div class=""> SELECT</div><div class=""> NON EMPTY {</div><div class=""> [Measures].[FOB],</div><div class=""> [Measures].[CIF]</div><div class=""> } ON 0,</div><div class=""> NON EMPTY [Date].[Year].Members ON 1</div><div class=""> FROM [exports_and_imports]</div><div class=""> </div><div class="">This one returns the same results as the previous one, which is incorrect:</div><div class=""><br class=""></div><div class=""> SELECT</div><div class=""> NON EMPTY {</div><div class=""> [Measures].[FOB],</div><div class=""> [Measures].[CIF]</div><div class=""> } ON 0,</div><div class=""> NON EMPTY [Date].[Year].members ON 1</div><div class=""> FROM [exports_and_imports]</div><div class=""> WHERE (</div><div class=""> [Geography].[Region Name]</div><div class=""> ) </div><div class=""><br class=""></div><div class="">Edited version of my schema:</div><div class=""><br class=""></div><div class=""> <Schema name="datachile"></div><div class=""> <Dimension name="Date" type="TimeDimension">...</Dimension></div><div class=""> </div><div class=""> <Dimension name="Geography">...</Dimension></div><div class=""> </div><div class=""> <Dimension name="Country">...</Dimension></div><div class=""> </div><div class=""> <Dimension name=“HS”>...</Dimension></div><div class=""> </div><div class=""> <Cube name="exports"></div><div class=""> <DimensionUsage name="Date" source="Date" foreignKey="date_id" /></div><div class=""> <DimensionUsage name="Destination Country" source="Country" foreignKey="country_dest_id" /></div><div class=""> <DimensionUsage name="Export Geography" source="Geography" foreignKey="exporter_comuna_id" /></div><div class=""> <DimensionUsage name="Export HS" source="HS" foreignKey="hs_level3" /></div><div class=""> </div><div class=""> <Measure name="FOB US" column="fob_us" aggregator="sum" /></div><div class=""> </Cube></div><div class=""> </div><div class=""> <Cube name="imports"></div><div class=""> <DimensionUsage name="Date" source="Date" foreignKey="date_id" /></div><div class=""> <DimensionUsage name="Origin Country" source="Country" foreignKey="country_origin_id" /></div><div class=""> <DimensionUsage name="Import Geography" source="Geography" foreignKey="importer_comuna_id" /></div><div class=""> <DimensionUsage name="Import HS" source="HS" foreignKey="hs_6digits" /></div><div class=""> </div><div class=""> <Measure name="CIF US" column="cif_us" aggregator="sum" /></div><div class=""> </Cube></div><div class=""> </div><div class=""> </div><div class=""> <VirtualCube name="exports_and_imports"></div><div class=""> <CubeUsages></div><div class=""> <CubeUsage cubeName="exports" ignoreUnrelatedDimensions="true" /></div><div class=""> <CubeUsage cubeName="imports" ignoreUnrelatedDimensions="true" /></div><div class=""> </CubeUsages></div><div class=""> </div><div class=""> <VirtualCubeDimension name="Date" /></div><div class=""> <VirtualCubeDimension name="Geography" /></div><div class=""> <VirtualCubeDimension name="HS" /></div><div class=""> </div><div class=""> <VirtualCubeMeasure cubeName="exports" name="[Measures].[FOB US]" /></div><div class=""> <VirtualCubeMeasure cubeName="imports" name="[Measures].[CIF US]" /></div><div class=""> </div><div class=""> <CalculatedMember name="FOB" dimension="Measures"></div><div class=""> <Formula>ValidMeasure([Measures].[FOB US])</Formula></div><div class=""> </CalculatedMember></div><div class=""> </div><div class=""> <CalculatedMember name="CIF" dimension="Measures"></div><div class=""> <Formula>ValidMeasure([Measures].[CIF US])</Formula></div><div class=""> </CalculatedMember></div><div class=""> </VirtualCube></div><div class=""> </Schema></div><div class=""> </div><div class="">Any hint will be appreciated.</div><div class=""><br class=""></div><div class="">Best,</div><div class=""><br class=""></div><div class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">--</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Manuel Aristarán</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://jazzido.com" class="">http://jazzido.com</a></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<br class=""></body></html>