SAP HANA TRAINING VIDEOS AT LOW CAST CAL ME 91- 8106855785

Overview and Architecture HANA

• What is HANA? High Performance Analytical Appliance - in the calculation engine memory
• In memory of the computer lab as a modeling interface and administration.
• HANA is connected to ERP systems, modeling Frontend studio can be used for the load control and management servers replication
• Two types of stores relational data in HANA: Online Store, Column Store
• The SAP tools bobj can directly report on HANA
• HANA data can also be used in MS Excel - MDX
• Line Store - Base traditional relational data. The difference is that all the lines are stored in HANA as where they are stored in a hard disk in traditional databases.
• store column - Data is stored in columns like SAP BWA
• Persistence layer: In the memory is great, but it is volatile and the data can be lost with a power failure or hardware failure. To avoid this component has a HANA persistence layer which ensures that all data in memory are stored in a hard disk that is not volatile.
• Session Management: This component supports connection services.
• Two processing engines - Well, the data is in memory that is good, but how do I extract / Data Report? HANA has two processing engines is based on SQL that accepts SQL queries and the other is based on MDX.
• Supports HANA Sybase Replication Server - Sybase Replication Server can be used for real-time synchronization of data between ERP and HANA
Modeling studio
Using modeling Studio, you can
• specify the tables are stored in HANA, the first part is to get metadata and then schedule jobs data replication
• Manage data services to load data from other third party systems and SAP BW.
• Manage connections to ERP instances, current version does not support the connection repeatedly ERP
• Using data services for modeling
• do modeling in HANA itself (This is independent of data services).
• You can also do modeling can also be done in the Business Objects universe is nothing but fact and dimensional tables join.


Relationship
• Client tools can directly access HANA, such as MS Excel, SAP 4.0 BI Reporting tools, tool design Dashboard (Xcelsius) can also be accessed directly HANA.
• third-party reporting tools can use ODBC, JDBC and ODBO (for applications MDX) drivers in HANA for reporting.
• Interface supports HANA BICS

Processing of applications and execution control
• Script SQL, MDX statements are passed to the model calculations.
• Optimizer is included in the calculation engine optimized for better performance.
• Calculation Engine:
o Modeler to define the sources of input data and the various operations (join, aggregation, projection) over them for data manipulation
o The calculation engine will break a model into sub-processes to optimize performance on the cost basis.
o Maximum use system resources to achieve maximum per set
• Motor planning: will be included in the next version. Include functions such as copying and distribution of planning functions.

ROW store
• A relational engines for storing data in rows.
o pure store memory (future versions will also be able to store on disk)
o object store memory (in the future) for the cache feature live
o Transactions memory version is at the heart of the store online
• The architecture of the store Row
o write operation will mainly "transactional memory version"
o INSERT also wrote persisted sector
o Moves the visible version from memory persisted sector
o Clears versions obsolete records in the memory version of the transaction
o store tables of lines have a primary index
o Row ID is the primary key
o The secondary indexes can be created
o Row contains the segment ID and the registration page
o clues in the online store only exist in memory
o definition of the index table stored with meta

Column store
• Improves reading significant feature also improves write functionality
• Data highly compressed
• No real, virtual file
• Optimization and Run - Handles requests and the implementation plan
• The Delta data for rapid writing
• Asynchronous Delta merger
• Consistent View Manager
• primary and read optimized tablet store - Data is read from the main store
• Delta Store - Write optimized - for write operations.
• Asynchronous merge move data store delta main store
• Compression dictionary by creating and implementing new methods of compression
• Even during the merger, the columnar table will always be available for reading and writing. To answer this, a second delta and main storage are used internally
• Merge operation can also be triggered manually with a SQL command

Persistence layer
• persistence layer is necessary that the main memory is volatile
• Provides backup and restore functionality
• A persistence layer takes care of both row and column stores
• Regular Save Points
• The capture logs DB transactions since the last save point


