Bruce_yin的专栏

1. To use Data Services to load XML file to HANA1.1 log in the Data Services Designer- Down left-file-DTD-NEW- with the name STS MATERIAL MASTER LIST CAN be found in first line of DTD file.

Explain Plan is used to monitor the performance of the SQL statement1. execute the following SQL 2. execute the explain plan SQL3. check ther performance

SQL in hana

1.1 create an attribute view in contents-sts schema, add key attribute an attribute1.2. create a new level hierarchy1.3.1.41.5. save, validate and activate2. create an analytic view2.1

comfirm hana is connected:1 ping1.1. run cmd1.2. ping the IP of the machine2. Puttyhdbadm@cloudmdb -load-openinput password3.open hana studioright click -create system

1. create a view2. create a parameter table3. result of the parameter table4. create a result table5.6.create store precedure7. call store precedure

1. catalog2. select fromSelect companyname as company,cityname as city from sts.dimcustomerSelect * from sts.dimcustomeror select * (drag the table to the screen.)3.

1. Create Roles1. 1 log in as system Administrator-catalog- authorization -roles- create new roles- input role name- SQL privileges- add STS- right "select"-"no".1.2  create a user and granted rol

1. report wizard2.3.4.

1. open BO Explorer2. create a information space3. 4. give a name add measures and attributes5 Create index

1. create a user1.1. Open SAP hana stadio, catalog-authorization-user(right click)-create a new user. Type in the user name and password.then click "execute" . Then we have the user by refreshing  t

1. create a package1.1 right click content -new -package1.2 create attribute view-input name- select table and add-finish1.3 right click add as key attribute and add as attribute1.4 acti

3.3 DXC简介——HANA数据抽取和同步原创 2016-07-01 peng SAP同享汇DXC是SAP HANA DirectExtractor Connection的缩写，它是SAP HANA从SAP Business Suite中获取数据的一种简单方法。SAPHANA Direct Extractor Connection基于SAP Business Suit