KB484545: MicroStrategy and SAP Database: Performance Tuning Recommendations

Community Admin

• Strategy

This article details how to improve MicroStrategy performance on SAP HANA.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Introduction

This article reviews the following approaches you can take to improve Strategy performance on SAP HANA.

Strategy Optimization: VLDB Settings
Strategy Optimization: HINTS

In addition, some other important tuning recommendations are mentioned:

OS Level Optimization
SAP Data Warehouse Optimizations

The tuning options mentioned have been evaluated using Strategy 2019 Update 2 and SAP HANA 2.0 SPS04.
Testing setup is comprised of Strategy and SAP HANA environments on an AWS cloud size of r4.xlarge (32vCPUs, 244GB RAM) configured in a live ODBC connection setup with no cache on the Strategy side. The testing scenario consisted of 40 distinctive actions executed on five dossiers to simulate a typical business use case in Strategy Web.

1. Strategy Optimization: VLDB Settings

The default Strategy 2020 settings are optimal for SAP HANA 2.0. However, these settings depend on the type of SQL being sent to the warehouse, database load, and dataset size. These factors cannot be accurately predicted, so there may be room for improvement with respect to the default settings. This section reviews two VLDB settings that have the most influence on performance in our testing scenario.

Select/Insert > Attribute Form Selection option for Immediate Pass > Select ID and other forms if they are on the template and already available in the exiting join tree.
Tables > Intermediate Table Type > Derived Table

The combination of these two settings are referred to as tuned VLDB settings. They produced the following effect on performance in our testing setup:

The Attribute Form Selection option showed a slight, but consistent improvement.
The Derived Table option showed a performance boost for smaller datasets (4MB) and degradation in performance for larger datasets (80MB).
There was a significant improvement for tuned VLDB settings for the 4 MB dataset:

There was a performance degradation for the 80MB dataset:

Performance degradation for the 80MB dataset manifests itself in the higher number of concurrent threads. For those data points, there is a much higher error ratio for the tuned VLDB settings.
The root cause of performance measured at the Strategy level, for both the 4MB and 80MB datasets, can be traced back to SAP HANA. SAP HANA shows that the queries for the tuned VLDB settings offer better performance for the 4MB dataset and worse performance for the 80MB dataset.
Querying the M_EXPENSIVE_STATEMENT HANA view generates the following results, which allows a comparison of the tuned vs. default VLDB settings performance.

KEY:
Red Tuned settings produce worse performance.
Green Tuned setting produce better performance
Yellow Tuned and default settings differ by less than 5%
n conclusion, the tuned setings, in comparion with the default settings, generate:

Fewer SQL queries
Much higher total CPU time and duration for the 80MB dataset
Much lower total CPU time and duration for the 4MB dataset
Slightly higher memory consumption for the 80MB dataset
Slightly lower memory consumption for the 40MB dataset

In additon to the two VLDB settings mentioned, you should also take into consideration the following additional settings that may influence Strategy performance on HANA. These settings were not included in our testing scenario.

Join > Base Table Join for Template > Fact Table Join
Attribute Selection option for Intermediate Pass > Select other attributes in current join tree if they are on template and their child attributes have already been selected
Query Optimization > Data population for Intelligent Cube > Normalize Intelligent Cube data in Intelligence Server
Preserve all final pass result elements > Preserve all final result pass elements

2. Strategy Optimization: HINTS