• Actions when restarting the system
o last checkpoint must be restored and logs cancellations must be read and uncommitted transactions recorded last save point and apply redo logs
o the full content of the memory row is loaded into the memory during the boot process
o The indicators can be defined to store column to specify the tables are loaded when the system is rebooted

Modeling
• Modeling only possible for tables column
• Information Modeler only works for table column
• The replication servers create tables in the store default column
• Data Services creates tables in the store default column
• SQL to create the table column: CREATE TABLE COLUMN
• Store has changed with ALTER TABLE
• The system tables are created where they are best suited
• SYS schema -> Administrative board engine
• tables server statistics
In-Memory Computing Studio
• Build with java based on Eclipse
• Navigator to access different systems HANA left Quick Launch View Properties for middle and bottom.
• Information Modeler Features:
o views database
o Choice publish and consume four levels of modeling
 to attribute analytically ...
o physical tables and information models
o import / export models, schemas of data sources, the massive and selective load
o landscapes
• The models are simple virtual definitions, they do not store the actual data
• Analytical Views are like cube model where transaction data is logged to assign view
• Calculation View - With the functions and custom calculations
Modeling process flow
o import metadata from the source system
o Create information models
o Consume with BICS, SQL or MDX
• Information Modeler Terminology
o attributes - Features
o Measurement - Key figures
o attributes Views - Dimensions
o analytical views - Cubes
o Calculation views - similar to the concept of virtual provider in BW
o hierarchies
 Leveled - based on multiple attributes
 parent-child hierarchy
Executive Privilege o - object security

• Navigation View
o example HANA -> name Hana server and instance number -> user schema database -> views functions and tables
o Information Models - Attribute, analytical calculation Views Analytic Privilege

• Attribute Overview:
o Attributes add context to the data
o The attributes are modeled using attributes views
o Can we consider that the Master Data tables
o can be linked to fact tables in analytical Views
o A measure such weight can be defined as an attribute
o The attached table and properties
 External left, right outer, external or full text table
 Cardinality 1:1, N: 1, 1: N
 Column language
• analytically:
o As for Cube
o analytical Views does not store any data. Data are stored in the table or column store a view based on the structure of the analytical vision
o The attributes and measures - as key figures
• Data Preview - Similar to the feature list of cube

• Calculation View:
o Define the structure of output table
o Write SQL statements
 Ensure that the selected fields corresponds to output structures previously defined
o unlike SQL Scripts SQL procedure can not change the data that are read-only

Other notes:
• External tools can connect to HANA using the JDBC and ODBC drivers
• HANA does not currently support full set MDX, it supports Excel 2010 standard MDX
• BWA equipment can be upgraded to HANA given that the material is relatively new
• BWA licenses can be transferred to HANA
• ERP and BW can be connected to HANA using data services or Sybase Replication
• No namespace concept in HANA at this time, so two ERP instances can not be connected to HANA. However, this problem can be avoided by using data sources
• CRM can also use HANA
• The data in BW HANA can be loaded in the use of data services and Info rays







Additional notes:
1) No aggregates where BWA is used. Only flexible views

2) The benefits of SAP NetWeaver BW on HANA:
a. Superior Performance Reporting
b. Access to real-time data
c. More simulate fast and plan
d. Loading superior performance
e. Simplified Maintenance
f. The flexibility of modeling
g. HANA optimized and InfoCube Data Store Objects (DSO)
h. Speeding through memory storage column
i. Reduces the administrative tasks of a lower TCO
j. Self-service access to all information
k. Minimal training or disruption
l. No disturbance W Application

3) SAP HANA is the only persistence layer for SAP Business Suite and SAP BW NW
4) Web Based Modeler called Composer information for business users to quickly create models
5) SAP HANA - Backup Recovery = Recovery Point-to-time.
6) Monitoring and Management of SAP HANA is enhanced with the integration of Solution Manager


7) SAP HANA SP3 Highlights:

