Analysis Views and VirtualCubes. Does it work?

[lauchlin]

Hi,

I have a series of cubes designed that I have been querying and navigating succesfully using the analysis views so I thought I'd have a crack at setting up a virtual cube so I could navigate the two cubes as they have realted data.  The virtual cube is quite simple with most dimensions being shared and there being only three measures.  The following schema validates and from what I can tell should work;

  <VirtualCube name="Jobs and Referrals">
    <CubeUsages>
      <CubeUsage cubeName="Jobs" ignoreUnrelatedDimensions="true"/>
      <CubeUsage cubeName="Referrals"/>
    </CubeUsages>
    <VirtualCubeDimension name="date"/>
    <VirtualCubeDimension name="Trade Type"/>
    <VirtualCubeDimension name="Region"/>
    <VirtualCubeDimension name="Budget"/>
    <VirtualCubeDimension name="Referrals Requested"/>
    <VirtualCubeDimension cubeName="Referrals" name="Referral Status"/>
    <VirtualCubeMeasure cubeName="Jobs" name="[Measures].[Jobs Submitted Count]"/>
    <VirtualCubeMeasure cubeName="Referrals" name="[Measures].[Referrals by Status]"/>
    <VirtualCubeMeasure cubeName="Referrals" name="[Measures].[Jobs by Referrals Status]"/>
  </VirtualCube>

However, when I try to run a query against the virtual cube under the analysis view it reports "Mondrian Error:MDX object '[Measures].[Referrals by Status]' not found in cube 'Jobs and Referrals'"

I could create a view in MySQL that would solve my problem but I thought it would be interesting to see jasper working with VirtualCubes.

[swood]

I think you are trying to use the wrong syntax. JasperAnalysis is based on Mondrian 2.3.2. The VirtualCiube definition should look like the XML below

 

Sherman

Jaspersoft

Code:

<VirtualCube name="Warehouse and Sales">  <VirtualCubeDimension cubeName="Sales" name="Customers"/>  <VirtualCubeDimension cubeName="Sales" name="Education Level"/>  <VirtualCubeDimension cubeName="Sales" name="Gender"/>  <VirtualCubeDimension cubeName="Sales" name="Marital Status"/>  <VirtualCubeDimension name="Product"/>  <VirtualCubeDimension cubeName="Sales" name="Promotion Media"/>  <VirtualCubeDimension cubeName="Sales" name="Promotions"/>  <VirtualCubeDimension name="Store"/>  <VirtualCubeDimension name="Time"/>  <VirtualCubeDimension cubeName="Sales" name="Yearly Income"/>  <VirtualCubeDimension cubeName="Warehouse" name="Warehouse"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[sales Count]"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[store Cost]"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[store Sales]"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[unit Sales]"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Profit]"/>  <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Profit Growth]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[store Invoice]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[supply Time]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[units Ordered]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[units Shipped]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Cost]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Profit]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Sales]"/>  <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Average Warehouse Sale]"/>  <CalculatedMember name="Profit Per Unit Shipped" dimension="Measures">    <Formula>[Measures].[Profit] / [Measures].[units Shipped]</Formula>  </CalculatedMember></VirtualCube>

[carminez]

I also get the same error, while defining the virtual cube as in the sample. The MDX I run in Workbench runs successfully, but not as an Analysis View.

[swood]

This should work. Also JasperServer/JasperAnalysis 3.5, released at the end of April, has an upgrade to Mondrian 3.0.4 in it, which may help.

 

Sherman

Jaspersoft

[omurchuc]

Folks, I have a schema created using a virtual cube much like the example Sherman uses above.

My question is:

Can someone provide an MDX example using two measures one from each cube?

I keep getting errors like:

Mondrian Error:MDX object '[Measures].[sum - AM Duty]' not found in cube 'name removed'

 

 

Any help you can offer would be greatly appreciated

 

 

Code:

My MDX is: select {[Measures].[sum - AM Duty],[Measures].[sum - Non Res AM Duty]}ON COLUMNS, NON EMPTY {([Time].[All Time], [Documents].[All Documents])} ON ROWS from [name removed]

Post Edited by omurchuc at 06/10/2009 11:23

[Jacopo]

Hello,

I was trying to set up a virtual cube in a schema and I stumbled upon the same error that lauchlin and omurchuc were talking about:

when I execute a simple MDX query on the schema, involving measures from the virtual cube, Jasper Analysis comes out with the error notification:

Mondrian Error:MDX object '[Measures].[mymeasure]' not found in cube 'VCube'

The syntax I used to define the virtual measure in the schema is the same as the one used by lauchlin and swood :

<VirtualCubeMeasure cubeName="MyCube" name="[Measures].[mymeasure]"/>

I was wondering what is the cause of the problem:

     - the schema?

     - the mdx query?

     - Mondrian?

     - JasperAnalysis?

I will probably switch to the newer version of JasperAnalysis if someone assures me that the upgrade to Mondrian 3.0.4 solved this kind of problems.

Thank you very much for the help!

Jacopo

 

 

[swood]

You will have to post your schema and MDX in order for us to help.

 

Sherman

Jaspersoft

[Jacopo]

I solved the problem updating JasperServer to the 3.5 version, now I've been able to create the Virtual Cube correctly but I'm experiencing problems that I'll explain in another topic :-)