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

shahidwin89

Members
  • Posts

    1
  • Joined

  • Last visited

shahidwin89's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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>
×
×
  • Create New...