1. is static and design time filters are same?
A.
No both are different, we can apply two types of filters in SAP HANA
while creating Modeling objects they are
Static
Dynamic
Static: These filters are fixed and can be applied at all the modeling object levels,
i.e. Attribute View, Analytic View and Calculation View.
Dynamic: Applying a filter in a column when designing a view is called design
time filter.
In these filters,
the input values are entered by business when they execute their
reports.
We can capture the business
response and apply them as filters with the help of variables
and input parameters in SAP HANA.
These
two filter types can be applied to both at Analytic View and
Calculation View levels but not at Attribute View level.
3. What is Referential Join?
A. referential
join is similar to an inner join that assumes
that referential integrity is Maintained between the two tables,
which means that the left table always have a
Corresponding entry on the
right table
4. What is an Application Layer and Application
Platform?
Application layer sits on
application server in HANA.
Extended application services is
a small-footprint application server, web server,
and basis for an application development platform - that lives inside SAP HANA.
and basis for an application development platform - that lives inside SAP HANA.
SAP HANA being called a
“platform”, or described as a key part of the “Real-Time data Platform” from
SAP
5. Can we have more than one Design Time Filter?
Yes, you can apply design
time filter for more than one column in a table, and you can apply for
list of values in a field.
6. Can we create analytic view, forwhich
attritbute views are in diffrent sub package or in different package?
A. All these views are created in different package. All the Views are active and working fine as of now. Now, my aim is to move/copy all these views in to one single package named "Main Package".
A. All these views are created in different package. All the Views are active and working fine as of now. Now, my aim is to move/copy all these views in to one single package named "Main Package".
One way to do this is to
recreate all these views using Copy from option in the new package and
then connect all the attribute views (new ones in the Main
Package) hence use this into
analytic view
By using refractor option we
can move packages into one package to another package
7. What is difference between a Relational and an OLAP connection?
A.
The idea is basically if you need to access data from a table and regular RDBMS
then your connection should be a relational connection but if your source is an
application and data is stored in cube (multidimensional like Info cubes,
Information models) then you would use an OLAP connection.
Relational connection can
only be created in IDT/UDT.
OLAP can be created in both
IDT and CMC.
Another thing to note is
relational connection (including HANA) will always produce a SQL statement to
be fired from report while OLAP connection normally create a MDX statement.
A. in BI (Business
Intelligence) raw data will be cleaned; business logic applied, processed and provides
meaningful information to the user. BI is a SAP Product, which provides the
user friendly environment.
SAP BI support many databases, but when we
migrate from source data to SAP HANA then architecture will be as below-SAP BI
is three tier architecture
Database Server – In this,
data is physically stored in PSA, ODS, Info cube.
Application Server – It is used
to access data from database server and process data for Presentation server.
Presentation Server- It displays
the data to the user.
9. What is the
mean of enable client aggregation and its purpose?
A. If you want to create a calculated measure and enable client side aggregation for the calculated measure, select the Enable client side aggregation checkbox. This allows you to propose the aggregation that client needs to perform on calculated measures.
A. If you want to create a calculated measure and enable client side aggregation for the calculated measure, select the Enable client side aggregation checkbox. This allows you to propose the aggregation that client needs to perform on calculated measures.
10. To improve the performance of Information view by validating joins and
Cardinality, which option cab, is used?
A.
You can select Switch to Performance Analysis Mode. This allows you to do
Performance Analysis by validating correct join type and Cardinality
No comments:
Post a Comment