Levels do not show

[joeri]

Hi,

I'm trying to join some tables in my mondrian schema with a custom query:

    <Dimension name="User">        <Hierarchy hasAll="true" allMemberName="All Users" primaryKey="USERID">        <Query>        <SQL dialect="oracle">        SELECT * FROM DIMUSER INNER JOIN DIMCOUNTRY ON DIMUSER.bkcountry = DIMCOUNTRY.COUNTRYBK INNER JOIN DIMCONTINENT ON DIMCOUNTRY.continentbk = DIMCONTINENT.continentbk        </SQL>        </Query>        <Level name="UserName" column="BKUSERNAME" uniqueMembers="true"/>        <Level name="CountryName" column="COUNTRY" uniqueMembers="true"/>        </Hierarchy>    </Dimension>

In my JasperServer Analysis View, I can't browse through the Levels that I've defined above (UserName and CountryName)

As a matter of fact, I can even put invalid values in the Level in my mondrian schema. ?? It seems the Level elements are just ignored?

 <Level name="CountryName" column="INVALIIIIIDCOLUMN" uniqueMembers="true"/>

What's the problem here?

Thanks.

Regards

Joeri