![sap hana studio what is use of attribute view time sap hana studio what is use of attribute view time](https://i.ytimg.com/vi/_HmQsJkE-T4/maxresdefault.jpg)
The attribute 0IP_GRPD has the value GROUP1 for VD01 since we have chosen the key date (see content of Q table above). The Hana view is based on the 'Q' master data table. Use the Data Preview function in the SAP HANA studio. How can you evaluate the speed of a calculation within the database (Choose two) A. Pre-requisites At least SAP HANA 2.0 SPS 1. The property 'Usable as InfoProvider' is active.Īnd notice that there is a parameter 'keydate' which can be used to specify the key date for the time dependent attributes. Which of the following properties of a derived attribute view can you modify A. In this blog post, I will be tackling a much more common use case, which is the BW Analysis Authorizations to be replicated into the SAP Analytics Cloud public dimenions’ read and write properties using a HANA calculation view. The sample InfoObject is simple and only contains 2 time dependent attributes. Example to "External SAP HANA View for Master Data InfoProvider" Note that the SQL statement contains a placeholder for the key date. The attribute 0IP_GRPD has the value GROUP2 for A001 since we have chosen the key date (see content of Q table above). The function 'Data Preview' can be used to check the content and also get the corresponding SQL displayed: The Hana view is based on the 'P' and 'Q' master data tables. In the Hana Studio we search for this object in the package system-local.bw.bw2hanaĪnd notice that there is a parameter 'keydate' which can be used to specify the key date for the time dependent attribute. We take a quick look at transaction RS2HANA_ADMIN and search for the corresponding generated external Hana view: The content of the Q-table which contains the time dependent attributes:
![sap hana studio what is use of attribute view time sap hana studio what is use of attribute view time](http://www.bestsaphanatraining.com/img/sap-hana-studio-assign-catalog-objects-to-user.jpg)
The sample InfoObject is simple and only contains 2 attributes where one is time dependent: