Dear Experts,
I need some clarificatios on Certifiation related questions :
1) Which are connection available to HANA from reporting prespective. SQL and MDX is sure. Are SQLDBC and BICS also part ?
2) While creating Analytical view what is available by default while adding field to data foundation ?? (Question from certification, Im very confused with this question)
3) Which component of the Execution Control module breaks the query into executable parts?
4) If you use universe for accessing the report then which component in SAP HANA architecture are used? which of the below options ??
5) If you have CALDAY in your data model – how to derive CALMONTH and CALYEAR from CALDAY? I think ony gregorian time attributte view with grain as calday and year will be calc automatically. Correct me if Im wrong.
6) CREATE STRUCTURED PRIVILEGE and STRUCTUREDPRIVILEGE ADMIN are required to create/drop Analytic privilage. Correct me if Im wrong. If Im correct what about ALTER SYSTEM, in TZHANA this the one mentioned. Is it no longer relevent of analytic privilage creation/modification ??
7) To read data from any view we need only SQL privilage on that view or its column view along with analytic privilage on that view. SQL privilage and analytic privilage on underlying views/tables are not required. REPO.READ package privilage is also required to read data from that view. Correct me if Im wrong. Any other security required to read data from any view ??
8) User importing models will require which privilages ?? In TZHANA it mentions ALTER SYSTEM. Im sure it outdated. Also according to TZHANA rights on select on tables inside the view is also required. Not sure why. I guess REPO.IMPORT system privilage would be required along with SQL on SYS_BIC. Can you commnet on this ?
Regards,
Mihir