{"iq":[{"id":"1",
"q":"what is SAP HANA ?",
"answer":" SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control."
},
{"id":"2",
"q":"What is the use of SAP HANA studio?",
"answer":"HANA studio is an eclipsed based tool and provides support for development and administration in HANA system. You can perform HANA Modeling on the top of tables in database, Data provisioning, HANA Administration and various other activities using HANA studio.\n\nSAP HANA Studio client is available for Windows XP, Windows Vista, and Windows 7 for 32 bit and 64 bit operating system."
},
{"id":"3",
"q":"What are the types of modeling views in HANA?",
"answer":"There are 3 types of modeling in HANA:\n\nAttribute View\n\nAnalytic View\n\nCalculation View"
},
{"id":"4",
"q":"What is a Delivery Unit?",
"answer":"A delivery unit could be regarded as a collection of several packages, used for transporting content from one HANA system to another.\n\nDelivery unit (DU) is a container used by the Life Cycle Manager (LCM) to transport repository objects. "
},
{"id":"5",
"q":"There are 2 types of packages in content. What are they?",
"answer":"In HANA, 2 types of packages can be created.\n\nStructural: Package only contains sub-packages. It cannot contain repository objects.\n\nNon-Structural: Package contains both repository objects and sub-packages.\n\nBy default it creates Non-structural."
},
{"id":"6",
"q":"What are the different engines available in HANA?",
"answer":"In HANA there are mainly 3 types of engines.\n\nJoin Engine: used for attribute views\n\nOLAP engine: used for analytic views\n\nCalculation Engine: used for calculation views"
},
{"id":"7",
"q":"Mention what is the role of the persistence layer in SAP HANA?",
"answer":"SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile."
},
{"id":"8",
"q":"Mention what is modeling studio?",
"answer":"Modeling studio in HANA performs multiple task like\n\nDeclares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs\n\nManage Data Services to enter the data from SAP Business Warehouse and other systems\n\nManage ERP instances connection, the current release does not support connecting to several ERP instances\n\nUse data services for the modeling\n\nDo modeling in HANA itself\n\nessential licenses for SAP BO data services"
},
{"id":"9",
"q":"Mention what is latency?",
"answer":"Latency is referred to the length of time to replicate data from the source system to the target system."
},
{"id":"10",
"q":"Explain what is transformation rules?",
"answer":"Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process."
},
{"id":"11",
"q":"Mention what is the role of master controller job in SAP HANA?",
"answer":"The job is arranged on demand and is responsible for\n\nCreating database triggers and logging table into the source system\n\nCreating Synonyms\n\nWriting new entries in admin tables in SLT server when a table is replicated/loaded"
},
{"id":"12",
"q":"Mention what is the role of the transaction manager and session?",
"answer":"The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions."
},
{"id":"13",
"q":"There is an analytic view which has calculated column defined. Which engine will be used when calling this view?",
"answer":"By default analytic view is executed in OLAP engine. But this changes when analytic view has a calculated column.\n\nIf an analytic view has a calculated column then internally it is treated as calculation view and executed in calculation engine. "
},
{"id":"14",
"q":" If my Analytic View foundation is joined to attribute views, is both the OLAP and JOIN Engine used?",
"answer":"Nope - during activation of the analytic views, the joins in the attribute views get 'flattened' and included in the analytic view run time object. Only the OLAP engine will be used then."
},
{"id":"15",
"q":"How do I recover lost data?",
"answer":"SAP HANA One is configured to back up data and log to a separate 200GB EBS volume from which data can then be recovered. Log backup is performed periodically as needed. Data backup is recommended periodically and before any system upgrade to protect data and HANA artifacts."
},
{"id":"16",
"q":"Can a SAP HANA One backup be restored into an on-premise instance of SAP HANA?",
"answer":"Yes, as long as SAP HANA One and SAP HANA on-premise licenses are valid, and the SAP HANA versions match, backup data can be transferred. Please follow your license agreements carefully before you transfer any data between SAP HANA One and SAP HANA on-premise. "
},
{"id":"17",
"q":"Do I need to install Secure Backup media and administrative servers in order to do Cloud backup?",
"answer":" Special backup media is not required. The SAP HANA One instances are pre-configured with 200GB of EBS volumes for data backups. For added data security, snapshots of these volumes can be created on AWS."
},
{"id":"18",
"q":"What is SAP Collections Insight?",
"answer":"SAP Collections Insight powered by SAP HANA allows you access to real-time mobile collaboration and collections account information anywhere and anytime, allowing you to resolve collections issues, better manage your collections efforts, tighten business relationships and get paid faster."
},
{"id":"19",
"q":"What are the business benefits of SAP Collections Insight?",
"answer":"The SAP Collections Insight web and mobile apps give you access to rich, dynamic account profiles and enable real-time analysis of payments and payment trends across years of data. With Collections Insight, sales and service teams can support collections activities with access to dashboards and collaborative tools to help manage, track, quickly resolve collections issues, and get paid on outstanding accounts faster."
},
{"id":"20",
"q":" How is the solution delivered?",
"answer":"SAP Collections Insight is delivered as mobile and web applications, powered by SAP HANA, letting our customers access the power of SAP HANA in an easy-to-consume model. This leads to radical reductions in capital expenditure and quicker innovation cycles."
},
{"id":"21",
"q":" So is SAP making/selling the software or the hardware?",
"answer":"SAP has partnered with leading hardware vendors (HP, Fujitsu, IBM, Dell etc) to sell SAP certified hardware for HANA: SAP is selling licenses and related services for the SAP HANA product which includes the SAP HANA database, SAP HANA Studio and other software to load data in the database. "
},
{"id":"22",
"q":"What is the language SAP HANA is developed in?",
"answer":"The SAP HANA database is developed in C++."
},
{"id":"23",
"q":"What is the operating system supported by HANA?",
"answer":"Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA.."
},{"id":"24",
"q":"What are the row-based and column based approach?",
"answer":"Row based tables: It is the traditional Relational Database approach It store a table in a sequence of rows Column based tables: It store a table in a sequence of columns i.e. the entries of a column is stored in contiguous memory locations. SAP HANA is particularly optimized for column-order storage. SAP HANA supports both row-based and column-based approach. Following figure explains the difference between the two storage mechanism. Column based and Row based Tables."
},
{"id":"25",
"q":"We need to take UNION of 2 tables and then create a calculated column. Can we implement this in analytic view?",
"answer":"Analytic view doesn’t support UNION. We need calculation view to implement this logic."
},{"id":"26",
"q":"Can we call an analytic view in another analytic view?",
"answer":"NO. We cannot call an analytic view inside other analytic view. "
},{"id":"27",
"q":"When to change the number of Data Transfer Jobs?",
"answer":"The number of data transfer jobs change when the initial loading speed or latency replication time is not up to the mark. At the end of the initial load, the number of initial load jobs may be reduced."
},{"id":"28",
"q":"Is the table size in source system and Sap HANA system same?",
"answer":"No"
},{"id":"29",
"q":"Explain the role of transaction manager and session?",
"answer":"SAP HANA transaction manager synchronizes database transactions keeping the record of closed and open transactions. When a transaction is committed or rolled back, the manager informs all the active stores and engines about the action so that they can perform required actions in time."
},{"id":"30",
"q":" What is Stall?",
"answer":"The waiting process for data to load from the main memory to the CPU cache is called Stall."
},{"id":"31",
"q":"Define SLT Configuration.?",
"answer":"Configuration is the meaningful information to establish a connection between source, SLT system and SAP HANA architecture as stated in the SLT system. Programmers are allowed to illustrate a new Configuration in Configuration and Monitoring Dashboard."
},{"id":"33",
"q":" Name the replication jobs in SAP HANA.?",
"answer":"Master Job (IUUC_MONITOR_)\n\nData Load Job (DTL_MT_DATA_LOAD__)\n\nMaster Controlling Job (IUCC_REPLIC_CNTR_)\n\nMigration Object Definition Job (IUCC_DEF_MIG_OBJ_)\n\nAccess Plan Calculation Job (ACC_PLAN_CALC__)"
},{"id":"34",
"q":"List the different compression techniques in HANA?",
"answer":"Run-length encoding\n\nCluster encoding\n\nDictionary encoding"
},{"id":"35",
"q":"Explain the concept of Persistence Layer?",
"answer":"The persistence layer in SAP HANA handles all logging operations and transactions for secured backup and data restoring. This layer manages data stored in both rows and columns and provides steady savepoints. Built on the concept of persistence layer of SAP’s relational database, it ensures successful data restores.\n\nBesides managing log data on the disk, HANA’s persistence layer allows read and write data operations via all storage interfaces."
},{"id":"36",
"q":"What is ad hoc analysis?",
"answer":"In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is done for quick results. That is the administrator (IT department) decides which information might be needed for analysis and prepares the result for the end users. This results in fast performance but the end user does not have flexibility.\n\nThe performance reduces dramatically if the user wants to do analysis on some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operations in their reports and does not have to wait hours to get the data ready for analysis."
},
{"id":"37",
"q":"What is SAP HANA cockpit?",
"answer":"SAP HANA cockpit is a SAP Fiori Launchpad site that allows you with a single point-of-access to a range of Web-based applications for the online administration of SAP HANA. You access the SAP HANA cockpit through a Web browser.\n\nTo open SAP HANA Cockpit → Right click on HANA system in Studio → configuration and monitoring → open SAP HANA cockpit."
},
{"id":"38",
"q":"Explain what is schema mapping?",
"answer":"Schema mapping is done when the physical schema in the target system is not the same as the physical schema in the source system.\n\nAs mentioned earlier, suppose we are moving components from Development System (DEV) to Production System (PROD).\n\nThe tables in DEV reside in DEV_SCHEMA and the same tables reside in PROD system in PROD_SCHEMA schema. If an attribute view is transported from DEV to PROD, it will not work because the schema name is referenced in the definition of attribute view. In order for the promoted objects to work in PROD, schema mapping needs to be set up in the target system."
},
{"id":"39",
"q":" In which configuration tables the generated time data information will be stored in HANA?",
"answer":"For Gregorian calendar type\n\nM_TIME_DIMENSION_YEAR\n\nM_TIME_DIMENSION_MONTH\n\nM_TIME_DIMENSION_WEEK\n\nM_TIME_DIMENSION\n\nFor Fiscal\n\nM_FISCAL_CALENDAR\n\nAll these tables are under schema _SYS_BI."
},{"id":"40",
"q":"What is a Private Attribute in HANA?",
"answer":"Private attributes are the attributes used inside a modeling views and cannot be used outside the view. These are used in a modeling view to customize the behavior of an attribute for only that view. "
},{"id":"41",
"q":" In which configuration table you can find the variables information?",
"answer":"There are 4 system tables under the schema _SYS_BI which contains information about Variables.\n\nBIMC_VARIABLE\n\nBIMC_VARIABLE_ASSIGNMENT\n\nBIMC_VARIABLE_VIEW\n\nBIMC_VARIABLE_VALUE"
},{"id":"42",
"q":"How do we pass input parameters from SQL query?",
"answer":"The value of Input Parameter is passed using PLACEHOLDER clause.\n\nFor example:\n\n('PLACEHOLDER' = ('$$Param1$$', 'value'))"
},{"id":"43",
"q":"What is the prerequisite for doing the currency conversion?·",
"answer":" You need to import tables TCURC, TCURF, TCURN, TCURR, TCURT, TCURV, TCURW and TCURX. "
},{"id":"44",
"q":"What is the prerequisite for Unit of Measure?",
"answer":"You need to import the tables T006 & T006A."
},
{"id":"45",
"q":" Mention what is the difference between Central Instance & Application Server?",
"answer":"Central Instance has message server and dialog, update, spool, enque, gateway, background work processes.\n\nApplication server has dialog, update, spool, gateway and background work process."
},
{"id":"46",
"q":"What happens when you activate an object in HANA?",
"answer":"When we activate an object, it becomes available for reporting and analysis.\n\nAfter successful activation of a view, a run time object is created in _SYS_BIC schema.\n\nFor example, suppose there is a calculation view CV_VIEW1 in package “MyPackage”. After activating this view, a run time object (column view) will be created in _SYS_BIC schema with name “MyPackage/CV_VIEW1”. This column view is used when we do the data preview of calculation view."
},{"id":"47",
"q":"What is the operating system supported by HANA?",
"answer":"Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA."
},{"id":"48",
"q":"Where are transformation rules defined?",
"answer":"Transformation rules are defined by using “Advanced replication settings (transaction IUUC_REPL_CONT, tab page IUUC ASS RULE MAP)"
},
{"id":"49",
"q":"What is the difference between Activate and Redeploy?",
"answer":"Activate - Deploys the inactive objects.\n\nRedeploy - Deploys the active objects in one of the following scenarios:\n\nIf your runtime object gets corrupted or deleted, and you want to create it again.\n\nIn case of runtime problems during object activation, and the object status is still active. "
},{"id":"50",
"q":"What is Auto Documentation feature in HANA?",
"answer":"When the user creates Views in HANA Studio under “Contents”, he can automatically generate the documentation about the views. This generated document will have the details about all the view belongs to a package which he selected for Auto Documentation.\n\nThe user can invoke the Auto Documentation from three places.\n\nRight click Context menu of the Package or the Views\n\nOn the top right corner of the opened view\n\nQuick Launch->Content->Auto Documentation."
}
]
}
"q":"what is SAP HANA ?",
"answer":" SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication server management and load control."
},
{"id":"2",
"q":"What is the use of SAP HANA studio?",
"answer":"HANA studio is an eclipsed based tool and provides support for development and administration in HANA system. You can perform HANA Modeling on the top of tables in database, Data provisioning, HANA Administration and various other activities using HANA studio.\n\nSAP HANA Studio client is available for Windows XP, Windows Vista, and Windows 7 for 32 bit and 64 bit operating system."
},
{"id":"3",
"q":"What are the types of modeling views in HANA?",
"answer":"There are 3 types of modeling in HANA:\n\nAttribute View\n\nAnalytic View\n\nCalculation View"
},
{"id":"4",
"q":"What is a Delivery Unit?",
"answer":"A delivery unit could be regarded as a collection of several packages, used for transporting content from one HANA system to another.\n\nDelivery unit (DU) is a container used by the Life Cycle Manager (LCM) to transport repository objects. "
},
{"id":"5",
"q":"There are 2 types of packages in content. What are they?",
"answer":"In HANA, 2 types of packages can be created.\n\nStructural: Package only contains sub-packages. It cannot contain repository objects.\n\nNon-Structural: Package contains both repository objects and sub-packages.\n\nBy default it creates Non-structural."
},
{"id":"6",
"q":"What are the different engines available in HANA?",
"answer":"In HANA there are mainly 3 types of engines.\n\nJoin Engine: used for attribute views\n\nOLAP engine: used for analytic views\n\nCalculation Engine: used for calculation views"
},
{"id":"7",
"q":"Mention what is the role of the persistence layer in SAP HANA?",
"answer":"SAP HANA has an in-memory computing engine and access the data straightaway without any backup. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile."
},
{"id":"8",
"q":"Mention what is modeling studio?",
"answer":"Modeling studio in HANA performs multiple task like\n\nDeclares which tables are stored in HANA, first part is to get the meta-data and then schedule data replication jobs\n\nManage Data Services to enter the data from SAP Business Warehouse and other systems\n\nManage ERP instances connection, the current release does not support connecting to several ERP instances\n\nUse data services for the modeling\n\nDo modeling in HANA itself\n\nessential licenses for SAP BO data services"
},
{"id":"9",
"q":"Mention what is latency?",
"answer":"Latency is referred to the length of time to replicate data from the source system to the target system."
},
{"id":"10",
"q":"Explain what is transformation rules?",
"answer":"Transformation rule is the rule specified in the advanced replication setting transaction for the source table such that data is transformed during the replication process."
},
{"id":"11",
"q":"Mention what is the role of master controller job in SAP HANA?",
"answer":"The job is arranged on demand and is responsible for\n\nCreating database triggers and logging table into the source system\n\nCreating Synonyms\n\nWriting new entries in admin tables in SLT server when a table is replicated/loaded"
},
{"id":"12",
"q":"Mention what is the role of the transaction manager and session?",
"answer":"The transaction manager co-ordinates database transactions and keeps a record of running and closed transactions. When transaction is rolled back or committed, the transaction manager notifies the involved storage engines about the event so they can run necessary actions."
},
{"id":"13",
"q":"There is an analytic view which has calculated column defined. Which engine will be used when calling this view?",
"answer":"By default analytic view is executed in OLAP engine. But this changes when analytic view has a calculated column.\n\nIf an analytic view has a calculated column then internally it is treated as calculation view and executed in calculation engine. "
},
{"id":"14",
"q":" If my Analytic View foundation is joined to attribute views, is both the OLAP and JOIN Engine used?",
"answer":"Nope - during activation of the analytic views, the joins in the attribute views get 'flattened' and included in the analytic view run time object. Only the OLAP engine will be used then."
},
{"id":"15",
"q":"How do I recover lost data?",
"answer":"SAP HANA One is configured to back up data and log to a separate 200GB EBS volume from which data can then be recovered. Log backup is performed periodically as needed. Data backup is recommended periodically and before any system upgrade to protect data and HANA artifacts."
},
{"id":"16",
"q":"Can a SAP HANA One backup be restored into an on-premise instance of SAP HANA?",
"answer":"Yes, as long as SAP HANA One and SAP HANA on-premise licenses are valid, and the SAP HANA versions match, backup data can be transferred. Please follow your license agreements carefully before you transfer any data between SAP HANA One and SAP HANA on-premise. "
},
{"id":"17",
"q":"Do I need to install Secure Backup media and administrative servers in order to do Cloud backup?",
"answer":" Special backup media is not required. The SAP HANA One instances are pre-configured with 200GB of EBS volumes for data backups. For added data security, snapshots of these volumes can be created on AWS."
},
{"id":"18",
"q":"What is SAP Collections Insight?",
"answer":"SAP Collections Insight powered by SAP HANA allows you access to real-time mobile collaboration and collections account information anywhere and anytime, allowing you to resolve collections issues, better manage your collections efforts, tighten business relationships and get paid faster."
},
{"id":"19",
"q":"What are the business benefits of SAP Collections Insight?",
"answer":"The SAP Collections Insight web and mobile apps give you access to rich, dynamic account profiles and enable real-time analysis of payments and payment trends across years of data. With Collections Insight, sales and service teams can support collections activities with access to dashboards and collaborative tools to help manage, track, quickly resolve collections issues, and get paid on outstanding accounts faster."
},
{"id":"20",
"q":" How is the solution delivered?",
"answer":"SAP Collections Insight is delivered as mobile and web applications, powered by SAP HANA, letting our customers access the power of SAP HANA in an easy-to-consume model. This leads to radical reductions in capital expenditure and quicker innovation cycles."
},
{"id":"21",
"q":" So is SAP making/selling the software or the hardware?",
"answer":"SAP has partnered with leading hardware vendors (HP, Fujitsu, IBM, Dell etc) to sell SAP certified hardware for HANA: SAP is selling licenses and related services for the SAP HANA product which includes the SAP HANA database, SAP HANA Studio and other software to load data in the database. "
},
{"id":"22",
"q":"What is the language SAP HANA is developed in?",
"answer":"The SAP HANA database is developed in C++."
},
{"id":"23",
"q":"What is the operating system supported by HANA?",
"answer":"Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA.."
},{"id":"24",
"q":"What are the row-based and column based approach?",
"answer":"Row based tables: It is the traditional Relational Database approach It store a table in a sequence of rows Column based tables: It store a table in a sequence of columns i.e. the entries of a column is stored in contiguous memory locations. SAP HANA is particularly optimized for column-order storage. SAP HANA supports both row-based and column-based approach. Following figure explains the difference between the two storage mechanism. Column based and Row based Tables."
},
{"id":"25",
"q":"We need to take UNION of 2 tables and then create a calculated column. Can we implement this in analytic view?",
"answer":"Analytic view doesn’t support UNION. We need calculation view to implement this logic."
},{"id":"26",
"q":"Can we call an analytic view in another analytic view?",
"answer":"NO. We cannot call an analytic view inside other analytic view. "
},{"id":"27",
"q":"When to change the number of Data Transfer Jobs?",
"answer":"The number of data transfer jobs change when the initial loading speed or latency replication time is not up to the mark. At the end of the initial load, the number of initial load jobs may be reduced."
},{"id":"28",
"q":"Is the table size in source system and Sap HANA system same?",
"answer":"No"
},{"id":"29",
"q":"Explain the role of transaction manager and session?",
"answer":"SAP HANA transaction manager synchronizes database transactions keeping the record of closed and open transactions. When a transaction is committed or rolled back, the manager informs all the active stores and engines about the action so that they can perform required actions in time."
},{"id":"30",
"q":" What is Stall?",
"answer":"The waiting process for data to load from the main memory to the CPU cache is called Stall."
},{"id":"31",
"q":"Define SLT Configuration.?",
"answer":"Configuration is the meaningful information to establish a connection between source, SLT system and SAP HANA architecture as stated in the SLT system. Programmers are allowed to illustrate a new Configuration in Configuration and Monitoring Dashboard."
},{"id":"33",
"q":" Name the replication jobs in SAP HANA.?",
"answer":"Master Job (IUUC_MONITOR_)\n\nData Load Job (DTL_MT_DATA_LOAD__)\n\nMaster Controlling Job (IUCC_REPLIC_CNTR_)\n\nMigration Object Definition Job (IUCC_DEF_MIG_OBJ_)\n\nAccess Plan Calculation Job (ACC_PLAN_CALC__)"
},{"id":"34",
"q":"List the different compression techniques in HANA?",
"answer":"Run-length encoding\n\nCluster encoding\n\nDictionary encoding"
},{"id":"35",
"q":"Explain the concept of Persistence Layer?",
"answer":"The persistence layer in SAP HANA handles all logging operations and transactions for secured backup and data restoring. This layer manages data stored in both rows and columns and provides steady savepoints. Built on the concept of persistence layer of SAP’s relational database, it ensures successful data restores.\n\nBesides managing log data on the disk, HANA’s persistence layer allows read and write data operations via all storage interfaces."
},{"id":"36",
"q":"What is ad hoc analysis?",
"answer":"In traditional data warehouses, such as SAP BW, a lot of pre-aggregation is done for quick results. That is the administrator (IT department) decides which information might be needed for analysis and prepares the result for the end users. This results in fast performance but the end user does not have flexibility.\n\nThe performance reduces dramatically if the user wants to do analysis on some data that is not already pre-aggregated. With SAP HANA and its speedy engine, no pre-aggregation is required. The user can perform any kind of operations in their reports and does not have to wait hours to get the data ready for analysis."
},
{"id":"37",
"q":"What is SAP HANA cockpit?",
"answer":"SAP HANA cockpit is a SAP Fiori Launchpad site that allows you with a single point-of-access to a range of Web-based applications for the online administration of SAP HANA. You access the SAP HANA cockpit through a Web browser.\n\nTo open SAP HANA Cockpit → Right click on HANA system in Studio → configuration and monitoring → open SAP HANA cockpit."
},
{"id":"38",
"q":"Explain what is schema mapping?",
"answer":"Schema mapping is done when the physical schema in the target system is not the same as the physical schema in the source system.\n\nAs mentioned earlier, suppose we are moving components from Development System (DEV) to Production System (PROD).\n\nThe tables in DEV reside in DEV_SCHEMA and the same tables reside in PROD system in PROD_SCHEMA schema. If an attribute view is transported from DEV to PROD, it will not work because the schema name is referenced in the definition of attribute view. In order for the promoted objects to work in PROD, schema mapping needs to be set up in the target system."
},
{"id":"39",
"q":" In which configuration tables the generated time data information will be stored in HANA?",
"answer":"For Gregorian calendar type\n\nM_TIME_DIMENSION_YEAR\n\nM_TIME_DIMENSION_MONTH\n\nM_TIME_DIMENSION_WEEK\n\nM_TIME_DIMENSION\n\nFor Fiscal\n\nM_FISCAL_CALENDAR\n\nAll these tables are under schema _SYS_BI."
},{"id":"40",
"q":"What is a Private Attribute in HANA?",
"answer":"Private attributes are the attributes used inside a modeling views and cannot be used outside the view. These are used in a modeling view to customize the behavior of an attribute for only that view. "
},{"id":"41",
"q":" In which configuration table you can find the variables information?",
"answer":"There are 4 system tables under the schema _SYS_BI which contains information about Variables.\n\nBIMC_VARIABLE\n\nBIMC_VARIABLE_ASSIGNMENT\n\nBIMC_VARIABLE_VIEW\n\nBIMC_VARIABLE_VALUE"
},{"id":"42",
"q":"How do we pass input parameters from SQL query?",
"answer":"The value of Input Parameter is passed using PLACEHOLDER clause.\n\nFor example:\n\n('PLACEHOLDER' = ('$$Param1$$', 'value'))"
},{"id":"43",
"q":"What is the prerequisite for doing the currency conversion?·",
"answer":" You need to import tables TCURC, TCURF, TCURN, TCURR, TCURT, TCURV, TCURW and TCURX. "
},{"id":"44",
"q":"What is the prerequisite for Unit of Measure?",
"answer":"You need to import the tables T006 & T006A."
},
{"id":"45",
"q":" Mention what is the difference between Central Instance & Application Server?",
"answer":"Central Instance has message server and dialog, update, spool, enque, gateway, background work processes.\n\nApplication server has dialog, update, spool, gateway and background work process."
},
{"id":"46",
"q":"What happens when you activate an object in HANA?",
"answer":"When we activate an object, it becomes available for reporting and analysis.\n\nAfter successful activation of a view, a run time object is created in _SYS_BIC schema.\n\nFor example, suppose there is a calculation view CV_VIEW1 in package “MyPackage”. After activating this view, a run time object (column view) will be created in _SYS_BIC schema with name “MyPackage/CV_VIEW1”. This column view is used when we do the data preview of calculation view."
},{"id":"47",
"q":"What is the operating system supported by HANA?",
"answer":"Currently SUSE Linux Enterprise Server x86-64 (SLES) 11 SP1 is the Operating System supported by SAP HANA."
},{"id":"48",
"q":"Where are transformation rules defined?",
"answer":"Transformation rules are defined by using “Advanced replication settings (transaction IUUC_REPL_CONT, tab page IUUC ASS RULE MAP)"
},
{"id":"49",
"q":"What is the difference between Activate and Redeploy?",
"answer":"Activate - Deploys the inactive objects.\n\nRedeploy - Deploys the active objects in one of the following scenarios:\n\nIf your runtime object gets corrupted or deleted, and you want to create it again.\n\nIn case of runtime problems during object activation, and the object status is still active. "
},{"id":"50",
"q":"What is Auto Documentation feature in HANA?",
"answer":"When the user creates Views in HANA Studio under “Contents”, he can automatically generate the documentation about the views. This generated document will have the details about all the view belongs to a package which he selected for Auto Documentation.\n\nThe user can invoke the Auto Documentation from three places.\n\nRight click Context menu of the Package or the Views\n\nOn the top right corner of the opened view\n\nQuick Launch->Content->Auto Documentation."
}
]
}