MDX Error, Hierarchy '[Measures]' is invalid

[dgiulian]

Hi everyone,

I'm trying to build an OLAP Cube using the Schema workbench, with the following xml

<Schema name="New Schema1">
        <Cube name="Familiar" caption="Familiar" cache="true" enabled="true">
                <Table name="adm_familiar" schema="PUB">
                </Table>
                <Dimension type="StandardDimension" foreignKey="empleado" name="empleado">
                        <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="all emple" allMemberCaption="Todos los empleados" allLevelName="all emple" primaryKey="codigo" primaryKeyTable="adm_empleado">
                                <Table name="adm_empleado" schema="PUB">
                                </Table>
                                <Level name="Empleado" table="adm_empleado" column="codigo" nameColumn="empnom" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" caption="Empleado">
                                </Level>
                        </Hierarchy>
                </Dimension>
        </Cube>
</Schema>
 

The cube is very simple, but when I try to execute the following MDX Query :

SELECT {[empleado].[all emple]} on rows
from [Familiar]

I get this error message:

Mondrian Error:Hierarchy '[Measures]' is invalid (has no members)

And I have no idea why is that, and what that error  means.

I would appreciate if anyone can give me a hint about how to solve this, or at least to know what I'm doing wrong.

Thanks

Post Edited by dgiulian at 11/16/2009 13:16

[swood]

You need to define some measures, which are based on columns in your fact table. Something like:

 

<Measure name="Units Ordered" column="units_ordered" formatString="#.0" aggregator="sum"/>

 

 

Sherman

Jaspersoft