Active Contributor
Member since ‎10-29-2011

User Statistics

  • 869 Posts
  • 119 Solutions
  • 1 Kudos given
  • 31 Kudos received

User Activity

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,Can we change owner of a schema to other user? Can you throw some light on this ?Regards,Chandra.
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...