<p dir="ltr">Is Region Name a member or level? You need a FQMN in the slicer.</p>
<div class="gmail_extra"><br><div class="gmail_quote">On Nov 1, 2016 5:47 PM, "Manuel Aristarán" <<a href="mailto:manuel@jazzido.com">manuel@jazzido.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>Hi all,</div><div><br></div><div>I'm trying to create a VirtualCube, combining two other Cubes in my schema.</div><div>However, it seems that the slicer axis on queries made against this VirtualCube</div><div>are being ignored.</div><div><br></div><div>This query returns the expected results:</div><div><br></div><div> SELECT</div><div> NON EMPTY {</div><div> [Measures].[FOB],</div><div> [Measures].[CIF]</div><div> } ON 0,</div><div> NON EMPTY [Date].[Year].Members ON 1</div><div> FROM [exports_and_imports]</div><div> </div><div>This one returns the same results as the previous one, which is incorrect:</div><div><br></div><div> SELECT</div><div> NON EMPTY {</div><div> [Measures].[FOB],</div><div> [Measures].[CIF]</div><div> } ON 0,</div><div> NON EMPTY [Date].[Year].members ON 1</div><div> FROM [exports_and_imports]</div><div> WHERE (</div><div> [Geography].[Region Name]</div><div> ) </div><div><br></div><div>Edited version of my schema:</div><div><br></div><div> <Schema name="datachile"></div><div> <Dimension name="Date" type="TimeDimension">...</<wbr>Dimension></div><div> </div><div> <Dimension name="Geography">...</<wbr>Dimension></div><div> </div><div> <Dimension name="Country">...</Dimension></div><div> </div><div> <Dimension name=“HS”>...</Dimension></div><div> </div><div> <Cube name="exports"></div><div> <DimensionUsage name="Date" source="Date" foreignKey="date_id" /></div><div> <DimensionUsage name="Destination Country" source="Country" foreignKey="country_dest_id" /></div><div> <DimensionUsage name="Export Geography" source="Geography" foreignKey="exporter_comuna_<wbr>id" /></div><div> <DimensionUsage name="Export HS" source="HS" foreignKey="hs_level3" /></div><div> </div><div> <Measure name="FOB US" column="fob_us" aggregator="sum" /></div><div> </Cube></div><div> </div><div> <Cube name="imports"></div><div> <DimensionUsage name="Date" source="Date" foreignKey="date_id" /></div><div> <DimensionUsage name="Origin Country" source="Country" foreignKey="country_origin_id" /></div><div> <DimensionUsage name="Import Geography" source="Geography" foreignKey="importer_comuna_<wbr>id" /></div><div> <DimensionUsage name="Import HS" source="HS" foreignKey="hs_6digits" /></div><div> </div><div> <Measure name="CIF US" column="cif_us" aggregator="sum" /></div><div> </Cube></div><div> </div><div> </div><div> <VirtualCube name="exports_and_imports"></div><div> <CubeUsages></div><div> <CubeUsage cubeName="exports" ignoreUnrelatedDimensions="<wbr>true" /></div><div> <CubeUsage cubeName="imports" ignoreUnrelatedDimensions="<wbr>true" /></div><div> </CubeUsages></div><div> </div><div> <VirtualCubeDimension name="Date" /></div><div> <VirtualCubeDimension name="Geography" /></div><div> <VirtualCubeDimension name="HS" /></div><div> </div><div> <VirtualCubeMeasure cubeName="exports" name="[Measures].[FOB US]" /></div><div> <VirtualCubeMeasure cubeName="imports" name="[Measures].[CIF US]" /></div><div> </div><div> <CalculatedMember name="FOB" dimension="Measures"></div><div> <Formula>ValidMeasure([<wbr>Measures].[FOB US])</Formula></div><div> </CalculatedMember></div><div> </div><div> <CalculatedMember name="CIF" dimension="Measures"></div><div> <Formula>ValidMeasure([<wbr>Measures].[CIF US])</Formula></div><div> </CalculatedMember></div><div> </VirtualCube></div><div> </Schema></div><div> </div><div>Any hint will be appreciated.</div><div><br></div><div>Best,</div><div><br></div><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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">--</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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><a href="http://jazzido.com" target="_blank">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;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><br></div><br class="m_-2157351026455120732Apple-interchange-newline">
</div>
<br></div><br>______________________________<wbr>_________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" rel="noreferrer" target="_blank">http://lists.pentaho.org/<wbr>mailman/listinfo/mondrian</a><br>
<br></blockquote></div></div>