a. End more flexibility
i) Based on Web Modeler (Composer information)
ii) improving the user interface

b. New options for deploying the landscape:
i) improved recovery backup
ii) simplified deployment

c. Extended Capability & Performance Calculation:
i) library business functions
ii) library predictive algorithm
iii) Improving Performance Loading

d. Additional assistance and monitoring capabilities:
i) The new tracing and debugging (in SAP HANA Model Studio)
ii) Monitoring and Administration (Integration Solution Manager)

e. Enhanced Security & Compliance:
i) to ensure the network connectivity
II) Comprehensive Income and user provisioning complaint
iii) audit improvements
iv) the license key



8) In-Memory Computing:
a. Row and Column Store
b. Compression
c. Partitioning
d. No aggregate tables
e. Insert only on Delta

9) SAP HANA In-Memory Computing can run 64 things (threads) in parallel
10) HANA = High Performance Analytical Appliance
11) SAP HANA modeling is based on Information Designer SBO ("Universe")
12) SAP HANA Open ANSI SQL 92 and MDX
13) SAP HANA for user marketing (CRM) = relies on the TREX / BWA technology for the analysis of data based on the perspective.
14) = SAP HANA real-time integration of OLTP and store "in-memory".
15) POS = Point of Sales Analysis
16) = IMP Platform In-Memory
17) = MPP Massively Parallel Processing
18) In-Memory Parallel: analytical models EDW production can be stored for agile modeling and reporting.
19) third data to third parties (POS, CDR) can be stored for agile modeling and reporting.

20) The landscape of the current system of SAP HANA:
a. In-Memory Parallel (now)  SAP HANA 1.0
b. Store primary data for BW (short term)  SAP HANA 1.5
c. New applications (short term)  SAP HANA 1.5
d. Real Time Data Feed (medium term)  SAP HANA 2.0
e. Consolidation of the platform (medium term)  SAP HANA 2.0

21) SAP HANA provides a calculation engine in memory with data compression that overcomes the challenge of managing ever increasing volumes of data

22) BI tools:
a. BO Analysis, edition for Microsoft Office = analysis of multidimensional data with Microsoft Office
User Experience (Microsoft Excel)
b. BO Analysis, edition for OLAP = multidimensional data analysis in an environment based on Web
c. BO Analysis, edition for application design environment = rich and intuitive design for construction
powerful applications of BI analysis and planning.
d. BO Crystal Reports = design well-formatted reports available target.
e. BO Web Intelligence Interactive = Adhoc reports
f. BO dashboards = visualize complex data easily interactive dashboards
g. BO Explorer = Search relevant information and direct data mining

23) Crystal Reports, Web Intelligence, dashboards SBOP are able to take advantage of hierarchies in reports, but lack the deep hierarchical capabilities.
24) SAP BO Explorer is available for the iPhone / Pad
25) A "what-if" scenario is the strength of SAP BO Dashboards.
26) a)  SAP ERP SLT (Replication Server) ---- (real-time replication)    SAP HANA SAP BO Introduction
b) SAP or non-SAP BPC  services / BODS data (Near Real-time Replication)    SAP HANA BO Presentation

1) HANA SAP System Landscape:
A) Sources of data:
i. SAP ERP
and ii. SAP Host Agent 7.20
iii. Sybase Replication Agent (HP, UNIX, SLEX, AIX)

B) LT System:
i. NW 7.02
ii. Add-on DMIS 2010_1_700

C) SAP HANA Appliance (SLES 11 SP1)
i. SAP HANA Database - Customers studio
ii. Charge Controller SAP HANA
iii. SAP Host Agent 7.20
iv. Sybase Replication Server 15.5 + ECDA

D) Workstations Administrator:
i. SAP HANA studio
ii. Customer bases SAP HANA data
iii. Data Services Designer
iv. Information Designer
v MS Excel 2010
vi. Web Access to BI Admin Tools

