Overview and
Architecture of HANA
- What
is HANA ? –High
Performance Analytical Appliance - In memory computing engine
- In memory
computing studio as a frontend for modeling and administration.
- HANA is
connected to ERP systems,
Frontend modeling studio can be used for load control and replication server
management
- Two types of
Relational Data stores in HANA : Row Store, Column Store
- SAP
BOBJ tools can
directly report on HANA
- Data from HANA
can also be used in MS Excel - MDX
- Row Store – Traditional
Relational Database. The difference is that all the rows are in memory in
HANA where as they are stored in a hard drive in traditional databases.
- Column Store – The data is
stored in columns like in SAP BWA
- Persistence Layer : In memory is
great but it is volatile and data can be lost with power outage or
hardware failures. To avoid this HANA has a Persistence Layer component
which makes sure that all the data in memory is also store in a hard drive
which is not volatile.
- Session Management : This component
takes care of logon services.
- Two processing engines – Well, data is
in memory which is good but How do I extract/report on the data? HANA has
two processing engines one is based on SQL which accepts SQL queries and
the other one is based on MDX .
- HANA Supports
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 which
tables are stored in HANA, first part is to get the meta data and then
schedule data replication jobs
- Manage Data
Services to load the data from SAP BW and other 3rd party
systems.
- Manage
connections to ERP instances, current release does not support connecting
to several ERP instances
- Use Data
services to for the modeling
- Do modeling in
HANA itself (This is independent of Data services).
- You
can also do modeling can also be done in Business Objects
Universes which is nothing but joining fact and dimensional tables.
Reporting
- Client tools can
access HANA directly, Like MS EXCEL, SAP
BI 4.0 Reporting tools, Dashboard Design Tool
(Xcelsius) can also access HANA
directly.
- Third party
reporting tools can leverage ODBC, JDBC and ODBO (for MDX requests)
drivers in HANA for reporting.
- HANA
supports BICS
interface
Request Processing
and Execution Control
- SQL
Script, MDX statements are passed
to calculation models.
- Optimizer which
is included in calculation engine optimizes for better performance.
- Calculation
Engine :
- Modeler
can define data sources as inputs and different operations (join, aggregation,
projection) on top of them for data manipulation
- The
calculation engine will break up a model into sub processes for optimized
performance on cost based.
- System
will use maximum resources to achieve max through put
- Planning
Engine : Will
be included in next release. Will include planning functions like
distribute and copy functions.
ROW Store
- One of the
relational engines to store data in row format.
- Pure in-memory
store (Future versions will also have an option of disk based store)
- In memory
object store (in future) for live cache functionality
- Transactions Version Memory is
the heart of row store
- Row store
architecture
- Write operation
mainly go into "Transactional Version Memory"
- INSERT also
writes to persisted segment
- Moves visible
version from memory to persisted segment
- Clears outdated
record versions from Transactional Version memory
- Row Store tables have a primary
index
- Row ID maps to
primary key
- Secondary
indexes can be created
- Row ID contains
the segment and the page for the record
- Indexes in row
store only exist in memory
- Index
definition stored with table meta
Column Store
- Improves read
functionality significantly, also improves write functionality
- Highly
compressed data
- No real files,
virtual files
- Optimizer and
Executer – Handles queries and execution plan
- Delta data for
fast write
- Asynchronous
delta merge
- Consistent view
Manager
- Main store
compressed and read optimized – Data is read from Main Store
- Delta Store –
Write optimized – for write operations.
- Asynchronous merge move the data
from delta store to main store
- Compression by
create dictionary and applying further compression methods
- Even during the
merge operation, the columnar table will still be available for read and
write operations. To fulfill this, a second delta and main storage are
used internally
- Merge operation
can also be triggered manually with an SQL command
Persistence Layer
- Persistence
Layer is needed as Main memory is volatile
- Provides Backup
and Restore functionality
- One Persistency
Layer takes care of both row and column stores
- Regular Save
Points
- Logs capturing
DB transactions since last save point
- Actions during
system restart
- Last save point
must be restored plus undo logs must be read and uncommitted transactions saved with last save point
and apply redo logs
- Complete
content of row store is loaded into memory during start process
- Flags can be
set for column store to specify which tables are loaded during system
restart
Modeling
- Modeling only possible for Column
tables
- Information
Modeler only works for column tables
- Replication
servers create tables in column store per default
- Data Services
creates tables in column store per default
- SQL to create
column table: Create COLUMN TABLE
- Store can
changed with ALTER TABLE
- System tables
are create where they fit best
- Schema SYS
-> administrative table of
engine
- Tables
from statistics server
In-Memory Computing
Studio
- Build with java
based eclipse
- Navigator to
access different HANA systems on left, Quick Launch View at the middle and
Properties view at the bottom.
- Information
Modeler Features:
- Database views
- Choice to
publish and consume at 4 levels of modeling
- Attribute
view, analytic view ...
- Physical tables
and Information Models
- Import/export
models, data source schemas, mass and selective load
- Landscapes
- The models are
just virtual definitions they don't store actual data
- Analytic Views
are like cube model where Transaction Data is connected to attribute view
- Calculation View
– With custom functions and calculations
Modeling Process Flow
- Import Source
System Metadata
- Create
Information Models
- Consume using
BICS, SQL or MDX
- Information
Modeler Terminology
- Attributes –
Characteristics
- Measure – Key
Figures
- Attribute Views
– Dimensions
- Analytic Views
– Cubes
- Calculation
Views – Similar to Virtual provider concept in BW
- Hierarchies
- Leveled
– based on multiple attributes
- Parent-child
hierarchy
- Analytic
Privilege – Security Object
- Navigation View
- HANA instance
-> Hana server name and instance number -> user database schema
-> views functions and tables
- Information
Models – Attribute, Analytic, Calculation Views and Analytic Privilege
- Attribute View :
- Attributes add
context to data
- Attributes are
modeled using attributes views
- Can be regarded
as Master Data Tables
- Can be linked
to fact tables in Analytical Views
- A measure e.g.
weight can be defined as an attributes
- Table Joins and
properties
- Left
outer, right outer, full outer or text table
- Cardinality
1:1, N:1, 1:N
- Language
Column
- Analytic View:
- Similar to Cube
- Analytic Views
does not store any data. The data is stored in column store table or view
based on Analytical View structure
- Attributes and
Measures – Like key figures
- Data Preview –
Similar to list cube functionality
- Calculation
View:
- Define table
output Structure
- Write SQL
statement
- Ensure
the selected fields corresponds to previously defined output structures
- SQL Scripts unlike
SQL procedure can't change any data they are read only
Other Notes:
- External
tools can connect to HANA using JDBC and ODBC drivers
- HANA currently
doesn't support complete MDX set, it supports EXCEL 2010 standard MDX
- BWA Hardware can
be upgraded to HANA given that hardware 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 name space concept in HANA at this
moment, so two ERP instances can't be connected to HANA. However this
issue can be avoided using data sources
- CRM also can use
HANA
- Data from BW
into HANA can be loaded into using Data Services and Info spokes
Additional Notes :
1) No
Aggregates where BWA is used. Only flexible views
2)
Benefits
of SAP NetWeaver BW on HANA :
a. Superior
Reporting Performance
b. Real-Time
Data Access
c. Simulate
More and Plan Faster
d. Superior
Loading Performance
e. Simplified
Maintenance
f. Modeling
Flexibility
g. HANA
optimized InfoCube and Data Store Objects (DSO)
h. Acceleration
via In-Memory Column Storage
i. Reduced
admin tasks an lower TCO
j. Self-service
access to all information
k. Minimal
training or disruption
l. No
Disruption to W application
3) SAP
HANA is the only Persistence layer for SAP Business Suite and SAP NW BW
4) Web Based Modeler called as Information
Composer for business users to quickly build models
5) SAP
HANA – Backup Recovery = Point-in-time recovery.
6) Monitoring
and Administration in SAP HANA is improved through Solution Manager integration
7)
SAP
HANA SP3 Highlights :
a.
More
End User Flexibility
i)
Web Based Modeler (Information Composer)
ii)
User Interface improvements
b.
New
Landscape Deployment options :
i)
Enhanced back-up recovery
ii)
Simplified Deployment
c.
Extended
Calculation Capability & Performance :
i)
Business Function Library
ii)
Predictive Algorithm Library
iii)
Improved Loading Performance
d.
Further
Support & Monitoring Capabilities :
i)
New tracing and debugging (within SAP HANA
Model Studio)
ii)
Monitoring and Administration (Integration to
Solution Manager)
e.
Enhanced
Security & Compliance :
i)
Secure Network Connectivity
ii)
Comprehensive & complaint user
provisioning
iii)
Auditing Enhancements
iv)
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 execute 64 things (threads) in parallel
10) HANA
= High Performance Analytical Appliance
11) SAP
HANA Modeling is based on SBO Information Designer (“Universe”)
12) SAP
HANA has Open Full ANSI 92 SQL and MDX
13) SAP
HANA for Marketing Users (CRM) = Leverages TREX/BWA technology to conduct
analysis on prospect Master Data.
14) SAP
HANA = Real-time integration of OLTP and “In-Memory” store.
15) POS
= Point of Sale Analysis
16) IMP
= In-Memory Platform
17) MPP
= Massive Parallel Processing
18) In-Memory
in Parallel : Analytic models from Production EDW can be brought into memory
for agile modeling and reporting.
19) Third
Party Data (POS, CDR) can be brought into memory for agile modeling and
reporting.
20) Today’s
System Landscape of SAP HANA :
a. In-Memory
in Parallel (Now) Ã SAP HANA 1.0
b. Primary
Data Store 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. Platform
Consolidation (Medium term) Ã SAP HANA 2.0
21) SAP
HANA delivers an In-Memory Calculation Engine with Data Compression that
overcomes the challenge of handling ever increasing data volumes
22) BI Tools :
a. BO
Analysis , edition for Microsoft Office = Multidimensional data analysis with
Microsoft Office
user
experience (Microsoft Excel)
b. BO
Analysis, edition for OLAP = Multidimensional data analysis within a web-based
environment
c. BO
Analysis, edition for Application Design = Rich and Intuitive design
environment for building
powerful
analytical and planning BI applications.
d. BO
Crystal Reports = Design well-formatted, layout-focused reports.
e. BO
WEBI = Adhoc Interactive Reporting
f. BO
Dashboards = Visualize complex data easily with interactive dashboards
g. BO
Explorer = Search relevant information and direct exploration of data
23) Crystal
Reports, WEBI, SBOP Dashboards are able to leverage hierarchies in reports but
are lacking deep hierarchial 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 Ã
Presentation
b) SAP BPC or Non-SAP Ã Data Services/BODS (Near
Real-time Replication) Ã SAP
HANA Ã BO Ã Presentation
1) SAP
HANA System Landscape :
A) Data Sources :
i. SAP
ERP
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 – Clients Studio
ii. SAP HANA Load Controller
iii. SAP Host Agent 7.20
iv. Sybase Replication Server 15.5 + ECDA
D) Admin Workstations :
i. SAP HANA Studio
ii. SAP HANA database
clients
iii. Data Services
Designer
iv. Information Designer
v. MS Excel 2010
vi. Web Access to BI
Admin Tools
E) End Users Workstations :
i. MS
Excel 2010
ii.
SAP HANA Database Clients 1.0
iii. Web Access to BI Clients
(1577128)
F) Data Services :
i.
Data Services 4.0
ii. Data Services Job Server
iii. Repository (shared with BOC)
G) BI-4.0 :
i. BI
Platform
ii.
BO Explorer
iii. BO Web Application Server
iv. BO Repository
2) SAP
HANA Appliance Software :
a)
SAP HANA Studio
= SAP HANA Load Controller
b) Sybase Replication Server = SAP Host Agent
c)
SAP HANA Database Clients = LM Structure Files
d)
SAP HANA Database =
SAPCAR
3) SAP
HANA Enterprise extended edition : (For
Log based replication)
i) Sybase Replication Agent
ii) Sybase Replication Server
iii) SAP HANA Load Controller (R/3 Load in Source
+ R/3 Load in SAP HANA)
4) Replication
Methods Overview :
a)
Trigger-Based Replication
b) ETL-Based Replication
c) Log-Based Replication (Database Ã
Log File)
5) Replication
Methods Overview :
a)
Source System-SAP ERP (Application Layer) Ã Trigger Based
Replication à SAP In-Memory
Database
b)
Source System-SAP ERP (Application Layer) à ETL Based Replication à SAP In-Memory Database
c)
Source System-Database (Log File) à Log Based Replication à SAP In-Memory
Database
CHANDRA :
1.
In a BO WEBI report, if you want retrieve data for a particular
year from HANA DB, for optimization where is the best place to filter: WEBI query
2.HANA Model
3.Universe 4.CMC
Ans
HANA MODEL
2. Which BO Tool is good for visualization
Ans
DASHBOARDS
3. Which BO tool is good for Formatted reports
Ans CRYSTAL REPORTS
1.
What is the standard user for HANA
admin activities
Ans
<SYS>ADM -- Database level administration
SYSTEM -- Modeler administration
2.
If you want to retrieve more than
5000 records in the BO report where do you do this setting?
Ans
Increase the Array Fet size to 5000. --> not sure about it.
3.
What are the benefits of BOBJ on
HANA?
Ans
quick response time SAP and NON SAP interfaces. Near real time data.
4.
On SQL SCRIPT there are 3 questions
one of the question is like this:
What is SQL SCRIPT:
Set of abap commands run on ABAP application server
Set of sql commands run NETWEAVER server
Set of sql commands pushed intensive data logic to HANA DB
What is SQL SCRIPT:
Set of abap commands run on ABAP application server
Set of sql commands run NETWEAVER server
Set of sql commands pushed intensive data logic to HANA DB
Set of sql commands pushed intensive data logic to client
tools
Ans
Set of sql commands pushed intensive data logic to HANA
DB
5.
On calculation view 3 questions for
example: In what situation the calculation view is required?
Ans
When we require complex logic that cant be delivered by Attribute and
Analytical Views.
6.
Data Services 3 questions
#Analytic Privileges 2 questions
#Analytic Privileges 2 questions
10. What replication method is good for complex transformation?
Ans
ETL base Replication ( Data Services )
11.
Types of privileges - ????? All of the ABOVE???
Ans a.
SYSTEM Privileges, b) SQL Privileges & c) Analytic Privileges
a.
System, SQL Privileges (Schema Privileges + Data Objects
Privileges)
b.
ANALYTIC
Privileges
c.
PACKAGE
Privileges
12.
Type of privilege for Dropping
Table
Ans SQL Privileges
(Schema Privileges + Data Object Privileges )
13.
Question about Descriptive Mapping
I think, you are referring to Text
Mapping. If it is text mapping following are valid. --> 1:1 mapping,
Language Column is mandatory and should be SPRAS, Join type is Text Join
14. Business Layer steps/ Semantic Layer
Ans --> create Package -->
Create Relational Connection --> Create Data Foundation --> Publish Data
Foundation to Repository --> Create Business Layer ( universe) -->
Publish Business Layer to Repository.
15.
Input for analytic view 2
questions
16.
question on where used list
Ans we use this to find objects affected
by that model.
17.
When import a model view to target
system, How to activate the dependent objects?
Ans Cascade Activate
18.
When you right Click the object you
have the Option to
a
Cascade function 2. Where used 3. Hierarchy function 4. History function
Ans Cascade Function , Where Used, Hierarchy
19.
Benefits of using different
accelerators on HANA?
Ans Real time data and faster data access
20.
Type of cardinality between
attribute view and text tables?
Ans 1:1 for text joins
21.
SLT steps
Ans -->DB Trigger
--> Logging Tables --> Read Module --> Controller Module --> Write
Module --> HANA data base
22.
BODS and Hana connection steps
Ans
a.
Create a connection to an SAP Target System in BODS
b.
Import SAP Metadata into BODS
c.
Import SAP Metadata from BODS into SAP HANA
d.
Import SAP Metadata – Target structure from SAP ERP Source Table to the SAP HANA Target
Table
e.
Create a BODS job and dataflow with 1:1 to load data into SAP
HANA
f.
Execute the job in BODS to load data into SAP HANA
g.
Preview uploaded data in SAP HANA
23.
What is DB trigger
Ans Only relevant tables considered for DB
recording
All relevant changes are recorded in
logging table
Replicated changes are deleted from
logging tables
Recording and replication possible
for all table classes
24.
What is Load Controller
Ans
Ensure mapping between HANA DB Structures and DB Structures of source
system
Provides ability to conversion/migration values Provide scheduling options to determine the frequency of data replication
Provides ability to conversion/migration values Provide scheduling options to determine the frequency of data replication
25.
BW on HANA what are the steps:
example: Database migration etc.
Ans
Copy and Migrate the DB convert the info cube to IN memory
26.
In the following which one is for
real time replication with zero downtime: SLT, BODS, Sybase and some other
thing
Ans
SLT
27.
Given the HANA Architecture view
diagram and the question is what are the important components of HANA database
?
Ans In-memory computing engine ( Row store, column
store, persistent layer, calculation/Execution engine, interfaces), In-memory
computing studio
28.
With ODP data replication API what
extractors are available? 1. Released extractors 2. Business content extractors
etc…
Ans
Customers customized extractors approved by SAP, so only Released
Extractors
29.
Question on profitability analysis
ANS: CO-PA accelerator
37. How can you evaluate the actual
speed of a calculation within HANA DB, Ans: (3 answers needed)
a) Write and execute
SQL statement
b) Use data preview
c) Execute WEBI
b) Use data preview
c) Execute WEBI
d) Execute
information space view, e0 trace using python admin tool within TREX.
38.
What tool to handle duplicate names of HANA? ???
a.
MDM
b.
Data Service
c. UNION SQL
c. UNION SQL
39. How do you verify the
quality of HANA
a. Use SQL Editors
b. Compare data with HANA_STATISTICS
c. Use data service quality process
d. Use WEBI report
e. Use SLT to very quality
f. Compare ERP with HANA data
a. Use SQL Editors
b. Compare data with HANA_STATISTICS
c. Use data service quality process
d. Use WEBI report
e. Use SLT to very quality
f. Compare ERP with 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. Performance Optimization for operational reporting
b. Processing of large volumes of data
c. Provision of real-time analytics
2. What are the reasons for building a calculation view with SQL script rather than the graphical
interface
a) To reuse standard SQL functions not provided within the
modeler
b) To create custom reusable calculation functions
3. Which tool can you use to preview calculation view data?
a) Data Preview
b) SQL Editor
4. You have created a
balances report with data from SAP HANA and want to check that the values on the report are correct. With which of the following would you compare the balances on the report?
a)
With the aggregate values stored in
SAP HANA
5.
Which technology supports true
real-time replication of SAP ERP Pool
and Cluster tables in an SAP HANA database? SAP Landscape Transformation (SLT)
6.
Which
of the following settings are mandatory
for configuring the import server in the SAP HANA studio?
Server Address Repository name
7.
Which
component of the Execution Control module breaks
the query into executable parts?
Please choose the correct answer.
SQL Parser
8.
What
are the components of SAP IMCE Clients
1.0
a. IMCE
ODBO 1.0
b. IMCE
ODBC 1.0
c. IMCE
JDBC 1.0
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 reporting by which of the following reporting tools
a.
Crystal Reports Enterprise, Dashboards & WEBI
11.
Calculation View can
contain the following:
a. Database
Tables
b. Attribute Views
c. Analytic Views
d. Calculation Views
12. Which is the default
perspective of IMCE Studio?
Administrator Console
13. How many types of Exports/Imports can be performed from HANA
studio ? a. 2 (Client & Server)
14. Which is the default schema for activated views?
a.
_SYS_BIC
15. List out the ETL based
replication? SBO Data Services
(ETL Based)
16. What constitute SAP
BO Analysis (BICS)?
a.
MS Excel 2010
b.
MS Powerpoint 2010
17. Which universe is used for Semantic Business
Layer? Relational Universe (BO)
Information Designer Tool
18. Data preview is available with the following options?
a. Raw Data
b. Distinct Values
c. Analysis
19. Identify the DB trigger Replication services? LT Replication
20. Analytic privilege can be assigned to Attribute View? True
21. What is the Operating System of IMDB ? SUSE Linux Enterprise Server 11 SP3
22. HANA Enterprise Server can be configured via Scale up or
Scale out configurations. True
23. Distributed system handling cannot be maintained in HANA
since it’s just one Enterprise server ?
False
24. What is the role SAP
TDMS in SAP HANA? Used with LT
Replication
25. During power outage HANA DB performs the following : Recovering log between last data savepoint
and time of failure
26. Select the correct Authorization privileges for controlling
activation of views ? Package Privilege
27. Network authentication protocol is not required for HANA
server access ? False
28. Reporting client users cannot be integrated with IMCE users
? False
29. Roles assigned to a user are also grantable to other users
? True
30. Single sign on users cannot be created in HANA since it is an
independent system for Information models ? False
31. Which privilege controls User Admin & Create
Schema roles ?System Privilege
32. Without Analytic
Privilege, no data can be viewed from
a. Attribute Views
b. Analytic Views
c. Calculation Views
33. Analytic Privileges belong to ? _SYS_REPO
34. Private attributes from the Attribute views are used to join
to the Key attributes ? False
35. Following types of
joins are possible in Attribute view?
·
Referential Join
·
Inner Join
·
Outer Join
36. Persistence layer in the HANA DB has the following components
: Page Management & Logger
37. Which section controls the data processing in the HANA DB
? Transaction Manager
38. Which tool is used to create Universe for reporting in
dashboard ? Information Design Tool
(IDT)
39. OPD for data replication API is used in which replication
? Data Services 4.0
40. RFC connection is
required for connection from Replication server to HANA Database : False
41. Life cycle management perspective is used for : Upgrade / Updates for HANA Studio
42. Information modeler also provide list of Users/Roles created
in the system ? False
43. Views available in the Quick launch of Information modeler
are:
·
Navigator
·
Where-Used List
·
Job Log
·
Properties
44. MDX stand for : Multi
Dimensional Expressions
45. Content folder can be accessed from the Navigator of the Administrator
console ? False
46. Which table provides the mapping & assignment of rules in
the SLT replication : IUUC_ASS_RULE_MAP
47. Transformation in SLT replication can be handled in the
following ways:
·
Event Based
·
Parameter Based
48. Which Business Objects tool is used for replicating data to
HANA ? Data Services Designer
49. Measures are : Data that can be quantified and calculated
50. Data provisioning can be both initial load and
replication : True
51. What is the default maximum number of rows in Data preview
? 5000
52. Validation rules of Analytic View can be selected &
de-selected from the ‘Manage Preferences’? True
53. A Package within a package can be created? True
54. SAP delivered content Information models can be activated
from? Mass Copy
55. Auto-documentation generates technical design document in the
_______format? .pdf format
56. What is full form of HANA?
SAP High Performance Analytical Appliance 1.0
57. Which non-SAP system can SAP HANA connect to ?
·
Oracle Enterprise
·
IBM Informix
58.
SAP BO Dataservices can connect to any OLTP system including
DBMS &RDBMS ? True
60. In SAP HANA SP03 it will be possible to suspend a table from
the replication process and to resume it a later point in time : True
61. What are the business
benefits of ODP for non SAP BW customers?
·
Get access to the Business
Suite Extractors without having to go through SAP NetWeaver BW
·
There is no need for an ABAP
Dataflow and therefore no ABAP Program is required for staging data
62. Calculation engine performs the following:
·
Create Joins at run-time
·
Create Calculated Measures
and Calculated Attributes
·
Compute and Execute
Calculation Views
63. For SAP BW to be
powered by HANA, what are the primary
steps required?
·
Upgrade to SAP NetWeaver BW
7.3
·
Migrate Database (RDBMS) to
HANA DB
64. The HANA optimized
Infocubeshas the following features:
·
No Dimension Tables
·
No Secondary Fact-Table
·
They represent “Flat
Structures”
65. LT replication “Schema”
can be configured to support extraction jobs as follows:
·
Real Time
·
Schedule by Interval
·
Schedule by Time
66. For Time Attribute
views, which calendar types can be created?
·
Gregorian Calendar
·
Fiscal Calendar
67. Filter values can assigned at the ‘Data foundation’ in the Analytic
view ? True
68. Procedures can be created with Invoker’s rights only ? False
69. SAP Solution Manager is used to provide remote
access to HANA Studio? True
70. Security & Authorization of SAP HANA is required to
maintain the following?
·
Control Access to
Objects/Views
·
Field-Level Security
·
Restrict users from viewing
Information Models
71. Pre-requisite to execute Crystal
reports enterprise?
·
JDBC / ODBC Interfaces
·
Relational Universe
72.Which of the following cardinalities are supported in
Attribute view:
·
1:N
·
N:1
·
1:1
73. Is it possible to add tables later after the Analytic view is
created ? True
74. Packages can be exported without assigning Delivery units for
Server type exports ? False
75. ‘Migrate’ from Quick launch is used for which of the
following: Multi Lingual Support
76. Calculation views can also be used as business reporting view ? True
77. Attribute view provides the master data information & can
be used in any analytic view ? True
78. SAP HANA supports ‘BIG’
data analytics ? True
79. SAP HANA IMDB supports multiple hosts within the system landspace ? True
80. Information Composer is a browser like application for End-users to create
reports ? True
PAT
MATAZ :
Questions are like these and these
are the easier ones which I remember:
1.
Best practices when using sqlscript
in HANA (HANA 1.0 sqlscript guide) , 2 Ans required from:
a)
cursor, b) dynamic script c) Using
where clause for updates and deletes, d) use union all not union
2.
Which tool/ connectivity option do
you use for hierarchy reporting
Ans:
MDX, other options ODBC, JDBC. ODBO
3.
Another question will be similar to
the above,
Ans:
Excel
4.
Which transaction will be used to
check the table relationship,
Ans: SD11
5.
How many result tables are generated
from one calculation view per session,
Ans:
1, other options 2,3,4
6.
In a calculation view which node is
used
Ans:
Projection, Union, there were other options
7.
Functions of the controller module
in SLT
Ans:
2 answers were required including writing to HANA which I am not sure but
thought it was not correct as the write module is there.
8.
Functions of DB trigger (not logging
table).
Ans: 2 answers were needed and I normally know
the functions for both DB and logging tables so was tricky.
9.
You want to use a small look-up
table in your model for data transformation
Ans:
Columnar table, Transparent table, cluster table and row table. I wasn't sure
of this one
10.
How can you evaluate the actual
speed of a calculation within a DB,
Ans: (3 answers needed) a) write and execute
SQL statement, b) Use data preview, c) execute Webi, d) Execute information
space view, e0 trace using python admin tool within TREX (don't ask me what I
picked!)
11.
Developers should not have
access to production data,
Ans:
use client data only in production system, use simulated data in development
system (these were the correct answers) but there were more
12.
There was question which needed ROOSOURCE
as ans
13.
What tool to handle duplicate names
of HANA?
14. Which extractor T/A
support through ODP API
Ans: ROOATTR
15.
Verify the quality of HANA.
Ans: a) Use sql editors, b) compare
data with HANA_STATISTICS, c) use data service quality process, d) use webi report, e) use SLT
Additional Notes :
2.
To which components are Hierarchies
available in SAP HANA ?
Hierarchies only
available Excel and ODBO.
3.
Can you import Roles and Security
from ECC System to SAP HANA ?
We CANNOT import roles and security from ECC system to HANA
4.
What is SQL Script ?
SQL script is used for calculation
view 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 BO Tool used for
Dashboard Reports ?
XCelsius (For Interactive
Dashboards)
8.
Why are Crystal Reports used ?
Crystal Report is for developing formatted reports like P & L,
Balance sheet, etc.
9.
What is CO-PA Accelerator ?
COPA accelerator is for
Profitability analysis .
10.
To which Table are the Release Extractor Names added ?
Release extractor names are added to
the ROOSATTR Table.
11.
Column views(Attribute Views) are
located in Schema_SYS_BIC,
Metadata is located in Schema_SYS_BI
.
12.
What is Metadata Manager? Located in
Schema _SYS_BI
13.
What is Replication Agent ? SLT
14.
What is SQL parser ?
For Syntax check
15.
Why universes are used : additional
security or filed names uniform ..etc
16.
What ETL Server is used for
ECC system ?
Use SAP SLT server.
17.
What is SAVE POINT ?
Save points are
self-contained consistent states of the database that may be loaded without
reading the log volumes.
18.
For complex logic and large volumes of data use ABAP code.
19.
For less volume use RFC or BAPI or RFC_READ_TABLE used.
20.
What is Data Foundation and Logical View ?
21.
What is a Text join ? Ans. 1:1
cardinality
22.
To get the Description eg., SPRAS
23.
What is the purpose of Hierarchy
Active = False and Hierarchy Active = True ?
24.
What is SAVE the view and Activate
the View ?
25.
What is Restricted Measure ?
example.
Restricted measures are used to filter the
value based on the user-defined rules for the attribute values.
26.
What is Calculated Measure ? example
Calculated measures are defined based
on a combination of data from OLAP cubes, arithmetic operators, constants, and
functions. Ex the total sales of a product
Data
Types (decimals, numbers etc), Field Length, Scale, Aggregation defined in
properties (sum, min, max and count)
27.
What is Private Attribute ?
Private
Attributes : Private attributes are used to model analytic views and cannot be
used outside the
view.
Private attributes are required to link to the subject area or attribute views.
Private attributes add
more information to 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 database for SAP BW 7.30
·
Single
In Memory Persistence and Storage - All BW tables are In-Memory objects
·
New
In-memory optimized Data Store Objects (with SAP BW 7.3 SP5)
·
New
In-Memory DSO activation process
·
New
- Number Range handling
·
New
In-memory optimized InfoCubes(with SAP BW 7.3 SP5)
·
Simplified
design and indexing
·
Faster
data loads and simplified modeling
·
In-Memory
Planning engine
·
Based
on existing Integrated Planning (BW-IP)
·
Push
down of OLAP engine into SAP HANA from SAP BW‘s ABAP layer
·
Tools
to seamlessly migrate BW underlying database to SAP HANA Planning Engine
·
In
Memory operations like Disaggregation, copy, write-back
·
Supporting
BW – IP and Business ByDesignapplication use cases
29.
Benefits : Fast data loads (no DIMIDs)
·
Upto
80% time reduction.
·
Dimensions
not physically present
·
Simpler modeling and faster structural changes.
·
All
processes, all Queries and Multi Providers can remain unchanged
//***********************************************
From Raana's HANA
exam:
-------------------
use of the universe,
where do you use it?
requirement for the
analytic view: table, attribute view
sys_repo ->
tzhana =>
security, authentication, authorization
back up and recovery
=> Param's Arani consulting document
non-sap erp data
extration to HANA is done by BODS.
extraction of data
from
BICS = Business
Intelligence Consumer Servies
To create analytic
view, what is the minimum requirement for the attributes?
//**************************************************************
Questions by Uma:
1. SAP BW implemented
on HANA SP1.3, what are the stes need to be done?
a.
Migrate
the BW data into HANA
b.
Create
In-memory Indexes
c.
Convert
Info cubes into HANA object types.
d.
???
2. Backup and
recovery by SAP standard?
a. point-in-time recovery
b. backing up of archived log files
c. information model recovery
d.
3.History => keeps
track of object changes using the versions.???
4. hich user hasor
the analytic view: table, attribute view
sys_repo ->
tzhana =>
security, authentication, authorization
back up and recovery
=> Param's Arani consulting document
non-sap erp data
extration to HANA is done by BODS.
extraction of data
from
BICS = Business
Intelligence Consumer Servies
To create analytic
view, what is the minimum requirement for the attributes?