Hello Experts,I need to find a maximum value for the column M2 for records 1 till 5, then from 2 till 6,then 3 till 7.... and i want to display the maximum value as adjacent column.How do i achieve it?Thanks,Vinoth
Hi,How do i assign an Analytic Privielge which is inside a package to a User using sql?The sql below doesnt work if the Analytic Privilege is inside a package. call GRANT_ACTIVATED_ANALYTIC_PRIVILEGE('AP',TESTUSER)regards,Vinoth
Hi Experts,I understand how row store and column store works, Im also aware we cant use row store in modeling for views. My question is if we cant model using the table why should we have them?. Is is possible to convert a row store table to column b...
Hi Experts,I wanted to know what happens behind when a table is added to data foundation of attribute view1. Is the entire table along with the tuples get loaded?2. Is just the structure of the table is loaded and not the tuples ?If second is correc...
I installed HDBODBC32 driver and connected to HANA DB using a DSN, then by using the DSN in my pyhton code i was able to access the DBHowever when i tried to give the connection information in the connections string itself without DSN im getting the ...
Hello, Where is the performance slowness at SAC level or at HANA level. you can do a data preview of the HANA calculation view in database explorer and there is hierarchies tab to drill down. Is the slowness observed at HANA level as well?regards,Vin...
Hello Anastasia,I assume this is what you wanted to achieve "You wanted to create a container copy but with a different schema name". If it is so you can follow the below steps1. Create and deploy your initial container2. Unbind the service from BAS3...
Hello Anastasia,Did you try the copy container procedure, as that is best approach ?https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/36a5547af0304ee29e964abf27468f52.htmlregards,Vinoth