E) workstations of end users:
i. MS Excel 2010
ii. SAP HANA Customer Database 1.0
iii. Web Access for BI customers (1577128)

F) Data Services:
i. Data Services 4.0
and ii. Data Services Job Server
iii. Repository (shared with BOC)

G) BI-4.0:
i. BI Platform
and ii. BO Explorer
iii. BO Web Application Server
iv. BO Repository


2) SAP HANA Software Appliance:
a) SAP HANA SAP HANA studio = Charge Controller
b) Sybase Replication Server = SAP Host Agent
c) SAP HANA Customer database structure files = LM
d) SAP HANA Database = SAPCAR


3) SAP HANA Extended Enterprise Edition (For log-based replication)
i) Sybase Replication Agent
II) Sybase Replication Server
iii) SAP HANA charge controller (R / 3 support Source + R / 3 to SAP HANA load)

4) Replication Methods Overview:
a) Trigger-Based Replication
b) based replication ETL
c) based replication logs (files database  Log)

5) Replication Methods Overview:
a) Source of SAP ERP (Application Layer) Trigger-based replication system   SAP In-Memory Database
b) Source of SAP ERP (Application Layer) ETL based replication system   SAP In-Memory Database
c) Source System database (log file)  based replication newspaper  SAP In-Memory Database



CHANDRA:

1. In BO Webi report, if you want to retrieve data for a given year from HANA DB for optimization where is the best place to filter: WEBI query 2.HANA model 3.Universe 4.CMC
Years HANA MODEL

2. What BO is good tool for viewing
Years DASHBOARDS

3. What BO is good tool for formatted reports
CRYSTAL REPORTS years

1. What is the standard user administration activities HANA
Years <SYS> ADM - Administration database level
SYSTEM - Modeler Administration

2. If you want to retrieve more than 5000 records in the BO report which you make this setting?
Years Increase size Fet Array 5000. -> Not sure about that.

3. What are the benefits of HANA BOBJ?
Quick years SAP response time and non-SAP interfaces. Near real-time data.

4. The SQL script, there are three issues one of the questions is as follows:
What SQL script:
Abap command set running on the server ABAP applications
SQL commands run the server NETWEAVER
SQL commands pushed the logic of intensive data HANA DB
SQL commands pushed the logic of intensive customer data tools
Years together SQL commands pushed intensive logical data HANA DB

5. The calculation see three questions, for example: In what situation the point of view of computing is needed?
Years when we require complex logic that can not be delivered by attribute and analytical Views.

6. Data Services 3 questions
# 2 privileges analytical issues

10. What is the replication method is good for processing complex?
Years database replication ETL (Data Services)

11. Types of privileges -? All the above?
Years. system privileges, b) SQL privileges and C) Benefits analytical
a. System, the SQL privileges (Privileges Schema + Data Objects privileges)
b. ANALYTICAL privileges
c. PACKAGE privileges

12. Type privilege Dropping table
Years SQL privileges (Privileges schema + data object privileges)

13. Question on the descriptive mapping
I think you are referring to the mapping of the text. If a text following mapping is valid. -> 1:1 mapping, Column language is mandatory and must be SPRAS, join type is text Register

14. Business layer steps / semantic layer
Ans -> Create Package -> Create a relational connection -> Foundation create data -> Foundation publish data to the repository -> Create a business layer (universe) -> Publish business layer to the repository.

15. Input for analysis View 2 questions

16. issue that list used
Years, we use it to find objects affected by this model.

17. When importing a model view of the target system, How to activate the dependent objects?
Cascade Enable years

18. When you right-click the object that you have the option of
a cascade of function 2. When used 3. 4 according to the levels. function of history
Years Cascade function, when used, Hierarchy

19. The advantages of using different accelerators on HANA?
Years real-time data and faster data access

20. Type cardinality between the display and attribute tables of text?
1:1 years for text attached

21. Steps SLT
Ans -> DB Trigger -> Connection tables -> Read Module -> Controller Module -> Write Module -> HANA database

