Jump to content
We've recently updated our Privacy Statement, available here ×

Mondrian Error:Internal error: Virtual file is not readable


shahidwin89
Go to solution Solved by udidav,

Recommended Posts

I am new to jasper and while generating olap view, in the last step wheb  mdx query is to be entered and submitted, i am getting the following error

The following is not a valid MDX query: Mondrian Error:Internal error: Virtual file is not readable: repoint:/analysis/views/working1

 

this is the query

SELECT {
    [Measures].[product NUMBER],
    [Measures].[class NUMBER]
} ON COLUMNS, {
    [Product].firstChild // OR [Product].lastChild
} ON ROWS FROM Products;

it works fine in olap workbench4.0.0

and this is the olap content

<?xml version="1.0"?>
-<Schema name="Foodmart">-<Cube name="Products" enabled="true" cache="true"><Table name="product" alias=""> </Table>-<Dimension name="Product" foreignKey="product_id" type="StandardDimension">-<Hierarchy name="" hasAll="true"><Level name="Brand" uniqueMembers="false" column=" brand_name" table="product"> </Level><Level name="Name" uniqueMembers="false" column="product_name" table="product"> </Level><Level name="SKU" uniqueMembers="false" column="sku" table="product"> </Level></Hierarchy></Dimension><Measure name="product number" column="product_id" visible="true" aggregator="distinct-count"> </Measure><Measure name="class number" column="product_class_id" visible="true" aggregator="distinct-count"> </Measure></Cube></Schema>

 

Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

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