Openbravo Issue Tracking System - Modules
View Issue Details
0039361ModulesAnalyticspublic2018-09-27 14:152018-10-26 08:11
urgentmajorhave not tried
0039361: Cubes not shown in OB Analytics window after upgrading from a version prior to 1.3.0 if there is a dimension with XML definition
Cubes not shown in OB Analytics window after upgrading from a version prior to 1.3.0 if there is a dimension with XML definition
As group admin role:
   Create a new dimension for Sales Details Fact Cube

   As XML Definition field was removed in 1.3.0 due to the following commit, we will assign a value to it through database [^]

update obanaly_cube_dimension
set xmldefinition = '<Dimension caption="Product" table="alias1_73" key="product-key" name="product">
<Attribute name="product-key" visible="false" keyColumn="m_product_id" caption="Product" hasHierarchy="false">
<Annotation name="entity">Product</Annotation>
<MemberFormatter className=""/>
<Attribute name="productLevel" table="alias1_73" keyColumn="m_product_id" caption="Product" visible="true" orderByColumn="name">
<Annotation name="entity">Product</Annotation>
<MemberFormatter className=""/>
where obanaly_cube_dimension_id = '<idOfDimensionCreated>'

As group admin role:
   Go to OB Analytics window and refresh the cubes
   Check no cubes are shown and the log shows:

      Caused by: mondrian.rolap.RolapSchema$MondrianSchemaException: table 'obanaly_time_dimension' not found (in Dimension 'dateDelivered') (at line 901, column 6)
    at mondrian.rolap.RolapSchemaLoaderHandlerImpl.error(
    at mondrian.rolap.RolapSchemaLoader.getPhysRelation(
    at mondrian.rolap.RolapSchemaLoader.getOrCreateDimension(
    at mondrian.rolap.RolapSchemaLoader.createCube(
    at mondrian.rolap.RolapSchemaLoader.loadStage2(
    at mondrian.rolap.RolapSchemaLoader.loadStage1(
    at mondrian.rolap.RolapSchemaLoader.loadStage0(
    at mondrian.rolap.RolapSchemaLoader.createSchema(
    at mondrian.rolap.RolapSchemaPool.get(
    at mondrian.rolap.RolapSchemaPool.get(
    at mondrian.rolap.RolapConnection.<init>(
    at mondrian.rolap.RolapConnection.<init>(
    at mondrian.olap.DriverManager.getConnection(
    at mondrian.olap.DriverManager.getConnection(
    at mondrian.olap4j.MondrianOlap4jConnection.<init>(
    at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(
    at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(
    at mondrian.olap4j.FactoryJdbc41Impl.newConnection(
    at mondrian.olap4j.MondrianOlap4jDriver.connect(
    at java.sql.DriverManager.getConnection(
    at java.sql.DriverManager.getConnection(
No tags attached.
Issue History
2018-09-27 14:15ngarciaNew Issue
2018-09-27 14:15ngarciaAssigned To => platform
2018-09-27 14:16ngarciaIssue Monitored: networkb
2018-10-11 09:28caristuAssigned Toplatform => caristu
2018-10-11 09:30hgbotCheckin
2018-10-11 09:30hgbotNote Added: 0107238
2018-10-11 09:30hgbotStatusnew => resolved
2018-10-11 09:30hgbotResolutionopen => fixed
2018-10-11 09:30hgbotFixed in SCM revision => [^]
2018-10-11 09:31caristuReview Assigned To => alostale
2018-10-26 08:11alostaleNote Added: 0107606
2018-10-26 08:11alostaleStatusresolved => closed

2018-10-11 09:30   
Repository: erp/pmods/
Changeset: 455d94f6f8b579103d34d26a3cc887f4e077557a
Author: Carlos Aristu <carlos.aristu <at>>
Date: Thu Oct 11 09:22:35 2018 +0200
URL: [^]

Fixes issue 39361: cube not shown if there is a dimension with XML definition

  The xml definition for cubes and dimensions was deprecated[1]. But there was still some code related with that feature which was causing troubles on cube generation if a dimension had an xml definition.

  That code has been removed.

[1] [^]

M src/org/openbravo/client/analytics/mondrian/
2018-10-26 08:11