Hi,
We migrated from SP11 (1.0.112) to HANA 2.0 SP2. Post migration, query with LEAD and SECONDS_BETWEEN function is behaving weird, infact incorrectly.
In my query, I calculate LEAD value of a SECONDDATE column and then find out days between SEC...
Hi All,Lets consider we have two tables as this.TABLE1TABLE2A script calculation view on these tables is created with below code.SELECT T1.T1C1, T1.T1C2, T2.T2C1, T2.T2C2, COUNT(DISTINCT T1.T1C1) AS DIST_COUNT FROM TABLE1 T1 LEFT OUTER JOIN T...
Hi All,I don't have access to few schemas in the system. But while creating models(AT/AN/CA) when I search for tables, I see tables from the schemas for which I don't have access. I'm able to add them, activate the model and view data as well. How ca...
Hi All,Currency conversion is failing with error message as below.SAP DBTech JDBC: [2048]: column store error: search table error: [2620] executor: plan operation failed;currency/unit conversion error,Conversion( "AMOUNT" ), row 0: could not determi...
Hi Fiona,
Yes, it will be inconsistent because the control comes out of CASE when a value for corresponding Period is found. This SQL should give you the desired results.
SELECT * FROM( SELECT "RYEAR", CASE WHEN "HSL01" <> 0 THEN ...
Hi All,
This is a known issue in 2.0 SPS20 and is resolved in 2.0 SPS21. Here the is the note.
https://launchpad.support.sap.com/#/notes/2529711
Thanks,
Chandra.
Hi Florian,Thanks for the quick reply. I cannot use Table1 alone as my other reports depend on Table2 as well. I need a single model on Table1 and Table2.My requirement is something like this - Lumira report with DISTINCT COUNT of VBELN from VBAK. Th...
Hi Varma,Yes it is because of granting SELECT WITH GRANT to _SYS_REPO. But we can't restrict access to _SYS_REPO by removing GRANT option(giving SELECT WITHOUT GRANT) because that user should have SELECT WITH GRANT for data preview to work. Issue is ...
