inconsistent calculation model (column store error 34011)

[RafkeMagic]

Hi,

I recently upgraded my PA to version 1.0.11

Now, I was trying to rerun some of my "old" analyses and suddenly I run into strange error messages.

For a simple IQR test (Inter-quartile Range test) on a table with 2 columns and 15 rows, I get the below error:

Notice that COUNT_TAB has been generated by the PA software itself (my table is called <myschemaname>.IQRTEST.

Is this a "bug" in 1.0.11 or are there new restrictions with regards to the input data?

Cheers,

Raf

[Former Member]

Hi Raf,

There is no intermediate table created by PA in case of an inDB analysis. Yes, there is a limitation on the datatypes from PAL AFL. I assume that this issue was there from SP10 onwards (when IQR was introduced). Probably, the problem here is that, you have a BIGINT type column in your input data. Can you please confirm, if this is true?

Thanks

~Unmesh

[RafkeMagic]

Hello Unmesh,

at a customer right now without any access to our HANA box (due to strict firewall settings). I'll (double) check this tomorrow.

Kind regards,

Raf

PS it worked on my previous version of PA

[RafkeMagic]

Hi Unmesh,

just checked and my table (on which I created an Analytic view) only contains a VARCHAR 10 and a DOUBLE. Again, this worked in my previous version of PA.

Kind regards,

Raf

[Former Member]

Hi Raf...

Thanks for the update... this confirms that the issue is not with the AFL interface for PAL. We will create an analytical view of similar structure (assuming it to be a simple and straight forward defenition) and check for this issue. I will update you soon.

Thanks

~Unmesh

[RafkeMagic]

Thx!

Table contains 2 columns: SUBJECT (VARCHAR 10) & VALUE (DOUBLE) with the following contents:

SUBJECT;VALUE

P1;10.0

P2;11.0

P3;10.0

P4;9.0

P5;10.0

P6;24.0

P7;11.0

P8;12.0

P9;10.0

P10;9.0

P11;1.0

P12;11.0

P13;12.0

P14;13.0

P15;12.0

so, nothing fancy there.

[RafkeMagic]

Btw, the exact same error message is thrown for HANA C4.5, again on a fairly easy data set (column table with 4 independent and 1 dependent columns). Also my dependent column is of type INTEGER as per the requirements in the PA user guide (p86).

[Former Member]

Hi Raf,

One of our colleague (Arti) had tried this in our HANA Box and it worked fine with PA. Can you please confirm the version of the HANA box that you are working on and also please verify the xml definition of the analytic view that we created here (given below).

<?xml version="1.0" encoding="UTF-8"?>

<Cube:cube xmlns:Cube="http://www.sap.com/ndb/BiModelCube.ecore" id="TEST345" schemaVersion="1.5" defaultClient="$$client$$" defaultLanguage="$$language$$" visibility="reportingEnabled">

  <descriptions defaultDescription="TEST345"/>

  <metadata changedAt="2013-08-05 16:55:02.552" createdAt="2013-08-05 16:54:42.379"/>

  <origin system="H54:INLL50833235A.DHCP.BLRL.SAP.CORP:04:SYSTEM"/>

  <defaultSchema schemaName=" "/>

  <localVariables/>

  <privateMeasureGroup id="MeasureGroup">

    <attributes>

      <attribute id="Village">

<descriptions/>

<searchProperties/>

        <keyMapping schemaName="SYSTEM" columnObjectName="test345" columnName="SUBJECT"/>

      </attribute>

    </attributes>

    <calculatedAttributes/>

    <privateDataFoundation>

     <tableProxies>

<tableProxy>

<table schemaName="SYSTEM" columnObjectName="test345"/>

</tableProxy>

      </tableProxies>

      <joins/>

      <layout>

        <shapes>

<shape modelObjectName="test345" modelObjectNameSpace="SYSTEM" modelObjectType="catalog">

<upperLeftCorner x="70" y="30"/>

</shape>

        </shapes>

      </layout>

    </privateDataFoundation>

    <baseMeasures>

      <measure id="Gender" measureType="simple">

<descriptions/>

<measureMapping schemaName="SYSTEM" columnObjectName="test345" columnName="VALUE"/>

      </measure>

    </baseMeasures>

    <calculatedMeasures/>

    <restrictedMeasures/>

    <sharedDimensions/>

    <layout>

      <shapes>

        <shape modelObjectName="MEASURE_GROUP" modelObjectType="repository">

<upperLeftCorner x="300" y="200"/>

        </shape>

      </shapes>

    </layout>

  </privateMeasureGroup>

</Cube:cube>

Thanks

~Unmesh

[RafkeMagic]

hi Unmesh,

we're working on a HANA 1.0 SP5 (on AWS) with Hana Studio Revision 48.

As far as the XML goes, mine looks completely different than yours...

<?xml version="1.0" encoding="UTF-8"?>

<View:RootView xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:Type="http://www.sap.com/ndb/DataModelType.ecore" xmlns:View="http://www.sap.com/ndb/ViewModelView.ecore">

  <view schemaVersion="1.5" name="ANV_IQR" dataCategory="CUBE" hidden="false" clientDependent="true" defaultNode="//@view/@viewNodes.1">

    <origin/>

    <endUserTexts label="ANV_IQR"/>

    <executionHints semantic="TEMPLATE"/>

    <viewNodes xsi:type="View:JoinNode" name="Data Foundation">

      <elements name="SUBJECT" aggregationBehavior="NONE" displayAttribute="false" hidden="false">

        <endUserTexts label="SUBJECT"/>

        <inlineType precision="10" primitiveType="VARCHAR" scale="0"/>

      </elements>

      <elements name="VALUE">

        <endUserTexts label="VALUE"/>

        <inlineType precision="15" primitiveType="DOUBLE" scale="0"/>

      </elements>

      <inputs>

        <entity href="../../RAF/extdbtables/IQRTEST.extdbtable#/"/>

        <mappings xsi:type="Type:ElementMapping" targetName="SUBJECT" sourceName="SUBJECT"/>

        <mappings xsi:type="Type:ElementMapping" targetName="VALUE" sourceName="VALUE"/>

        <layout xCoordinate="70" yCoordinate="30"/>

      </inputs>

    </viewNodes>

    <viewNodes xsi:type="View:JoinNode" name="Logical Join">

      <elements name="SUBJECT" aggregationBehavior="NONE" displayAttribute="false" hidden="false">

        <endUserTexts label="SUBJECT"/>

        <inlineType precision="10" primitiveType="VARCHAR" scale="0"/>

      </elements>

      <elements name="VALUE" aggregationBehavior="SUM">

        <endUserTexts label="VALUE"/>

        <inlineType precision="15" primitiveType="DOUBLE" scale="0"/>

      </elements>

      <inputs viewNode="//@view/@viewNodes.0">

        <mappings xsi:type="Type:ElementMapping" targetName="SUBJECT" sourceName="SUBJECT"/>

        <mappings xsi:type="Type:ElementMapping" targetName="VALUE" sourceName="VALUE"/>

        <layout xCoordinate="300" yCoordinate="200"/>

      </inputs>

    </viewNodes>

  </view>

</View:RootView>

Kind regards,

Raf

[RafkeMagic]

any "new" thoughts on this?