Skip to Content
0
Nov 04, 2012 at 08:34 AM

Doubts on HANA

59 Views

Dear Experts,

I was preparing for certification. I just wanted some conceptual clarifications.

1) In TZH300 it says we can create variable of 4 types, Attribute field, date, curreny and Value lists. But I see in our HANA IDES server we can make only Attribute type. Hope its mentioned wrongly in TZH300. Coz other types are only coming in input paramenters. Correct me if Im wrong.

2) Next, what if I need normal user prompt filter on date field and do not want to use that date for currency conversion. As functionality says, variable is for filtering data and input parameter is for passing paramenter for calculation. So how do I achive normal user prompt filter on date field as date type is not available for variables ?

3) Excel uses ODBC or ODBO ??

4) What is the best tool(s) for broadcasting in suite 4.0 ??

5) What is mandatory for a SQL based calc view ??

6) TZH300 mentions AAO and excel only support hier. But I feel Analysis for OLAP can also use Hier to fullest extent. Very confusing ya. Correct me if I am wrong.

7) Sementic layer can be additional level of security. Hope this statement is true. Sementic layer can be used for filtering data. Hope this is also true. Please correct me if Im wrong.

Problems in getting concepts exactly right is problem with so many documents that we have. Request your expert opinion on above points would be very helpful.

Regards,

Mihir