For a user familiar with modelling using Eclipse, modelling in HANA Studio can be quite relatable.

The new concepts would be about different data sources, views (Attribute, Analytic, Calculated) and how to use them in the right context.

Here are some commonly faced errors and I attempt to provide easy solutions for the same:

1. Error: “The reporting enabled view does not have a measure defined”

We usually see this when we try to activate an Analytic or Calculation View which has a set of tables added to it and several columns defined as output.

This means that the view has only been defined with dimensions and does not have any measure upon which the Analytics or Calculation can be performed.

This can be rectified by creating a new measure or a counter. To do so, right click on the calculated column and select “New calculated column” or “New counter”


Measures.png


2. Error: No Attribute has been specified as key

This error occurs when a Key Attribute has not been specified in an attribute view. Validation and Activation of the view fails in this case.

Key.png

3. Error: “Unable to preview the data since the view is either broken or inconsistent”

This error occurs when we try to do a Data Preview on the Analytic or Calculated view. The view has been validated and activated successfully. However we are not able to preview the data. This indicates there is a logical inconsistency in one of the input parameters/variables/measures that has been defined.

Although syntactically correct, there may be a wrong condition defined Ex: an incorrect filter condition chosen for a variable for which an expression has been defined.

4. Error: “SAP DBTech JDBC [259] (at 74): Invalid table name”

This indicates that the right table values are not being fetched for the condition/filter we are trying to specify. The solution may not be straight forward in this case. We can check if the table being used is the right one. If not, please get in touch HANA development support.


