<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="">&nbsp; &nbsp; SELECT</div><div class="">&nbsp; &nbsp; &nbsp; NON EMPTY {</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; [Measures].[FOB],</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; [Measures].[CIF]</div><div class="">&nbsp; &nbsp; &nbsp; } ON 0,</div><div class="">&nbsp; &nbsp; &nbsp; NON EMPTY [Date].[Year].Members ON 1</div><div class="">&nbsp; &nbsp; FROM [exports_and_imports]</div><div class="">&nbsp; &nbsp;</div><div class="">This one returns the same results as the previous one, which is incorrect:</div><div class=""><br class=""></div><div class="">&nbsp; &nbsp; SELECT</div><div class="">&nbsp; &nbsp; &nbsp; NON EMPTY {</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; [Measures].[FOB],</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; [Measures].[CIF]</div><div class="">&nbsp; &nbsp; &nbsp; } ON 0,</div><div class="">&nbsp; &nbsp; &nbsp; NON EMPTY [Date].[Year].members ON 1</div><div class="">&nbsp; &nbsp; FROM [exports_and_imports]</div><div class="">&nbsp; &nbsp; WHERE (</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Geography].[Region Name]</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;</div><div class=""><br class=""></div><div class="">Edited version of my schema:</div><div class=""><br class=""></div><div class="">&nbsp; &nbsp; &lt;Schema name="datachile"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Dimension name="Date" type="TimeDimension"&gt;...&lt;/Dimension&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Dimension name="Geography"&gt;...&lt;/Dimension&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Dimension name="Country"&gt;...&lt;/Dimension&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Dimension name=“HS”&gt;...&lt;/Dimension&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Cube name="exports"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Date" source="Date" foreignKey="date_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Destination Country" source="Country" foreignKey="country_dest_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Export Geography" source="Geography" foreignKey="exporter_comuna_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Export HS" source="HS" foreignKey="hs_level3" /&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;Measure name="FOB US" column="fob_us" aggregator="sum" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;/Cube&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;Cube name="imports"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Date" source="Date" foreignKey="date_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Origin Country" source="Country" foreignKey="country_origin_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Import Geography" source="Geography" foreignKey="importer_comuna_id" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;DimensionUsage name="Import HS" source="HS" foreignKey="hs_6digits" /&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;Measure name="CIF US" column="cif_us" aggregator="sum" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;/Cube&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;VirtualCube name="exports_and_imports"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;CubeUsages&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;CubeUsage cubeName="exports" ignoreUnrelatedDimensions="true" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;CubeUsage cubeName="imports" ignoreUnrelatedDimensions="true" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/CubeUsages&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;VirtualCubeDimension name="Date" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;VirtualCubeDimension name="Geography" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;VirtualCubeDimension name="HS" /&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;VirtualCubeMeasure cubeName="exports" name="[Measures].[FOB US]" /&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;VirtualCubeMeasure cubeName="imports" name="[Measures].[CIF US]" &nbsp;/&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;CalculatedMember name="FOB" dimension="Measures"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Formula&gt;ValidMeasure([Measures].[FOB US])&lt;/Formula&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/CalculatedMember&gt;</div><div class="">&nbsp; &nbsp;&nbsp;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;CalculatedMember name="CIF" dimension="Measures"&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Formula&gt;ValidMeasure([Measures].[CIF US])&lt;/Formula&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/CalculatedMember&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &lt;/VirtualCube&gt;</div><div class="">&nbsp; &nbsp; &lt;/Schema&gt;</div><div class="">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</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>