Jump to content
Changes to the Jaspersoft community edition download ×

pretty weird error in mdx query!!


Nicolep

Recommended Posts

Hi,

 

I've met a pretty weird error in Jasperserver..

I created a new olap datasource, a new olap cube schema, a new olap mondrian connection and I tried to create a new olap analysis view..

 

My problem deals with the mdx query : I wrote that query :

SELECT {[Measures].[unit Sales], [Measures].[store sales]} ON COLUMNS,

{[Time].[1997].[Q1].descendants} ON ROWS

FROM [sales]

WHERE [Gender].[F]

 

the error is :

The following is not a valid MDX Query: Mondrian Error:MDX object '[Measures].[store Cost]' not found in cube 'Sales'

 

So it says to me that the store COST measure doesn't exist..I know that! I never ask for the store COST measure but for the Store SALES measure!

Why does it think i'm searching the store COST measure??

 

thanks

 

Nicolep

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...