Jump to content
Changes to the Jaspersoft community edition download ×

pretty weird error in mdx query!!


Recommended Posts



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





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