22. BOD and Hana connection steps
Years
a. Create a connection to an SAP target system in BODS
b. Import metadata in SAP BODS
c. Import SAP metadata BODS SAP HANA
d. Import SAP metadata - target structure SAP ERP Source table to table SAP HANA target
e. Creating a Data Flow task with BODS and 1:1 to load data into SAP HANA
f. Perform the work DBOS to load data into SAP HANA
g. Preview downloaded data in SAP HANA

23. What DB trigger
Only years relevant tables examined for DB recording
All relevant changes are shown in Table connecting
Replicated changes are removed from log tables
The recording and reproduction possible for all classes of table

24. What is the charge controller
Years Make mapping between HANA DB Structures and DB source system works
Provides the opportunity for conversion values ​​/ migration Provide scheduling options to determine the frequency of data replication

25. BW on HANA what are the steps: example: database migration, etc.
Years Copy and migrate DB convert cube information in memory

26. In the following one is for real-time replication with zero downtime: SLT, BODS, Sybase and something else
SLT years



27. Given the pattern for the HANA architecture and the question is what are the important basics of HANA data?
Years in memory calculation engine (shop row store column, persistent layer calculation / runtime, interfaces), studio memory calculation

28. With the API data replication ODP extractors that are available? 1. Output 2 extractors. extractors content companies etc ...
Years customers custom extractors approved by SAP, only then released extractors

29. Question on profitability analysis
ANS: CO-PA Accelerator


37. How can you measure the actual speed of a calculation in HANA DB, Ans: (3 answers required)
a) Prepare and execute the SQL statement
b) Use the data overview
c) Run WEBI
d) Run information from space, e0 track using python administration tool in TREX.

38. What tool for managing duplicate names Hana? ?
a. MDM
b. Data Service
c. SQL UNION

39. How do you ensure the quality of HANA
a. Use SQL Editors
b. Compare data with HANA_STATISTICS
c. Use process quality data service
d. Use Webi report
e. SLT use of very high quality
f. Compare ERP HANA data

40. What is the authentication method for Single Sign-on 1. LDAP 2.Keberos

Keberos

PARAM:

1. What are the benefits of implementing SAP HANA with SAP ERP?
a. Optimizing performance for operational reporting
b. Processing large volumes of data
c. Providing real-time analysis

2. What are the reasons to build a spreadsheet with a SQL script rather than the GUI
a) To use standard SQL functions not provided for in the modeler
b) To create reusable custom calculation functions

3. Which tool you can use to display the data calculation sight?
a) Overview of the Data
b) SQL Editor

4. You have created a report with sales data from SAP HANA and you want to check that the values ​​in the report are correct. With which of the following would you compare the balances on the report?
a) With the aggregated values ​​stored in SAP HANA

5. What technology supports true real-time replication of SAP ERP billiards and ammunition in a data base of SAP HANA? SAP landscape transformation (SLT)

6. Which of the following parameters are required to configure the server to import the SAP HANA studio?
Server Address Repository Name

7. Which component of the module execution control breaks the request into executable parties? Please choose the correct answer.
SQL Parser

8. What are the components of SAP IMCE 1.0 clients
a. IMCE ODBO 1.0
b. IMCE ODBC 1.0
c. JDBC 1.0 IMCE
d. IMCE SQLDBC 1.0

9. SAP HANA software is available is the following editions
a. Platform Edition
b. Enterprise Edition
10. Semantic Layer (UNX) is available for reports that the following reporting tools
a. Crystal Reports business, tables and WEBI

11. View calculation may contain the following elements:
a. Database tables
b. Attribute Views
c. Analytical views
d. Calculation Views

12. What is the default perspective of IMCE Studio? Administrator Console
13. How many types of export / import can be performed from HANA studio? a. 2 (client and server)
14. What is the default schema for the views activated?
a. _SYS_BIC