Input.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Mantri Shekar

    Hello Madam,

    Iam getting the first error onf your blog, i tried to create the Counter but it is not changed.Could you please help me to solve the issue

    Job Details .
    Job ID : JW5_Activation_DEV_9HKGCT5LPT7CT2G30UIWI9NLP_1444810310904
    Job Type : Activation
    System : JW5:LOCALHOST:01:SINGLEDB:DEV_9HKGCT5LPT7CT2G30UIWI9NLP
    Start Time : Wed Oct 14 13:41:51 IST 2015
    End Time : Wed Oct 14 13:42:30 IST 2015
    Elapsed Time : 38.407 Seconds
    Summary Report .
    Name Type Package Status Description
    SALESANDPROFIT Calculation View p1940962485trial.mantri Error .
    Detailed Report .
    • Execute validation rules
      • Validation of p1940962485trial.mantri::SALESANDPROFIT
        • No rule selected
    • Activation ID: 192844 (Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details)
      • Activation is performed with activation mode cascade two-phases.
      • p1940962485trial.mantri::SALESANDPROFIT
        • Internal deployment of object failed;Repository :  Encountered an error in repository runtime extension;Internal Error:Create Scenario failed: Mapped source attribute row.count is missing in node AGGR_AV_SALES(CalculationNode (Join_1) ->
          inputs ->
          input (AGGR_AV_SALES) ->
          mappings ->
          mapping (row_count))The following errors occured: Inconsistent calculation model (34011)Details (Errors):- CalculationNode (Join_1) ->
          inputs ->
          input (AGGR_AV_SALES) ->
          mappings ->
          mapping (row_count): Mapped source attribute row.count is missing in node AGGR_AV_SALES.- CalculationNode (Join_1) ->
          attributes ->
          attribute (row_count): Invalid datatype, length or/and scale are missing.- CalculationNode (finalAggregation) ->
          attributes ->
          attribute (row_count): Invalid datatype, length or/and scale are missing.<?xml version=”1.0″ encoding=”UTF-8″ standalone=”no”?>
          <cubeSchema defaultLanguage=”EN” defaultSchema=”_SYS_BIC” operation=”createCalculationScenario” version=”3″>
          <calculationScenario name=”p1940962485trial.mantri/SALESANDPROFIT” schema=”_SYS_BIC”>
          <dataSources>
          <analyticDataSource name=”AV_SALES” schema=”_SYS_BIC” view=”p1940962485trial.mantri/AV_SALES”>
          <variableMappings>
          <variableMapping dataSourceVariableName=”$$client$$” scenarioVariableName=”$$client$$”/>
          <variableMapping dataSourceVariableName=”$$language$$” scenarioVariableName=”$$language$$”/>
          </variableMappings>
          <attributes>
          <allAttribute />
          </attributes>
          </analyticDataSource>
          <tableDataSource name=”PRODUCT” schema=”NEO_8TFYEH9SVO7EP7ZFW7KNH4RTX” table=”PRODUCT”>
          <attributes>
          <allAttribute />
          </attributes>
          </tableDataSource>
          </dataSources>
          <calculationViews>
          <aggregation name=”AGGR_AV_SALES”>
          <attributes>
          <allAttribute />
          </attributes>
          <inputs>
          <input name=”AV_SALES”/>
          </inputs>
          </aggregation>
          <join name=”Join_1″ type=”inner”>
          <viewAttributes>
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”SALES_AMOUNT” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”PRODUCT_ID” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”row_count” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”REGION_ID” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”REGION_NAME” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”SUB_REGION_NAME” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”PRODUCT_NAME” />
          <calculatedViewAttribute name=”DISCOUNT” datatype=”int”>
          <formula>
          if(&quot;PRODUCT_NAME&quot; = &apos;Purse&apos;,20,10)</formula>
          </calculatedViewAttribute>
          <calculatedViewAttribute name=”NET_AMOUNT” datatype=”double”>
          <formula>
          &quot;SALES_AMOUNT&quot;-&quot;DISCOUNT&quot;</formula>
          </calculatedViewAttribute>
          </viewAttributes>
          <inputs>
          <input name=”AGGR_AV_SALES”>
          <mapping source=”SALES_AMOUNT” target=”SALES_AMOUNT”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          <mapping source=”row.count” target=”row_count”/>
          <mapping source=”REGION_ID” target=”REGION_ID”/>
          <mapping source=”REGION_NAME” target=”REGION_NAME”/>
          <mapping source=”SUB_REGION_NAME” target=”SUB_REGION_NAME”/>
          </input>
          <input name=”PRODUCT”>
          <mapping source=”PRODUCT_NAME” target=”PRODUCT_NAME”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          </input>
          </inputs>
          <joinAttributes>
          <joinAttribute excludeFlag=”false” name=”PRODUCT_ID” />
          </joinAttributes>
          </join>
          <aggregation name=”finalAggregation” defaultViewFlag=”true”>
          <inputs>
          <input name=”Join_1″>
          <mapping source=”REGION_ID” target=”REGION_ID”/>
          <mapping source=”REGION_NAME” target=”REGION_NAME”/>
          <mapping source=”SUB_REGION_NAME” target=”SUB_REGION_NAME”/>
          <mapping source=”PRODUCT_NAME” target=”PRODUCT_NAME”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          <mapping source=”row_count” target=”row_count”/>
          <mapping source=”SALES_AMOUNT” target=”SALES_AMOUNT”/>
          <mapping source=”NET_AMOUNT” target=”NET_AMOUNT”/>
          </input>
          </inputs>
          <viewAttributes>
          <viewAttribute name=”REGION_ID”/>
          <viewAttribute name=”REGION_NAME”/>
          <viewAttribute name=”SUB_REGION_NAME”/>
          <viewAttribute name=”PRODUCT_NAME”/>
          </viewAttributes>
          <keyfigures>
          <keyfigure name=”PRODUCT_ID” aggregationType=”sum”/>
          <keyfigure name=”row_count” aggregationType=”sum”/>
          <keyfigure name=”SALES_AMOUNT” aggregationType=”sum”/>
          <keyfigure name=”NET_AMOUNT” aggregationType=”sum”/>
          <keyfigure name=”row.count” datatype=”fixed” length=”18″ isVisible=”false” aggregationType=”count”/>
          </keyfigures>
          <unitConversionInfos>
          </unitConversionInfos>
          <calculationNodeHints countStarAttribute=”row.count”/>
          </aggregation>
          </calculationViews>
          <variables>
          <variable name=”$$language$$” typeMask=”512″ isGlobal=”true” usage=”optional”/>
          <variable name=”$$client$$” typeMask=”512″ isGlobal=”true” usage=”optional”/>
          </variables>
          </calculationScenario>
          </cubeSchema>
        • Model deployment started: p1940962485trial.mantri/SALESANDPROFIT timestamp: 2015-10-14,08:12:25.155
        • Removing BIMC records for p1940962485trial.mantri/SALESANDPROFIT timestamp: 2015-10-14,08:12:25.159
        • Removing hierarchy views for p1940962485trial.mantri/SALESANDPROFIT timestamp: 2015-10-14,08:12:25.210
        • Start deployment of graphical calculation view, timestamp: 2015-10-14,08:12:25.511
        • Calculation Scenario XML :  <?xml version=”1.0″ encoding=”UTF-8″ standalone=”no”?>
          <cubeSchema defaultLanguage=”EN” defaultSchema=”_SYS_BIC” operation=”createCalculationScenario” version=”3″>
          <calculationScenario name=”p1940962485trial.mantri/SALESANDPROFIT” schema=”_SYS_BIC”>
          <dataSources>
          <analyticDataSource name=”AV_SALES” schema=”_SYS_BIC” view=”p1940962485trial.mantri/AV_SALES”>
          <variableMappings>
          <variableMapping dataSourceVariableName=”$$client$$” scenarioVariableName=”$$client$$”/>
          <variableMapping dataSourceVariableName=”$$language$$” scenarioVariableName=”$$language$$”/>
          </variableMappings>
          <attributes>
          <allAttribute />
          </attributes>
          </analyticDataSource>
          <tableDataSource name=”PRODUCT” schema=”NEO_8TFYEH9SVO7EP7ZFW7KNH4RTX” table=”PRODUCT”>
          <attributes>
          <allAttribute />
          </attributes>
          </tableDataSource>
          </dataSources>
          <calculationViews>
          <aggregation name=”AGGR_AV_SALES”>
          <attributes>
          <allAttribute />
          </attributes>
          <inputs>
          <input name=”AV_SALES”/>
          </inputs>
          </aggregation>
          <join name=”Join_1″ type=”inner”>
          <viewAttributes>
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”SALES_AMOUNT” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”PRODUCT_ID” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”row_count” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”REGION_ID” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”REGION_NAME” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”SUB_REGION_NAME” />
          <viewAttribute ignoreFromInputsFlag=”false” isVisible=”true” name=”PRODUCT_NAME” />
          <calculatedViewAttribute name=”DISCOUNT” datatype=”int”>
          <formula>
          if(&quot;PRODUCT_NAME&quot; = &apos;Purse&apos;,20,10)</formula>
          </calculatedViewAttribute>
          <calculatedViewAttribute name=”NET_AMOUNT” datatype=”double”>
          <formula>
          &quot;SALES_AMOUNT&quot;-&quot;DISCOUNT&quot;</formula>
          </calculatedViewAttribute>
          </viewAttributes>
          <inputs>
          <input name=”AGGR_AV_SALES”>
          <mapping source=”SALES_AMOUNT” target=”SALES_AMOUNT”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          <mapping source=”row.count” target=”row_count”/>
          <mapping source=”REGION_ID” target=”REGION_ID”/>
          <mapping source=”REGION_NAME” target=”REGION_NAME”/>
          <mapping source=”SUB_REGION_NAME” target=”SUB_REGION_NAME”/>
          </input>
          <input name=”PRODUCT”>
          <mapping source=”PRODUCT_NAME” target=”PRODUCT_NAME”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          </input>
          </inputs>
          <joinAttributes>
          <joinAttribute excludeFlag=”false” name=”PRODUCT_ID” />
          </joinAttributes>
          </join>
          <aggregation name=”finalAggregation” defaultViewFlag=”true”>
          <inputs>
          <input name=”Join_1″>
          <mapping source=”REGION_ID” target=”REGION_ID”/>
          <mapping source=”REGION_NAME” target=”REGION_NAME”/>
          <mapping source=”SUB_REGION_NAME” target=”SUB_REGION_NAME”/>
          <mapping source=”PRODUCT_NAME” target=”PRODUCT_NAME”/>
          <mapping source=”PRODUCT_ID” target=”PRODUCT_ID”/>
          <mapping source=”row_count” target=”row_count”/>
          <mapping source=”SALES_AMOUNT” target=”SALES_AMOUNT”/>
          <mapping source=”NET_AMOUNT” target=”NET_AMOUNT”/>
          </input>
          </inputs>
          <viewAttributes>
          <viewAttribute name=”REGION_ID”/>
          <viewAttribute name=”REGION_NAME”/>
          <viewAttribute name=”SUB_REGION_NAME”/>
          <viewAttribute name=”PRODUCT_NAME”/>
          </viewAttributes>
          <keyfigures>
          <keyfigure name=”PRODUCT_ID” aggregationType=”sum”/>
          <keyfigure name=”row_count” aggregationType=”sum”/>
          <keyfigure name=”SALES_AMOUNT” aggregationType=”sum”/>
          <keyfigure name=”NET_AMOUNT” aggregationType=”sum”/>
          <keyfigure name=”row.count” datatype=”fixed” length=”18″ isVisible=”false” aggregationType=”count”/>
          </keyfigures>
          <unitConversionInfos>
          </unitConversionInfos>
          <calculationNodeHints countStarAttribute=”row.count”/>
          </aggregation>
          </calculationViews>
          <variables>
          <variable name=”$$language$$” typeMask=”512″ isGlobal=”true” usage=”optional”/>
          <variable name=”$$client$$” typeMask=”512″ isGlobal=”true” usage=”optional”/>
          </variables>
          </calculationScenario>
          </cubeSchema>
        • End deployment of graphical calculation view, timestamp: 2015-10-14,08:12:25.542
        • Model deployment ended: p1940962485trial.mantri/SALESANDPROFIT timestamp: 2015-10-14,08:12:25.542
    (0) 

Leave a Reply