HANA View used in SAP BW Datasource throwing error "transparent filter attribute".

Hi All,

SAP BW4HANA Std. stock overview report checked as external view for HANA is used as base view, on top of which Calculation view is created with some basic calculation,, when activating this view, got error related to "0calday<attribute name> not defined as transparent filter", and required corrections were done according to this note 2433799, when this HANA view is used in SAP BW datasource, similar error is witnessed as per below snapshot. When 0calday is unchecked in BW datasource, it is getting activated but we require 0calday to derive stock.

Same error shows when this HANA view is used in Open ODS view as well.

Can you please suggest to fix this issue.

Version: BW 7.5 SPS13

Error:

(PROJ1_U1): Attribute CALDAY defined as transparent filter attribute on child node U1, but not on parent node PROJ1_U1. " Message no. RSDD_HDB_INDEX000

CALDAY defined as transparent filter attribute on child node U1, but not on parent node PROJ1_U1,Details (Errors): - calculationNode Message no. RSDD_HDB_INDEX000

EC:2048"column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (PROJ1_U1): Attribute Message no. RSDD_HDB_INDEX000

stock-datasource-error.png

Thanks,

Mahesh