15. List based replication ETL? SBO Data Services (ETL Based)

16. What is SAP BO Analysis (BICS)?
a. MS Excel 2010
b. MS PowerPoint 2010

17. What universe is used for semantic layer business? Relational universe (BO)
Information design tool

18. Overview of the data is available with the following options?
a. Raw data
b. Different Values
c. Analysis

19. Identify replication services trigger the DB? Replication LT

20. Executive privilege can be assigned to assign View? Real

21. What is the operating system IMDB? SUSE Linux Enterprise Server 11 SP3

22. HANA Enterprise Server can be configured via the scale up or scale-out configurations. Real
23. Handling distributed system can not be maintained in HANA since it's just a company server? Wrong

24. What is the role in SAP TDMS SAP HANA? Used with replication LT

25. During a power outage HANA DB performs the following operations: Recovery log from the last save point and the failure time data

26. Select the appropriate authorization privileges to control the activation of views? Privilege Package

27. network authentication protocol is not necessary to access the HANA server? Wrong

28. User Reports clients can not be integrated with users IMCE? Wrong

29. The roles assigned to a user are also grantable to other users? Real

30. SSO users can not be created in HANA since it is an independent system for information models? Wrong

31. Administrators who prefer user controls and create roles schema? Privilege system

32. Without analytical Privilege, the data can be accessed from
a. Attribute Views
b. Analytical views
c. Calculation Views

33. Analytical privileges belong? _SYS_REPO

34. Private View Attributes attributes are used to attach the key attributes? Wrong

35. Following join types are possible to attribute?
• Join referential
• Inner Join
• outer join

36. persistence layer in HANA DB includes the following elements: Management & Logger

37. What section controls the processing of data in HANA DB? Transaction Manager

38. What tool is used to create universes for reporting dashboard? Information Design Tool (IDT)

39. OPD API for data replication is used in which the replication? Data Services 4.0

40. RFC connection is required to connect the server database replication HANA data: False

41. point of view of the management of the life cycle is used for: upgrade / updates to HANA studio

42. Modeler also provide a list of users / roles created in the system information? Wrong




43. Views available in Quick Launch information modeler are:
• Navigator
• When using List
• Job Log
• Properties

44. MDX rest: Multi Dimensional Expressions

45. file content can be accessed from the browser of the Administrator Console? Wrong

46. What table provides the mapping and allocation rules in replication SLT: IUUC_ASS_RULE_MAP

47. Transformation in replication SLT can be handled in the following ways:
• Base Event
• The basic setting

48. What tool Business Objects is used for data replication to Hana? Data Services Designer

49. The measures are: data that can be quantified and calculated

50. supply of data can be both the initial charge and replication: Real

51. What is the maximum number of lines by default forward data? 5000

52. The rules of analytical validation of view can be selected and deselected the "Managing Preferences"? Real

53. A package in a package can be created? Real

54. Information content delivered SAP models can be activated from? Mass copy

55. Auto-generates the documentation technical design document in the format of _______? . Pdf

56. What is the full form of HANA? SAP High Performance Analytical Appliance 1.0

57. What non-SAP SAP HANA can connect to?
• Oracle Enterprise
• IBM Informix

58. SAP BO Dataservices can connect to any system including OLTP DBMS and RDBMS? Real

59. Hierarchies with levels of hierarchy are supported due to the attribute? Real

60. SAP HANA SP03, it will be possible to suspend a table replication process and resume it later in time: True

61. What are the business benefits of ODP for non-SAP BW customers?
• Access extractors Business Suite without having to go through SAP NetWeaver BW
• It is not necessary for a stream of data and therefore ABAP ABAP program is not required to hold data



62. calculation engine performs the following operations:
• create joins at run time
• Create calculated measures and calculated attributes
• Calculate and perform calculations Views

63. For SAP BW to be powered by HANA, what are the main steps required?
• Upgrading SAP NetWeaver BW 7.3
• Migrating database (DBMS) for HANA DB

