Hello I am trying to develop n OLAP document, but when selecting the schema and cube it does not show measures when you drill through at different dimensions only at "All" level I am posting the xml of my schema please let me know what is the problem:
<Schema name="psd2_reporting">
<Cube name="PSD2 CUBE" visible="true" cache="true" enabled="true">
<Table name="PSD2_CUBE">
</Table>
<Dimension type="StandardDimension" visible="true" foreignKey="ROUTE_ID" highCardinality="false" name="route_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="route_dim">
</Table>
<Level name="ROUTE_OF_PAYMENT" visible="true" table="route_dim" column="DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="DISTANCE_ID" highCardinality="false" name="distance_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="distance_dim">
</Table>
<Level name="DISTANCE_OF_PAYMENT" visible="true" table="distance_dim" column="DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="REPORT_ID" highCardinality="false" name="report_id_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="report_id_dim">
</Table>
<Level name="REPORT_ID" visible="true" table="report_id_dim" column="REPORT_ID_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="CARD_TYPE_ID" highCardinality="false" name="Card_Type_Dim ">
<Hierarchy visible="true" hasAll="true">
<Table name="card_type_dim">
</Table>
<Level name="CARD_TYPE" visible="true" table="card_type_dim" column="DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="GEO_ID" highCardinality="false" name="geographic_distribution_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="geographic_distr_dim">
</Table>
<Level name="GEO_DISTRIBUTION" visible="true" column="GEO_DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="SCA_CHECK_FLAG" highCardinality="false" name="sca_check_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="sca_check_dim">
</Table>
<Level name="SCA_CHECK" visible="true" table="sca_check_dim" column="DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="FLAG" highCardinality="false" name="sca_exemption_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="sca_exemption_dim">
</Table>
<Level name="SCA_EXEMPTION" visible="true" table="sca_exemption_dim" column="DESC_BG" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="FRAUD_CODE" highCardinality="false" name="fraud_type_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="fraud_codes_dim">
</Table>
<Level name="fraud_type" visible="true" table="fraud_codes_dim" column="DESC_BG_TYPE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="fraud_subtype" visible="true" table="fraud_codes_dim" column="DESC_BG_SUBTYPE" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="TimeDimension" visible="true" foreignKey="DATE_KEY" highCardinality="false" name="time_dim">
<Hierarchy visible="true" hasAll="true">
<Table name="time_dimension">
</Table>
<Level name="YEAR" visible="true" table="time_dimension" column="CURRENT_YEAR" type="String" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never">
</Level>
<Level name="QUARTER" visible="true" table="time_dimension" column="CURRENT_QUARTER" type="Integer" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
</Level>
<Level name="MONTH" visible="true" table="time_dimension" column="MONTH_BG" type="String" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
</Level>
<Level name="DAY" visible="true" table="time_dimension" column="WEEKDAY_BG" type="String" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Measure name="TOTAL_TRANSACTIONS_CT" column="TOTAL_TRANSACTIONS_CT" datatype="Numeric" aggregator="count" visible="true">
</Measure>
<Measure name="TOTAL_TRANSACTIONS_VOL" column="TOTAL_TRANSACTIONS_VOL" datatype="Numeric" aggregator="sum" visible="true">
</Measure>
<Measure name="FRAUD_TRANSACTIONS_CT" column="FRAUD_TRANSACTIONS_CT" datatype="Numeric" aggregator="count" visible="true">
</Measure>
<Measure name="FRAUD_TRANSACTIONS_VOL" column="FRAUD_TRANSACTIONS_VOL" datatype="Numeric" aggregator="sum" visible="true">
</Measure>
</Cube>
</Schema>