You can leverage HINTS syntax in Strategy reports with the following VLDB setting:
Select/Insert > Select Statement Post String
Enter with hint (<hint of your choice>)as your select post string to leverage HINTS syntax in SAP HANA. Make sure to include whitespace at the beginning of your input and do not end the statement with a semicolon. This setting can be applied at both the database instance level and report level. However, the report level VLDB setting overwrites the database instance settings.
It is not possible to specify a select post string in a live connected dossier because the Select Statement Post String applies to a report's SQL.
The table below lists hints that have been identified to have the most positive influence in terms of performance in our testing scenario. See 2142945 - FAQ: SAP HANA Hints for a complete list of recommended hints for consideration by SAP.

Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)
Sign Up This course is part of the Strategy Architect Learning Path, which focuses on creating, sharing, and maintaining intelligence applications for the enterprise, as well as building and maintaining the schema objects and abstraction layer on top of various changing enterprise assets. Dossier of the Month We are the masters of our fate. Congratulations to August DossBoss Champion, Niken Laily Zulfasari from PT Astra Graphia Information Technology! In her winning submission revolving around the prevalence of electric vehicles in Europe and parts of the United States, the judges were incredibly impressed with not only the large amount of outside data she incorporated into her analysis, but also with how meaningful each of her visualizations are for her analysis. Each bar graph, heat map, bubble chart and textual description come together to tell the story of the electric vehicle’s growth in the automotive industry. Energize Your Soul The DossBoss Challenge A true master is an eternal student. Back to School Amid a Pandemic. It’s time to enter Strategy’s September DossBoss competition! For this month’s challenge, use the provided starter dataset found on the DossBoss website to analyze the effect COVID-19 will have on education. Are most schools taking an online approach? What are the consequences of online learning? Will there be another spike in new cases? Demonstrate your dossier prowess by creating an intuitive, free-form dossier jam-packed with insightful visualizations and meaningful storytelling to be the next DossBoss champion. As always, feel free to visit the Community for help with troubleshooting or getting inspiration. Submit your completed DossBoss visualization here as a .mstr file or video by EOD on Friday, September 25, 2020. Winners will be announced in September’s MicroMinute and on the Community DossBoss page. That’s it for the September edition of the MicroMinute. Stay tuned for the October edition! Subscribe here to have it delivered to your inbox. Sign me up Internal IDImpactCommunity Article NameData Engine VersionStrategy VersionDE86086CSI, DataKB483742: Security filter not applied for Rank Metric20202020HintDescriptionNO_CALC_VIEW_UNFOLDINGUnfolding of a calculation view is the translation of the model into relational algebra and execution of the query via the SQL engine. In principal, this process should result in a better optimization of an executed query or calculation view. You can check whether a query is fully unfolded by looking at the SQL plan generated for it. If it contains a row where TABLE_NAME is the calculation view and TABLE_TYPE contains a value of 'CALCULATION_VIEW' then the calculation view has not been fully unfolded. (NO_)CALC_VIEW_UNFOLDING guide the HANA optimizer to unfold or to skip the process for a given query.CHECK_JOIN_CARDINALITYForces the SQL optimizer to check the cardinality of each join. This hint may severely degrade performance in some cases. In our testing scenario CS_DISTINCTPrefers executing the operation in a column engine rather than a row engine.CS_FILTERIGNORE_PLAN_CACHEIgnores the current SQL query execution cache and forces recompilation of the query.NO_CS_JOINPrefers executing the operation in a row engine rather than in a column engine.NO_INDEX_JOINNO_USE_ESX_PLANOPTIMIZATION_LEVEL(MINIMAL_COST_BASED)	This hint controls complexity of optimization considered for a query. Other possible values are:
OPTIMIZATION_LEVEL(RULE_BASED)USE_OLAP_PLANEncourages the optimizer to use the OLAP engine SQL plan, rather than the join engine.
OPTIMIZATION_LEVEL(RULE_BASED)USE_OLAP_PLANEncourages the optimizer to use the OLAP engine SQL plan, rather than the join engine.	OPTIMIZATION_LEVEL(RULE_BASED)USE_OLAP_PLANEncourages the optimizer to use the OLAP engine SQL plan, rather than the join engine.

It is common for some hints to improve one aspect of performance like execution time, but consume more in other resources like memory consumption. Therefore, it is advised to thoroughly check the effects of a given hint. This can be done by looking at the SAP HANA M_EXPENSIVE_STATEMENT system view. To track memory consumption of a SQL statement in HANA, the following two global.ini parameters must be set to true: memory_tracking and enable_tracking.

3. OS-Level Optimization

SAP note 2235581 lists certified operating systems and strongly encourages the use of either:

RHEL for SAP Solutions (from now on, referred to as RHEL)
SLES for SAP Applications (SLES)

To perform OS level optimization on RHEL for SAP Solutions, you need to have a valid Red Hat Enterprise Linux for SAP Solutions subscription. RHEL offers a free subscription for development systems which can be used to setup a system and later re-register it if necessary.
Refer to How to subscribe to Update Services for SAP Solutions on RHEL 8 for instructions on how to configure your RHEL for subscription. This article shows that performance of RHEL 8 is better than RHEL 7 for SAP HANA.
RHEL optimization consists of the following:

Activating SAP HANA-specific tuned profiles
Disabling SELInux
Adjusting NUMA balancing
Disabling transparent Hugepages
Configuring CPU governor for performance
Configuring processor C-states
Adjusting the maximum number of processes SAP OS user is allowed to run

Detailed instructions for configuring RHEL for SAP HANA can be found in SAP note 2009879 . A walk-through for SLES can be found in SAP note 1944799.
The influence of applying optimization to RHEL on Strategy performance for our testing scenario described at the beginning of the article on 4MB size dataset (fact table with 4 million rows) was observed to be around 1%.

Blue markers refer to tuned RHEL; yellow to OOTB RHEL settings.

4. SAP Hana Data Warehouse Optimization: References

There is a multitude of content online dealing with optimizing SAP HANA SQL performance. The following SAP notes are recommended as a first stop:

In addition to the above information, we encourage you to check out the following SAP notes to gain knowledge about the typical optimization techniques in context of HANA:

Comment

0 comments

Details

Knowledge Article

Published:

September 2, 2020

Last Updated:

March 21, 2024