64. HANA optimized Infocubeshas the following characteristics:
• No dimension tables
• No high-Fact table
• They represent "flat structures"

65. LT replication "pattern" can be configured to support the extraction work as follows:
• Real Time
• Calendar by Interval
• Calendar by Time

66. For views of the attributes of time what types of calendars can be created?
• Gregorian Calendar
• Financial Calendar

67. Filter values ​​are assigned to the 'Data foundation "in the analytical view? Real

68. Procedures can be created with human Invoker only? Wrong

69. SAP Solution Manager is used to provide remote access to HANA Studio? Real

70. Security and authorization SAP HANA is required to maintain the following?
• Control access to objects / Views
• Security at the field level
• restrict access to information models

71. Prerequisites for running Crystal Enterprise reports?
• JDBC / ODBC interfaces
• relational universe

72. Which of the following cardinalities are supported for the attribute:
• 1: N
• N: 1
• 1:01

73. Is it possible to add tables later, after the analytical point of view is created? Real

74. Packages can be exported without affecting delivery units for exports server type? Wrong

75. "Migrate" Quick Launch is used for which of the following: multi lingual support

76. views of calculation can also be used as Business Reporting for? Real

77. to attribute provides information data base and can be used in any analytical view? Real

78. SAP HANA supports the analysis of "big data"? Real

79. SAP HANA IMDB supports multiple hosts in landspace system? Real

80. Composer of the information is a browser as the application for end users to create reports? Real


PAT Mataz:

The questions are like these and these are the easiest I remember:

1. Best practices when using sqlscript in HANA (HANA 1.0 Guide sqlscript) 2 Years required:
a) the cursor b) dynamic scenario c) Using the WHERE clause of updates and deletions, d) use any non-union union

2. Which option / tool do you use connectivity for reporting hierarchy
Years: MDX, other ODBC, JDBC options. ODBO

3. Another issue will be similar to the foregoing,
Years: Excel

4. Which transaction will be used to verify the relationship table
Years: SD11

5. How many tables of results are generated from a calculation for each session,
Ans: 1, 2,3,4 other options

6. For computing node that is used
Years: Projection, Union, there were other options

7. Functions of the control module in SLT
Answer: 2 responses were including writing HANA I'm not sure but I thought it was not right that the writing module is there.

8. Functions DB trigger (not logging table).
Answer: 2 responses were needed and I know that normally functions for both DB and forestry tables so was difficult.

9. You want to use a small lookup table in your model for the transformation of data
Years: column, table transparent table and cluster table online. I was not sure of it

10. How can you measure the actual speed of a calculation in a DB
Answer: (3 answers needed) a) write and execute the SQL statement b) Use the preview data, c) run Webi, d) Run information from space, e0 track using python tool administration within TREX (do not ask me what I got!)

11. Developers should not have access to production data
Answer: use customer data only in the production system, the use of simulated in the development system data (it is correct), but there was more

12. It was about as necessary as ROOSOURCE years

13. What tool for managing duplicate names Hana?


14. Extractor that T / A support via PDO API
Years: ROOATTR

15. Check the quality of HANA.
Answer: a) Use SQL editors, b) compare data with HANA_STATISTICS, c) process quality service usage data, d) Use WebI, e ratio) use SLT


Additional notes:
1. No content available in standard business HANA

2. For components that are available hierarchies in SAP HANA?
Hierarchies available only Excel and ODBO.

3. Can you import roles and security of ECC system to SAP HANA?
We can not import roles and security of ECC system for HANA

4. What SQL script?
SQL script is used for the purpose of computing and is a proprietary language.

5. TCODE to find the tables in SAP HANA?
T.Code: SD11

6. Web intelligence is used for operational reporting.

7. What is the soundtrack used for reporting dashboard tool?
XCelsius (interactive dashboards)

8. Why use Crystal Reports?
Crystal Report is to develop formatted reports such as P & L, Balance Sheet, etc.

