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
SAP HANA – data import from file

SAP HANA – data import from file

SAP HANA
In SAP BW instant data load from Excel or from CSV file is quite tiring, especially when it’s one time load for testing purposes or Proof of Concept. Fortunately in SAP HANA there is easy and convenient way of data import from file. Using Import Data from Local file you can: Import CSV or Excel files; Create new table as a target or use existing one. When you file is ready, to import it to SAP HANA using HANA Studio: 1. Select File – Import – SAP HANA Content – Data from Local File. 2. Choose target system where you would like to import data. 3. Choose source file (from computer). 4. Define file details (field delimiter, header row, start and end line). 5. Select existing target table or create…
Read More