When creating new calculations with the FX transformation, in many cases DSP seems to get ‘lost’ in identifying the data type derived from the calculation.For example the expressionCASE WHEN EMAIL IS NULL THEN true ELSE false ENDis correctly identifi...
Hello,I have a loading process that is not working as expected. It has been done as many other processes are working correctly, but this one is not.The problem is that in the Data Monitoring, in the Remote Queries section, the parameterised SQL state...
“Life is really simple, but we insist on making it complicated.” - ConfuciusIn many occasions the experience of using the graphical views is ... frustrating.When trying to "simplify" the processes, they end up being complicated and it is difficult to...
I want to do this simple query to a REMOTE TABLE in GBQ, converting a string to decimal and filtering by timestamp:SELECT
ORDER_ID,
CAST(AMOUNT_STRING AS DECIMAL(18,2)) AS AMOUNT_DEC,
FROM <GBQ>
WHERE UPDATED_AT_TS > CAST('2024-01-01 00:00:00.000000...
In the Data Integration Monitor we can create statistics of the remote sources, but is there any way to see the results in DSP?I can't get access to the tables where the data is supposed to be stored.In "SYS". "DATA_STATISTICS" there are the fields t...
in DSP doing a data preview of the dimension (in view and in AM) you can see the Location field and its values, like POINT (7235766.90155 3895303.9634).In SAC I think that only the Map object can see and use the field.Regards,
Your steps are correct.1.- Create the Location field in a Dimension.2.- Associate the Dimension to the Fact3.- And in the Analytical Model select the association to the Dimension to publish its fields (including the Location).I don't understand why y...
I think that In HANA standar tables you will find only HANA DB Users (like created for Open SQL), but not the DSP Users (they don't access HANA with their own HANA DB user)As far as I know, the DSP task control views and the space audit are the only...
