HANA Composite Provider – new column with constant value

HANA Composite Provider – new column with constant value

SAP BW, SAP HANA
Till BW 7.5 SP7, there is no obvious way to add new column with constant value in a BW on HANA composite provider. Let’s take the example: as a source for composite provider, you are using HANA view where one of Key Figures is Amount. The value is in EUR currency and because the currency field is not in HANA view, you would like to add it on the composite provider to see currency on the report later. How to do that? One option: create calculated column in view, set the constant EUR value for that column. It’s easy, but then you are storing one additional column which is not needed in view. Second option: create new currency column and assign constant value on composite provider. The way of achieving…
Read More