Guys,
Im looking at the MDX OLAP stuff, very cool indeed.
My OLAP config looks like this: (not all dimensions are used at once)
<config>
<datasource>pg_db</datasource>
<cube>Sales</cube>
<Schema>
<Cube name="Sales">
<Table name="olap_sales"/>
<Dimension name="Product" foreignKey="product_id">
<Hierarchy hasAll="false" primaryKey="id">
<Table name="olap_product"/>
<Level name="Product Line"
column="product_line" uniqueMembers="true"/>
<Level name="Product Name"
column="product_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Region" foreignKey="region_id">
<Hierarchy hasAll="false" primaryKey="id">
<Table name="olap_region"/>
<Level name="Zone"
column="zone_name" uniqueMembers="true"/>
<Level name="Territory"
column="territory_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Time" foreignKey="time_id">
<Hierarchy hasAll="false" primaryKey="id">
<Table name="olap_time"/>
<Level name="Year" column="year"
uniqueMembers="true"/>
<Level name="Quarter"
column="quarter" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="hdd" foreignKey="hdd_id">
<Hierarchy hasAll="false" primaryKey="id">
<Table name="olap_hdd"/>
<Level name="Size" column="size"
uniqueMembers="true"/>
<Level name="Manufacturer"
column="manufacturer" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Claim" foreignKey="cm_id">
<Hierarchy hasAll="true" primaryKey="id">
<Table name="olap_claim"/>
<Level name="Case Manager"
column="case_manager" uniqueMembers="true"/>
<Level name="Claim Number"
column="claim_number" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="Profit" column="profit"
aggregator="sum" formatString="$#,###;-$#,###;-;-"/>
<Measure name="Price" column="price"
aggregator="sum" formatString="$#,###;-$#,###;-;-"/>
</Cube>
</Schema>
</config>
There are two "Measures" in there, but im only getting the top one returned.
If I put Price above Profit I get that one.
Any clues?
Matt
Matt Allen
Client Services Director - 0413 777 771
River Dynamics
Winner, Innovation In Claims Management
- 2003 Australasian Claims Expo
_______________________________________________
oxf-users mailing list
[EMAIL PROTECTED]
http://mail.orbeon.com/mailman/listinfo/oxf-users
