[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: [Mondrian] Question: Xml Columns in mond3->4 upgrade
From: Austin H <austin () haedrian ! io>
Date: 2015-09-21 16:36:23
Message-ID: CAJfTh=7L8PdnT4FhT2ryzhN5o1xPqc-9LSknKc6vD1=-20U7Kg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I am working on mifosx opensource microfiance platform. I am trying to
upgrade an old xml to mond4 (to use for saiku analytics). I commented out
the virtual cube but it still won't work. I was reading that it might have
something to do with columns that are differnet in 4 somehow?
any help would be greatly appreciated.
[Attachment #5 (text/html)]
<div dir="ltr"><div class="gmail_signature"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div dir="ltr"><div><span style="font-size:12.8000001907349px">I am working \
on mifosx opensource microfiance platform. I am trying to upgrade an old xml to mond4 \
(to use for saiku analytics). I commented out the virtual cube but it still won't \
work. I was reading that it might have something to do with columns that are \
differnet in 4 somehow?</span><br></div><div \
style="font-size:12.8000001907349px"><br></div><div \
style="font-size:12.8000001907349px">any help would be greatly appreciated. \
</div></div></div></div></div></div> </div>
["mifos.xml" (text/xml)]
<Schema name="Mifos">
<Dimension type="StandardDimension" visible="true" highCardinality="false" \
name="Office"> <Hierarchy visible="true" hasAll="true" primaryKey="id" \
primaryKeyTable="m_client"> <Join leftKey="office_id" rightKey="id">
<Table name="m_client">
</Table>
<Table name="m_office">
</Table>
</Join>
<Level name="Office Name" visible="true" table="m_office" column="name" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" \
name="Clients"> <Hierarchy visible="true" hasAll="true" primaryKey="id">
<Table name="m_client">
</Table>
<Level name="Client's Name" visible="true" column="display_name" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Client ID" visible="true" column="id" type="Integer" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Client Extrnal ID" visible="true" column="external_id" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Joining Date" visible="true" table="m_client" \
column="activation_date" type="Date" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
<Level name="First Name" visible="true" table="m_client" column="firstname" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Last Name" visible="true" table="m_client" column="lastname" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Middle Name" visible="true" table="m_client" column="middlename" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Display Name" visible="true" table="m_client" \
column="display_name" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
<Level name="Mobile No" visible="true" table="m_client" column="mobile_no" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level> <Level name="Date Of Birth" visible="true" table="m_client" \
column="date_of_birth" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
<Level name="Closure Date" visible="true" table="m_client" \
column="closedon_date" type="Date" uniqueMembers="true" levelType="Regular" \
hideMemberIf="Never"> </Level>
<Level name="Default Saving Account" visible="true" table="m_client" \
column="default_savings_account" type="Integer" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Default Savings Product" visible="true" table="m_client" \
column="default_savings_product" type="String" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" \
name="Staff"> <Hierarchy visible="true" hasAll="true" primaryKey="id">
<Table name="m_staff">
</Table>
<Level name="Loan Officer's Name" visible="true" column="display_name" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" \
name="Client Status"> <Hierarchy name="default" visible="true" hasAll="true" \
primaryKey="id" primaryKeyTable="m_client"> <Join leftKey="status_enum" \
rightKey="enum_id"> <Table name="m_client">
</Table>
<Table name="r_enum_value">
</Table>
</Join>
<Level name="Client Status" visible="true" table="r_enum_value" \
column="enum_value" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" \
name="Loan Status"> <Hierarchy name="default" visible="true" hasAll="true" \
primaryKey="id" primaryKeyTable="m_loan"> <Join leftKey="loan_status_id" \
rightKey="enum_id"> <Table name="m_loan">
</Table>
<Table name="r_enum_value">
</Table>
</Join>
<Level name="Loan Status" visible="true" table="r_enum_value" \
column="enum_value" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Cube name="Loans" visible="true" defaultMeasure="Unit Sales" cache="true" \
enabled="true"> <Table name="m_loan">
</Table>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Loan">
<Hierarchy visible="true" hasAll="true" allMemberName="All Loans" \
primaryKey="id"> <Table name="m_loan">
</Table>
<Level name="Loan's approved principal" visible="true" \
column="approved_principal" type="Numeric" uniqueMembers="true" levelType="Regular" \
hideMemberIf="Never"> </Level>
<Level name="Loan's currency code" visible="true" column="currency_code" \
type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> \
</Level>
<Level name="Customer ID" visible="true" column="client_id" type="Integer" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Disbursed Date" visible="true" column="disbursedon_date" \
type="Date" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="TimeDimension" visible="true" foreignKey="submittedon_date" \
highCardinality="false" name="Loans/Date"> <Hierarchy visible="true" hasAll="true" \
primaryKey="the_date"> <View alias="date_view">
<SQL dialect="mysql">
<![CDATA[SELECT YEAR(submittedon_date) as the_year, \
MONTH(submittedon_date) as the_month, DAY(submittedon_date) as the_day, \
submittedon_date as the_date FROM m_loan]]> </SQL>
</View>
<Level name="Year" visible="true" column="the_year" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"> \
</Level>
<Level name="Month" visible="true" column="the_month" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="Never"> \
</Level>
<Level name="Day" visible="true" column="the_day" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeDays" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="product_id" \
highCardinality="false" name="Loans/Products"> <Hierarchy visible="true" \
hasAll="true" primaryKey="id"> <Table name="m_product_loan">
</Table>
<Level name="Product name" visible="true" column="short_name" type="String" \
uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="loan_officer_id" \
highCardinality="false" name="Loans/Staff"> <Hierarchy visible="true" hasAll="true" \
primaryKey="id"> <Table name="m_staff">
</Table>
<Level name="Loan officer's name" visible="true" column="display_name" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="loanpurpose_cv_id" \
highCardinality="false" name="Loans/Purposes"> <Hierarchy visible="true" \
hasAll="true" primaryKey="code_id"> <Table name="m_code_value">
</Table>
<Level name="Purpose" visible="true" column="code_value" type="String" \
uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<DimensionUsage source="Office" name="Office" visible="true" \
foreignKey="client_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Clients" name="Clients" visible="true" \
foreignKey="client_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Client Status" name="Client Status" visible="true" \
foreignKey="client_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Loan Status" name="Loan Status" visible="true" \
foreignKey="id" highCardinality="false"> </DimensionUsage>
<Dimension type="TimeDimension" visible="true" foreignKey="disbursedon_date" \
highCardinality="false" name="Loans/Disbursed Date">
<Hierarchy name="Default" visible="true" hasAll="true" \
primaryKey="disbursed_date"> <View alias="DisbursedDateView">
<SQL dialect="generic">
<![CDATA[SELECT YEAR(disbursedon_date) as db_year, \
MONTH(disbursedon_date) as db_month, DAY(disbursedon_date) as db_day, \
disbursedon_date as disbursed_date FROM `mifostenant-default`.m_loan]]> </SQL>
</View>
<Level name="Year" visible="true" column="db_year" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"> \
</Level>
<Level name="Day" visible="true" column="db_day" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeDays" hideMemberIf="Never"> \
</Level>
<Level name="Month" visible="true" column="db_month" type="Integer" \
internalType="int" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Measure name="Loans/Loan number" column="id" aggregator="distinct-count" \
visible="true"> </Measure>
<Measure name="Loans/Count Rows" column="account_no" aggregator="count" \
visible="true"> </Measure>
<Measure name="Loans/Principal amount" column="principal_amount" aggregator="sum" \
visible="true"> </Measure>
<Measure name="Loans/Approved principal" column="approved_principal" \
aggregator="sum" visible="true"> </Measure>
<Measure name="Loans/Nominal interest rate per period" \
column="nominal_interest_rate_per_period" aggregator="sum" visible="true"> \
</Measure> <Measure name="Loans/Annual nominal interest rate" \
column="annual_nominal_interest_rate" aggregator="sum" visible="true"> </Measure>
<Measure name="Loans/Outstanding Interest" column="interest_outstanding_derived" \
aggregator="sum" visible="true"> </Measure>
<Measure name="Loans/Disbursed Amount" column="principal_disbursed_derived" \
aggregator="sum" visible="true"> </Measure>
</Cube>
<Cube name="Savings" visible="true" cache="true" enabled="true">
<Table name="m_savings_account">
</Table>
<Dimension type="StandardDimension" visible="true" foreignKey="product_id" \
highCardinality="false" name="Savings/Products"> <Hierarchy visible="true" \
hasAll="true" primaryKey="id"> <Table name="m_savings_product">
</Table>
<Level name="Savings Product Name" visible="true" column="name" type="String" \
uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<DimensionUsage source="Office" name="Savings/Office" visible="true" \
foreignKey="client_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Clients" name="Savings/Client" visible="true" \
foreignKey="client_id" highCardinality="false"> </DimensionUsage>
<Dimension type="StandardDimension" visible="true" foreignKey="client_id" \
highCardinality="false" name="Savings/Transaction">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="id">
<Table name="m_savings_account_transaction">
</Table>
<Level name="Amount" visible="true" column="amount" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Overdraft Amound Derived" visible="true" \
column="overdraft_amount_derived" type="String" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Balance Number of DaysDerived" visible="true" \
column="balance_number_of_days_derived" type="String" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Running Balance Derived" visible="true" \
column="running_balance_derived" type="String" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Cumulative Balance Derived" visible="true" \
column="cumulative_balance_derived" type="String" uniqueMembers="false" \
levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Measure name="Savings/Annual Interest Rate" \
column="nominal_annual_interest_rate" aggregator="sum" visible="true"> </Measure>
<Measure name="Savings/Overdraft Limit" column="overdraft_limit" aggregator="sum" \
visible="true"> </Measure>
<Measure name="Savings/Account Balance" column="account_balance_derived" \
aggregator="sum" visible="true"> </Measure>
</Cube>
<Cube name="Loan Transaction" visible="true" cache="true" enabled="true">
<Table name="m_loan_transaction">
</Table>
<DimensionUsage source="Office" name="Office" visible="true" \
foreignKey="office_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Clients" name="Clients" visible="true" \
foreignKey="office_id" highCardinality="false"> </DimensionUsage>
<Dimension type="StandardDimension" visible="true" foreignKey="loan_id" \
highCardinality="false" name="Loan Transaction/Info"> <Hierarchy name="default" \
visible="true" hasAll="true"> <Table name="m_loan_transaction">
</Table>
<Level name="Is Reversed" visible="true" column="is_reversed" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="TimeDimension" visible="true" foreignKey="transaction_date" \
highCardinality="false" name="Loan Transaction/Date">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="the_date">
<View alias="DateAlias">
<SQL dialect="mysql">
<![CDATA[SELECT YEAR(transaction_date) as the_year, \
MONTH(transaction_date) as the_month, DAY(transaction_date) as the_day, \
transaction_date as the_date FROM m_loan_transaction]]> </SQL>
</View>
<Level name="Day" visible="true" column="the_day" type="Integer" \
internalType="int" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> \
</Level>
<Level name="Month" visible="true" column="the_month" type="Integer" \
internalType="int" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> \
</Level>
<Level name="Year" visible="true" column="the_year" type="Integer" \
internalType="int" uniqueMembers="false" levelType="TimeYears" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Loan Transaction/No">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="id" \
primaryKeyTable="m_loan_transaction"> <Join leftKey="loan_id" rightKey="id">
<Table name="m_loan_transaction">
</Table>
<Table name="m_loan">
</Table>
</Join>
<Level name="Account No" visible="true" table="m_loan" column="account_no" \
type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> \
</Level> </Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Loan Transaction/Type">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="id" \
primaryKeyTable="m_loan_transaction"> <Join leftKey="transaction_type_enum" \
rightKey="enum_id"> <Table name="m_loan_transaction">
</Table>
<Table name="r_enum_value">
</Table>
</Join>
<Level name="Transaction Type" visible="true" table="r_enum_value" \
column="enum_value" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Measure name="Loan Transaction/Amount" column="amount" aggregator="sum" \
visible="true"> </Measure>
<Measure name="Loan Transaction/Charges Portion Derived" \
column="penalty_charges_portion_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Loan Transaction/Overpayment Portion Derived" \
column="overpayment_portion_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Loan Transaction/Interest Portion Derived" \
column="interest_portion_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Loan Transaction/Fee Charges Portion Derived" \
column="fee_charges_portion_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Loan Transaction/Principal Portion Derived" \
column="principal_portion_derived" aggregator="sum" visible="true"> </Measure>
</Cube>
<Cube name="Savings Transaction" visible="true" cache="true" enabled="true">
<Table name="m_savings_account_transaction">
</Table>
<DimensionUsage source="Clients" name="Clients" visible="true" \
foreignKey="office_id" highCardinality="false"> </DimensionUsage>
<DimensionUsage source="Office" name="Office" visible="true" \
foreignKey="office_id" highCardinality="false"> </DimensionUsage>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Savings Transaction/ Info"> <Hierarchy name="default" \
visible="true" hasAll="true"> <Table name="m_savings_account_transaction">
</Table>
<Level name="Is Reversed" visible="true" column="is_reversed" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Savings Transaction/Date"> <Hierarchy name="default" \
visible="true" hasAll="true"> <View alias="transactionAlias">
<SQL dialect="mysql">
<![CDATA[SELECT YEAR(transaction_date) as the_year, \
MONTH(transaction_date) as the_month, DAY(transaction_date) as the_day, \
transaction_date as the_date FROM m_savings_account_transaction]]> </SQL>
</View>
<Level name="Day" visible="true" column="the_day" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Year" visible="true" column="the_year" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
<Level name="Month" visible="true" column="the_month" type="String" \
uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Savings Transaction/Account No">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="id" \
primaryKeyTable="m_savings_account_transaction"> <Join leftKey="savings_account_id" \
rightKey="id"> <Table name="m_savings_account_transaction">
</Table>
<Table name="m_savings_account">
</Table>
</Join>
<Level name="Account No" visible="true" table="m_savings_account" \
column="account_no" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" foreignKey="id" \
highCardinality="false" name="Savings Transaction/Type">
<Hierarchy name="default" visible="true" hasAll="true" primaryKey="id" \
primaryKeyTable="m_savings_account_transaction"> <Join \
leftKey="transaction_type_enum" rightKey="enum_id"> <Table \
name="m_savings_account_transaction"> </Table>
<Table name="r_enum_value">
</Table>
</Join>
<Level name="Transaction Type" visible="true" table="r_enum_value" \
column="enum_value" type="String" uniqueMembers="false" levelType="Regular" \
hideMemberIf="Never"> </Level>
</Hierarchy>
</Dimension>
<Measure name="Savings Transaction/Amount" column="amount" aggregator="sum" \
visible="true"> </Measure>
<Measure name="Savings Transaction/Overdraft Amount Derived" \
column="overdraft_amount_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Savings Transaction/Running Balace Derived" \
column="running_balance_derived" aggregator="sum" visible="true"> </Measure>
<Measure name="Savings Transaction/Cumulative Blance Derived" \
column="cumulative_balance_derived" aggregator="distinct-count" visible="true"> \
</Measure> </Cube>
<VirtualCube enabled="true" name="Loans and Savings" visible="true">
<VirtualCubeDimension cubeName="Savings" visible="true" highCardinality="false" \
name="Savings/Products"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Savings" visible="true" highCardinality="false" \
name="Savings/Transaction"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loans" visible="true" highCardinality="false" \
name="Loans/Date"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loans" visible="true" highCardinality="false" \
name="Loans/Products"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loans" visible="true" highCardinality="false" \
name="Loans/Staff"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loans" visible="true" highCardinality="false" \
name="Loans/Purposes"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loans" visible="true" highCardinality="false" \
name="Loans/Disbursed Date"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loan Transaction" visible="true" \
highCardinality="false" name="Loan Transaction/Info"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loan Transaction" visible="true" \
highCardinality="false" name="Loan Transaction/Date"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loan Transaction" visible="true" \
highCardinality="false" name="Loan Transaction/No"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Loan Transaction" visible="true" \
highCardinality="false" name="Loan Transaction/Type"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Savings Transaction" visible="true" \
highCardinality="false" name="Savings Transaction/ Info"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Savings Transaction" visible="true" \
highCardinality="false" name="Savings Transaction/Date"> </VirtualCubeDimension>
<VirtualCubeDimension cubeName="Savings Transaction" visible="true" \
highCardinality="false" name="Savings Transaction/Account No"> \
</VirtualCubeDimension> <VirtualCubeDimension cubeName="Savings Transaction" \
visible="true" highCardinality="false" name="Savings Transaction/Type"> \
</VirtualCubeDimension> <VirtualCubeMeasure cubeName="Loans" \
name="[Measures].[Loans/Loan number]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Count Rows]" \
visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Principal amount]" \
visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Approved principal]" \
visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Nominal interest \
rate per period]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Annual nominal \
interest rate]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Outstanding \
Interest]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loans" name="[Measures].[Loans/Disbursed Amount]" \
visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings" name="[Measures].[Savings/Annual Interest \
Rate]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings" name="[Measures].[Savings/Overdraft \
Limit]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings" name="[Measures].[Savings/Account \
Balance]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Amount]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Charges Portion Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Interest Portion Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Principal Portion Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Fee Charges Portion Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Loan Transaction" name="[Measures].[Loan \
Transaction/Overpayment Portion Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings Transaction" name="[Measures].[Savings \
Transaction/Amount]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings Transaction" name="[Measures].[Savings \
Transaction/Overdraft Amount Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings Transaction" name="[Measures].[Savings \
Transaction/Running Balace Derived]" visible="true"> </VirtualCubeMeasure>
<VirtualCubeMeasure cubeName="Savings Transaction" name="[Measures].[Savings \
Transaction/Cumulative Blance Derived]" visible="true"> </VirtualCubeMeasure>
</VirtualCube>
</Schema>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic