Jump to content
Changes to the Jaspersoft community edition download ×

problem with MDX query


Nicolep

Recommended Posts

Hi,

 

I'm trying to run my own cube with jasperServer. It is really simple, here is my schema :

 

<?xml version="1.0" encoding="UTF-8"?>

<Schema name="rentabilite">

<Cube name="rentabilite">

<Table name="tbrentabilite_test"/>

<Dimension name="Temps" foreignKey="idTemps">

<Hierarchy name="Temps" hasAll="false" primaryKey="id_temps">

<Table name="temps_test"/>

<Level name="Annee" TABLE="temps_test" COLUMN="annee" uniqueMembers="true"/>

<Level name="Trimestre" TABLE="temps_test" COLUMN="trimestre" uniqueMembers="false"/>

<Level name="Mois" TABLE="temps_test" COLUMN="mois" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

 

<measure name="Taux_rentabilite" column="tauxRentabilite" aggregator="sum" datatype="String" formatString="Standard"/>

</Cube>

</Schema>

 

 

So, just one measure and one dimension.

 

I put this query in my analysis view, very simple too :

SELECT {[Measures].[Taux_rentabilite]} ON COLUMNS

FROM [rentabilite]

 

It doesn't work, I 've got the error :

not valid MDX query : null

 

have you got an idea?

 

Thanks

 

Nicolep

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

If you are using jpivot interface you will have to define a query that uses to axis, Columns and Rows.

 

So you have to put one dimension on columns and another on rows.

for example you can put the measures on columns and your temps dimension on rows.

 

hth,

 

Jens Nöring

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...