9. What is CO-PA Accelerator?
COPA accelerator for profitability analysis.

10. In the table are the names Release Extractor added?
Release names extracted are added to the table ROOSATTR.

11. views column (attribute Views) are located in Schema_SYS_BIC,
Metadata is located in Schema_SYS_BI.

12. What is Metadata Manager? Located in the diagram _SYS_BI

13. What is the replication agent? SLT

14. What is the SQL parser?
To check the syntax

15. Why universe are used: additional security or deposited uniform names .. etc.

16. What ETL Server is used for the ECC system?
SLT use SAP server.

17. What is backup point?
Savepoints coherent states are independent of the database which can be loaded without reading the log volumes.

18. For complex logic and large volumes of data using the ABAP code.

19. For less volume, use RFC or BAPI or RFC_READ_TABLE used.

20. What is the foundation of data and logic?

21. What is a text to join? Years. 1:01 cardinal

22. For a description eg., SPRAS

23. What is the purpose of the active hierarchy = False and True = active hierarchy?

24. This is to save the sight and activate the view?

25. What is limited extent? instance.
Restrictive measures are used to filter the value based on user-defined rules for attribute values.

26. What is calculated measure? example
Calculated measures are defined on the basis of a combination of OLAP cube data, arithmetic operators, constants and functions. Ex total sales of a product
Data Types (decimals, numbers, etc.), field length, scale, aggregation defined in the properties (sum, min, max and number)

27. What is the private attribute?
Private attributes Private attributes are used for modeling and analytical views can not be used outside the
display. Private attributes are required to link to the subject area or attributes. Add private attributes
More information on the model. Private attribute selected from a database table


28. What is new in SAP HANA SPS3? - Overview ISAP HANA database for SAP Business Warehouse

• SAP HANA as a database for SAP BW 7.30
• Simple In The Persistence of Memory and Storage - All BW tables are in-memory objects
• New Data Optimized memory storing objects (with SAP BW 7.3 SP5)
• The New In-Memory DSO activation process
• New - handling interval numbers
• New InfoCubes optimized memory (with SAP BW 7.3 SP5)
• simplified design and indexing
• Faster loads of data and simplified modeling
• Motor Planning In-Memory
• Based on existing integrated planning (BW-IP)
• Press OLAP engine in the SAP HANA SAP BW ABAP layer
• Tools to migrate seamlessly BW basis underlying data to SAP HANA scheduling engine
• In memory operations as disintegration, copy, write-back
• Support BW - IP and use cases Business ByDesignapplication

29. Advantages: loads fast data (no DIMIDs)
• To reduce time by 80%.
• Dimensions are not physically
• easier and faster modeling of structural changes.
• All processes all requests and multi-vendor may remain unchanged
/ / ***********************************************
HANA examining Raana:
-------------------
use of the world, where would you use?

requirement for analytical view: table, view attribute

sys_repo ->

tzhana => security, authentication, authorization
backup and recovery = consultation document Arani> Settings
non-SAP ERP data extration HANA is made by BODS.
extracting data from

BICS = Business Intelligence Servies consumption

To create analytically, which is the minimum required for attributes?

/ / ************************************************ **************

Uma questions:

1. SAP BW on HANA SP1.3 implemented, what are the STEs should be done?
a. Migrate data in BW HANA
b. Create indexes in memory
c. Convert cubic info in the types of objects Hana.
d. ?

2. Backup and restore SAP standard?
a. Recovery Point-in-time
b. backup archive log files
c. retrieving information model
d.

3.History => monitors changes to objects using versions.?
4. User hich Hazor analytical view: table, view attribute

sys_repo ->

tzhana => security, authentication, authorization
backup and recovery = consultation document Arani> Settings
non-SAP ERP data extration HANA is made by BODS.
extracting data from

BICS = Business Intelligence Servies consumption

To create analytically, which is the minimum required for attributes?

sap hana interview questions