Skip to Content
avatar image
Former Member

New interview questions for SAP HANA

1.why we use rank in calcuation view ?

2.Diiference b/w union and union all?

3.Diiference b/w filters & restricted column ?

4.Diiference b/w union & referraln join and their uses ?

5.what is restricted column & measure ?

6.what are the nodes in attribute view ,analytical view & calcuation view ?

Please share ur valuable answers and views ....!!!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 17, 2015 at 07:18 AM

    Hi Mohibun,

    I am also new in SAP HANA and trying to provide my understanding on the above question.

    Please find it below:

    1.why we use rank in calcuation view ?


    Rank is used to find out the answer of question like Top 10 most selling products or top 10 less selling product. This node only available in the calculation view.

    2.Diiference b/w union and union all?

    Basic difference is Union removes duplicate records and Union All does not.

    3.Diiference b/w filters & restricted column ?

    Filter are used to filter out the records based on some characteristic values, ex: you need to view the value for the REVENUE column only for the region ASIA. So in the output you will have records only for ASIA region.

    Restricted columns used to restrict values of measures based on attribute restrictions. For example, you can choose to restrict the value for the REVENUE column only for REGION = ASIA, So in the output you will have records for other region as well but the column REVENUE only contain the value for ASIA region and for other region column will have value like ?(question mark).

    4.Diiference b/w union & referraln join and their uses ?

    5.what is restricted column & measure ?

    6.what are the nodes in attribute view ,analytical view & calcuation view ?


    Nodes in attr view are Data foundation and sementic.

    Nodes in Analytical view are data foundation, star join and semantic.

    Nodes in Calculation view are Star join semantic, aggregate, Join, projection, rank, Union.


    I try my best to give you answer. Please confirm with other as well.


    Br,

    Arpan Parnami

    Add comment
    10|10000 characters needed characters exceeded