SAP HANA Modeling Guidance

HANA Modeling Target: Minimize Data Transfers 

The main goal during modeling is to minimized Data transfers. 
This is possible true both internally, between the SAP HANA database views, and also between SAP HANA and the end user application.

So for example, the end-user will never need to see 1 million rows of data. 
They would never be able to understand so much information or consume it in some meaningful way. 

So data should be aggregated and filtered to a manageable size before it leaves the data layer.

When deciding upon the records that should be reported, 
the best practice approach is to think at a “set level” not a “record level”. 

A set of data can be aggregated by a region, a date, or some other group in order to
minimize the amount of data passed between views.

Read related post:

Comments

  1. UnknownMay 5, 2016 at 11:03 PM

    Get training as well as syllabus of SAP from the Pragna Technologies...
    SAP SD Online Training | Simple Finance Online Training in Hyderabad

    ReplyDelete
  2. Article Submission ProjectAugust 28, 2021 at 3:04 AM

    I don’t think many of websites provide this type of information. tafsir ahlam

    ReplyDelete
  3. AnonymousAugust 31, 2021 at 10:32 PM

    Your blog is too much amazing. I have found with ease what I was looking. Moreover, the content quality is awesome. Thanks for the nudge! IT support company

    ReplyDelete
  4. JOB ADVERTISMENTSeptember 6, 2021 at 7:49 AM

    There are all kinds of pictures of the world on the internet, but to find one of these specific pictures that you want to use for your blog or business marketing, but to find out where it is used. It is not an easy task. But you can do it easily with a Yandex reverse image search lets see how do you reverse image search on Yandex? Yandex reverse image search

    ReplyDelete
  5. sameerkhatriSeptember 8, 2021 at 11:59 PM

    Much appreciated such a great amount for this data. I need to tell you I agree on a few of the focuses you make here and others might require some further survey, however I can see your perspective. Managed Service Provider Madison

    ReplyDelete
  6. Lynna ConnerSeptember 10, 2021 at 2:59 PM

    This is extremely incredible work. Much thanks to you for sharing such a decent and valuable data here in the blog for understudies. business plan examples

    ReplyDelete
  7. ・TeamAzPlayerSeptember 12, 2021 at 1:27 AM

    Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review, but I can see your viewpoint. กองทุนรวม

    ReplyDelete
  8. UnknownSeptember 14, 2021 at 7:16 AM

    This is also a very good post which I really
    enjoyed reading. It is not every day that I have the possibility to see
    something like this.. Anime Characters

    ReplyDelete
  9. Main Branches of scienceSeptember 14, 2021 at 9:53 PM

    This is also a very good post which I really
    enjoyed reading. It is not every day that I have the possibility to see
    something like this.. Dream Interpretation

    ReplyDelete
  10. zk0306577@gmail.comSeptember 16, 2021 at 5:39 AM

    I can give you the address Here you will learn how to do it correctly. Read and write something good. click here

    ReplyDelete
  11. Johnny September 19, 2021 at 12:48 AM

    You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. インドの観光ビザ

    ReplyDelete
  12. article submission projectSeptember 25, 2021 at 5:47 AM

    This is also a very good post which I really
    enjoyed reading. It is not every day that I have the possibility to see
    something like this.. Khwab Ki Tabeer

    ReplyDelete
  13. Girl_seoOctober 5, 2021 at 12:53 AM

    aik daur tha jab meri soch main sirf best Chinese in Karachi aur best Pizza in Karachi aur best Steak in Karachi hua karta tha, aik dafa yeh ajeeb sa khana kha lo to ab inka competition nahi mil raha, Ridan house of Mandi bhi try kar liye. Kabsa Express duuuur duuur tak Best Yemeni Mandi in Karachhi hay
    mandi karachi

    ReplyDelete
  14. UnknownOctober 23, 2021 at 10:58 PM

    This is also a very good post which I really
    enjoyed reading. It is not every day that I have the possibility to see
    something like this. Ottoman Beds

    ReplyDelete
  15. http://atroventonline.info/not-known-details-about-hot-milf-hookup/March 17, 2022 at 6:06 PM

    You make so many great points here that I read your article a couple of times. This is great content for your readers.
    Real Estate Solutions

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innov...
Read more

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo...
Read more

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man...
Read more