Dear Experts,
Recently I'm struggling with an issue of loading data from CV to InfoObject hierarchy. Few years ago I was implementing this data flow on SAP BW on HANA, however I'm not able to reproduce steps. Here is what I did as of now:
1. Crea...
I know that there are bunch of question regarding XSC and XSA, but for me it is still quite confusing when to migrate to XSA.
As per SAP statement: SAP HANA Extended Application Services classic model (XS classic) and SAP HANA Repository are deprec...
Introduction
In my previous post (Split string into multiple rows using SQL in SAP HANA) I was demonstrating how to split variable string value into multiple lines. In this post I would like to focus on the similar scenario, but this time the challen...
Introduction
In this post I would like to describe options for splitting concatenated string into multiple rows using SQL in SAP HANA. Depending on which version of HANA system you are working you can choose the one which is valid.
Creating custom fu...
Introduction
In my previous post I demonstrated how to create Table Functions (TF) in SAP HANA XS Classic. One of the TF disadvantage, which I mentioned there was the fact, that they are not supporting multi-value input parameters – and this is offic...
The TO_DATE function is not used properly in your statement and that's why it returns an error. You should exclude the formatting 'MM/DD/YYYY'WHERE DAYS_BETWEEN (TO_DATE (T0."U_DFrom"), TO_DATE(T0."U_DTo"))Just make sure that columns U_DFrom and U_DT...
You can create a Calculated Column, which concatenates keys of PlGrpZ and Vorgang columns to generate the unique key:Then use the Label on top of compounded key column (CALC_KEY) instead of Vorgang field (which is not unique). Otherwise you need to k...
You could query your source object 12 times on Composite Provider level. For each instance you would need to add calculation for date to Add month (+1, +2...+11). Then for each instance, map this calculated date to your regular date field. Other colu...
Hi Loed,It is possible by creating a range on 0CURMEM_CALMONTH with the offset from 0CURMEM_CALMONTH - 1 to 0CURMEM_CALMONTH -12 .See the attached screenshot: