shahidwin89 Posted January 8, 2014 Share Posted January 8, 2014 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 errorThe following is not a valid MDX query: Mondrian Error:Internal error: Virtual file is not readable: repoint:/analysis/views/working1 this is the querySELECT { [Measures].[product NUMBER], [Measures].[class NUMBER]} ON COLUMNS, { [Product].firstChild // OR [Product].lastChild} ON ROWS FROM Products;it works fine in olap workbench4.0.0and 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 More sharing options...
Solution udidav Posted January 23, 2014 Solution Share Posted January 23, 2014 See http://community.jaspersoft.com/questions/533618/virtual-file-not-readable Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now