OLAP Cube doesnt show correct info

Question

Hi!

I have an issue with the data showed in the OLAP Cube.

I have clicked in the reload schema button but the data isn't refresh.

The cube should show info about some months loaded in the DB.

mysql> select distinct(MES) from c_intentos_cobro;

+------+

| MES  |

+------+

| 02   |

| 03   |

| 04   |

| 05   |

| 06   |

| 08   |

| 09   |

+------+

The cube only shows info about month 09:

Below is The mdxquery:

MDX Query:

    SELECT
        {[Measures].[TOTAL COBRADO],
        [Measures].[CANT COBROS]}
            ON COLUMNS,
            Hierarchize(
    Union
    (
Union
({[d_fecha].[FECHA]}, [d_fecha].[FECHA].Children), [d_fecha].[2018].Children))
    ON ROWS
FROM
[CUBO_INTENTOS_COBRO]

And the business model seems to be ok:

Please I need to know where is the cache configuration to understand what is wrong with the cube.

Thanks in advance.

Answer 1

Hi Guido,

why are you checking business model? You should check Mondrian schema.

Besides checking the schema, which I'm afraid it isn't worthy, can you check if the Suppress empty columns is enabled?

It can be useful to reload the Modnrian schema so it should update dimensions and measures.

Let me know if it works.

Regards,

Nunzia

Comments

HI! below you will find the mondrian generated:

<?xml version="1.0" ?>

<SCHEMA name="intentos">

<Dimension name="d_fecha" type="TimeDimension" visible="true" highCardinality="false">

<Hierarchy hasAll="true" allMemberName="FECHA" primaryKey="ANIO" >

<Table name="d_fecha"/>

<Level name="ANIO" column="ANIO" levelType="TimeYears" />

<Level name="MES" column="MES" levelType="TimeMonths" />

<Level name="DIA" column="DIA" levelType="TimeDays" />

</Hierarchy>

</Dimension>

<Dimension name="d_proveedor">

<Hierarchy hasAll="true" allMemberName="PROVEEDORES" primaryKey="ID_PROVEEDOR" >

<Table name="d_proveedor"/>

<Level name="Id_proveedor" column="Id_proveedor" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Dimension name="d_servicio">

<Hierarchy hasAll="true" allMemberName="SERVICIOS" primaryKey="SERVICE_ID" >

<Table name="d_servicio"/>

<Level name="SERVICE_ID" column="SERVICE_ID" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Dimension name="d_precio">

<Hierarchy hasAll="true" allMemberName="PRECIOS" primaryKey="PRECIO">

<Table name="d_precio"/>

<Level name="PRECIO" column="PRECIO" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Dimension name="d_tipo_error">

<Hierarchy hasAll="true" allMemberName="TIPO_ERROR" primaryKey="TIPO_ERROR">

<Table name="d_tipo_error"/>

<Level name="TIPO_ERROR" column="TIPO_ERROR" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Dimension name="d_funcion">

<Hierarchy hasAll="true" allMemberName="Funcion" primaryKey="FUNCION">

<Table name="d_funcion"/>

<Level name="FUNCION" column="FUNCION" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Dimension name="d_tasador">

<Hierarchy hasAll="true" allMemberName="Tasador" primaryKey="TASADOR">

<Table name="d_tasador"/>

<Level name="TASADOR" column="TASADOR" uniqueMembers="false"/>

</Hierarchy>

</Dimension>

<Cube name="CUBO_INTENTOS_COBRO">

<Table name="c_intentos_cobro"/>

<DimensionUsage name="d_fecha" source="d_fecha" foreignKey="ANIO"/>

<DimensionUsage name="d_fecha" source="d_fecha" foreignKey="MES"/>

<DimensionUsage name="d_fecha" source="d_fecha" foreignKey="DIA"/>

<DimensionUsage name="d_proveedor" source="d_proveedor" foreignKey="PROVEEDOR"/>

<DimensionUsage name="d_servicio" source="d_servicio" foreignKey="SERVICIO"/>

<DimensionUsage name="d_precio" source="d_precio" foreignKey="PRECIO"/>

<DimensionUsage name="d_tasador" source="d_tasador" foreignKey="TASADOR"/>

<DimensionUsage name="d_funcion" source="d_funcion" foreignKey="FUNCION"/>

<DimensionUsage name="d_tipo_error" source="d_tipo_error" foreignKey="TIPO_ERROR"/>

<Measure name="TOTAL COBRADO" column="TOTAL_COBRADO" aggregator="sum" formatString="$#,###.00"/>

<Measure name="CANT COBROS" column="CANT_COBROS" aggregator="sum" formatString="#,###"/>

</Cube>

<Cube name="CUBO_COBROS">

<Table name="c_cobros"/>

<DimensionUsage name="d_fecha" source="d_fecha" foreignKey="ANIO"/>

<DimensionUsage name="d_proveedor" source="d_proveedor" foreignKey="PROVEEDOR"/>

<DimensionUsage name="d_servicio" source="d_servicio" foreignKey="SERVICIO"/>

<DimensionUsage name="d_precio" source="d_precio" foreignKey="PRECIO"/>

<DimensionUsage name="d_tasador" source="d_tasador" foreignKey="TASADOR"/>

<DimensionUsage name="d_funcion" source="d_funcion" foreignKey="FUNCION"/>

<Measure name="TOTAL COBRADO" column="TOTAL_COBRADO" aggregator="sum" formatString="$#,###.00"/>

<Measure name="CANT COBROS" column="CANT_COBROS" aggregator="sum" formatString="#,###"/>

</Cube>

</SCHEMA>

--------------------------------------------------------------------------------------------------------------------------

When I executed the OLAP I got the following error: "Can not load MDX formulas"

        at java.lang.Thread.run(Thread.java:748)
26 Sep 2018 15:20:23,751 ERROR it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile:81 - Can not load MDX formulas
java.lang.NullPointerException
        at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile(MDXFormulaHandler.java:78)
        at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulasFromXML(MDXFormulaHandler.java:91)
        at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulas(MDXFormulaHandler.java:109)
        at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serializeFunctions(PivotJsonHTMLSerializer.java:382)
        at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:280)
        at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:76)

--------------------------------------------------------------------------------------------------------------------------

Hope your answer!

BR,

---

Hi Guido,

The schema seems right. But I don't understand what the problem is.

Do you wish to reload OLAP so you can refresh data (and see new months)?

Or is there something else?

Anyway for the first problem, considering that the the relaod schema available in the menu panel is not refreshing data as it should be, I suggest you to reload the Mondrian schema manually, using the Mondrian schema catalog available in Knowage main menu (https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=17565814779225329751).

Regards,

Nunzia

---

It was solved! was my fault, the time dimension had only one registry.

Thanks for your time.

BR,

---

Great!

Regards,

Nunzia