Hello,
I have a datasource in BW/4HANA 2.0 system that utilizes SDI (Postgre SQL Log Adapter) to bring data in Full mode. The issue is it takes a lot of time to load this data. So, I decided to use a selection/filter on fiscper. But to my surprise,...
Hello,
I'm trying to use PostgreSQL via HANA 2.0 SDI remote source into BW/4HANA 2.0. The adapter I have used is PostgreSQLLogReaderAdapter with Enable DDL Replication set to true.
Now, the remote source seems to be configured correctly as I can ...
Hello,
I have a very simple input-ready query. I want to take user input and save the data.
It works fine everywhere - BEx Analyzer, RSRT, Analysis for Office. But when I try to execute this on the portal using this menu bar navigation = Query D...
Update 12/12/2020: Code for following advanced cases added:
Multiple Hierarchies
Time Dependent Hierarchies
Multilevel Hierarchies
Duplicate Leaf Nodes
Prerequisites: You need some understanding of both, ABAP and how hierarchy in BW works, ...
Hi,
I need to write a custom planning function type that would copy data from one ADSO to another. Both the ADSOs are cube type. I need reference data as well.
Now, before copying some calculations have to be done on one of the key figures.
I k...
Link works fine, I double checked it. Try again please.Multiple Hierarchies + Time DependentThe code in the link above merges two concepts - Multiple Hierarchies and Time Dependency.Read the points below to understand what different is done in each c...
The problem was in PostgreSQL DB. They were using NCLOB datatype for all the fields in their tables. And a where clause on NCLOB datatype is not supported by HANA DB. Source: Data Types - SAP Help PortalIn fact, any datatype whose length is not speci...
Hi Ronald,Below is the SQL, and interestingly, I don't see a where statement in it.SELECT "/BIC/CMVZRXA_V_00001000001"."AAA","/BIC/CMVZRXA_V_00001000001"."BBB","/BIC/CMVZRXA_V_00001000001"."CCC",CAST("/BIC/CMVZRXA_V_00001000001"."CCC" AS numeric(7, 5...
