Smart Chart Using Parameterized CDS View

5900

Smart Chart is a SAP UI5 Component that creates the chart based on OData Metadata and configuration provided. These charts are basically used for analytical purposes where user can switch between measures and dimensions. Smart chart can switch to the chart types, smart chart have sort, filter and much more capabilities. Simple to use and understand.

In this blog I am going to explain the Smart Chart implementation using Consumption CDS View with Parameters (CDS View Which have @OData.publish true Annotation).

Below is the link for Smart Chart reference
https://sapui5.netweaver.ondemand.com/sdk/#/api/sap.ui.comp.smartchart.SmartChart

Prerequisites:
To successfully run and use smart chart you would need the following

  • SAP WEB IDE account.
  • SAP HANA Cloud Platform account (HCP).

What is OData and how Smart Chart works using it.
OData (Open Data Protocol) is a used for creation and consumption of REST API’s. OData reads either a table(entity) or a HANA calculation view and then the OData can be exposed to public which can later be consumed by other applications based on the needs. Smart Chart or any other UI5 smart controls like smart field, smart table etc. are designed to work only with OData Metadata. The UI5 control uses the OData exposed URL and then the entity set from the metadata.xml is mapped to smart chart view. Smart Chart will not work with only OData Metadata.xml in addition it requires some Annotations.

@Analytics.query : The query view will be exposed to the analytic manager. The default is true if this annotation is used.

Enable application developers to specify the default multidimensional layout of the query, the sequence of variables in UI consumption, and the specific aggregation and planning behavior of the data. All these annotations can only be used in views with @Analytics.query : true.

CDS Consumption View for OData Service which is used for Smart Chart

Smart Chart CDS View

Smart Chart CDS View1

Smart Chart CDS View2

Instantiate OData Model

Smart Chart CDS View3

Here we are using single call, so I used useBatch as false, but Smart Chart allows Batch calls also. We need to pass serviceUrl to the OData Model. Here we are not taking any file locally for storing annotations like local annotation.xml because annotations directly fetched from CDS view. By using Annotations in the CDS View we handle the smart chart and we must pass annotationURI to the OData Model then only annotations which maintained in the CDS View will be fetched. We must set this OData Model to any smart control or view here we set OData Model to View.We must create Smart Chart Control like this. Here we took smart chart control instance from the view by using Smart Chart Control ID.

Smart Chart CDS View4

We set our CDS View as entity set to OData Model like this.
let sEntitySet = “ZLG_GTN_SMART_CHART”;
oBindingParams.parameters. entitySet = sEntitySet.

In this Smart chart we want to show only data of Sales Organization which is having value has 1710 for this we must prepare filter according to our requirement.
const aFilters = [new sap.ui.model.Filter(“SalesOrganization”,sap.ui.model.FilterOperator.EQ, “1710”) ];

We must pass filters like this.
oBindingParams.filters.push(…aFilters);

We pass parameters to the CDS View along with the entity path
let sEntityPath = “/ZLG_GTN_SMART_CHART(VALIDITY_DATE=datetime’2020-04-10T14:49:52′) /Results?”;

Create SMART CHART control in XML view

Smart Chart CDS View5

Smart chart will be render entity set that we specify in the Smart chart control itself by using entitySet property. Smart chart is the container for charts in the SAP UI5 we can show particular chart in the smart chart by telling chart type property in the smart chart itself.

Column chart by using smart chart

Smart Chart CDS View6

Heap chart by using smart chart

Smart Chart CDS View7

 

5,900 Comments

  1. vardenafil buy on

    A lot of thanks for all your efforts on this site. Gloria enjoys doing investigation and it’s easy to understand why. Almost all know all concerning the dynamic means you deliver great information on the web blog and as well encourage contribution from other people on that concept plus our daughter is actually being taught a lot. Have fun with the remaining portion of the new year. You’re the one conducting a glorious job. https://joneslawncarela.com/

  2. I’m just writing to make you know what a notable encounter my wife’s girl had studying your web site. She mastered several pieces, which include what it’s like to possess an awesome helping nature to let other individuals with ease know precisely some problematic subject matter. You truly exceeded people’s expectations. Thank you for producing these practical, trusted, informative and in addition fun tips about this topic to Kate. https://johnpisanohomeimprovements.com/

  3. vardenafil no rx on

    I enjoy you because of all of the effort on this blog. Betty delights in carrying out internet research and it’s easy to see why. A lot of people hear all about the compelling form you convey both interesting and useful guidelines by means of the blog and attract contribution from other individuals about this area and my child has always been becoming educated a great deal. Enjoy the remaining portion of the new year. You’re carrying out a dazzling job. https://joneslawncarela.com/

  4. purchase tadalafil on

    I am commenting to let you know of the fantastic encounter my cousin’s daughter experienced reading your site. She even learned many issues, not to mention what it’s like to have a wonderful giving mindset to have many people quite simply grasp chosen grueling subject areas. You really exceeded our expectations. Many thanks for giving the informative, healthy, educational and as well as easy thoughts on the topic to Jane. https://hillsdaledowcenter.com/

  5. I’m commenting to let you be aware of of the beneficial discovery my child developed browsing the blog. She came to find a good number of details, including how it is like to have a great coaching character to get certain people completely comprehend a number of complex issues. You actually did more than her desires. I appreciate you for coming up with such effective, dependable, edifying and cool guidance on that topic to Emily. https://azzaroelectric.com/

  6. Thanks for your entire labor on this web site. My mother take interest in participating in research and it is easy to see why. A number of us hear all about the compelling manner you create effective guides by means of the blog and boost contribution from other ones about this area of interest and my child has been becoming educated a great deal. Enjoy the remaining portion of the new year. You’re carrying out a fabulous job. https://harrington-service.com/

  7. I’m just commenting to let you be aware of of the extraordinary discovery my cousin’s daughter enjoyed going through your blog. She discovered lots of issues, most notably how it is like to have a very effective giving heart to have many others effortlessly gain knowledge of certain extremely tough matters. You really did more than my desires. Many thanks for displaying the helpful, healthy, educational and also easy thoughts on the topic to Gloria. https://harrington-service.com/

  8. order ARIPIPRAZOLE on

    I am only writing to make you understand what a remarkable experience our princess undergone viewing your webblog. She picked up some things, which included what it is like to possess an ideal teaching spirit to make the mediocre ones without difficulty master specified tortuous things. You undoubtedly surpassed readers’ expected results. Thanks for rendering those useful, trustworthy, revealing as well as unique tips on your topic to Mary. https://abilifyaripiprazoles.com/

  9. My husband and i felt now excited Emmanuel could conclude his investigation from your ideas he gained in your site. It’s not at all simplistic just to choose to be giving for free information that most people have been making money from. And we all do understand we have the website owner to be grateful to because of that. The explanations you’ve made, the easy site menu, the friendships you can give support to engender – it’s everything extraordinary, and it’s facilitating our son and our family feel that that idea is enjoyable, and that is highly important. Many thanks for all the pieces! https://asendinamoxapine.com/

  10. I precisely had to appreciate you all over again. I’m not certain the things I might have done in the absence of the actual hints discussed by you concerning such field. It actually was a real difficult condition for me personally, but discovering a new professional fashion you handled it forced me to jump for delight. I’m just happier for the guidance and as well , have high hopes you comprehend what a powerful job you’re carrying out instructing most people through your blog. I am sure you’ve never encountered all of us. https://pamelornortriptyline.com/

  11. endep without a prescription on

    I enjoy you because of all of the effort on this blog. Betty delights in carrying out internet research and it’s easy to see why. A lot of people hear all about the compelling form you convey advantageous guidance by means of the blog and attract contribution from other individuals about this area and my child has always been becoming educated a great deal. Enjoy the remaining portion of the new year. You’re carrying out a brilliant job. https://endepamitriptyline.com/

  12. I am just writing to make you understand what a magnificent encounter my wife’s girl had studying your web site. She mastered several pieces, which include what it’s like to possess an awesome helping nature to let other individuals very easily know precisely some multifaceted subject matter. You truly exceeded people’s expectations. Thank you for presenting these powerful, trusted, informative and in addition fun tips about this topic to Kate. https://lexaproescitalopram.com/

  13. I’m also commenting to let you be aware of of the excellent discovery my cousin’s child enjoyed checking your blog. She discovered a wide variety of details, most notably how it is like to have a marvelous coaching heart to get many more easily fully understand certain complicated matters. You actually did more than my desires. I appreciate you for delivering such great, healthy, educational and also cool guidance on that topic to Evelyn. https://paxilparoxetines.com/

  14. bupropion cheap on

    I am just writing to make you understand what a notable experience my wife’s girl had using your web site. She mastered so many pieces, which included what it is like to possess an excellent helping nature to let other people with ease learn some problematic things. You truly surpassed people’s expected results. Thank you for producing these precious, trusted, informative and in addition fun tips about this topic to Lizeth. https://wellbutrinbupropions.com/#

  15. bupropion price on

    I am only writing to make you understand what a superb experience our princess undergone viewing yuor web blog. She picked up such a lot of things, with the inclusion of what it is like to possess an ideal teaching style to make the others without hassle thoroughly grasp specified tricky topics. You undoubtedly surpassed visitors’ expected results. Thanks for showing those valuable, trustworthy, revealing not to mention unique tips on your topic to Sandra. https://wellbutrinbupropions.com/#

  16. olanzapine cost on

    Thanks for the useful information on credit repair on your web-site. The thing I would offer as advice to people will be to give up a mentality they will buy at this moment and pay back later. As being a society most people tend to repeat this for many factors. This includes family vacations, furniture, plus items we really want to have. However, you must separate a person’s wants from the needs. When you’re working to fix your credit score you really have to make some trade-offs. For example you possibly can shop online to economize or you can click on second hand suppliers instead of highly-priced department stores to get clothing. https://zyprexaolanzapine.com/#

  17. venlor venlafaxine on

    Thank you for each of your hard work on this web page. My aunt really likes making time for investigations and it’s really obvious why. Most of us learn all of the lively method you offer precious suggestions through this web site and even increase participation from some other people on the matter so our favorite girl is now learning a lot of things. Take advantage of the rest of the year. You are always doing a really great job. https://venlorz.com/#

  18. order seroquel on

    I am commenting to let you know of the fantastic encounter my cousin’s daughter experienced reading your site. She even learned many issues, not to mention what it’s like to have a wonderful giving mindset to have many people quite simply grasp chosen grueling subject areas. You really exceeded our expectations. Many thanks for giving the informative, healthy, educational and as well as easy thoughts on the topic to Jane. https://seroquelquetiapine.com/#

  19. szybkie termometry medyczne on

    Dzięki za przydatnych informacji na temat naprawy kredytu na temat twojego sieci -teren. To, co chciałbym zaoferować jako rada ludziom będzie zrezygnować z a mentalności kupią w tej chwili i spłać później. as be a as be a} społeczeństwo {my|my wszyscy|my wszyscy|wielu z nas|większość z nas|większość ludzi} ma tendencję do {robienia tego|robienia tamtego|próbowania tego|zdarzyć się|powtórz to} dla wielu {rzeczy|problemów|czynników}. Obejmuje to {wakacje|wakacje|wypady|wyjazdy wakacyjne|wycieczki|rodzinne wakacje}, meble, {i|jak również|a także|wraz z|oprócz|plus} przedmiotów {chcemy|chcielibyśmy|życzymy|chcielibyśmy|naprawdę chcielibyśmy to mieć}. Jednak {musisz|musisz|powinieneś|powinieneś chcieć|wskazane jest, aby|musisz} oddzielić {swoje|swoje|to|twoje obecne|swoje|osoby} chcą {od wszystkich|z potrzeb|z}. {Kiedy jesteś|Kiedy jesteś|Kiedy jesteś|Jeśli jesteś|Tak długo, jak jesteś|Kiedy} pracujesz, aby {poprawić swój kredyt|poprawić swoją zdolność kredytową|zwiększyć swój kredyt|zwiększyć swój kredyt|podnieś swój ranking kredytowy|popraw swój kredyt} wynik {musisz zrobić|zrobić|faktycznie potrzebujesz|naprawdę musisz} dokonać kilku {poświęceń|kompromisów}. Na przykład {możesz|możesz|możesz|możesz|będziesz mógł|| możesz|prawdopodobnie możesz} robić zakupy online {aby zaoszczędzić pieniądze|aby zaoszczędzić pieniądze|aby zaoszczędzić} lub {możesz przejść do|może się zwrócić|może odwiedzić|może obejrzeć|może sprawdzić|może kliknąć} używane {sklepy|sklepy|detaliści|sprzedawcy|punkty sprzedaży|dostawcy} zamiast {drogie|drogie|drogie|drogie|drogie|drogich} domów towarowych {dla|w odniesieniu do|dotyczących|odnoszących się do|przeznaczonych dla|do zdobycia} odzieży {termometr bezdotykowy|termometry bezdotykowe|termometry bezdotykowe ranking|termometr do czoła|termometry do czoła|termometr bezkontaktowy|termometry bezkontaktowe|termometr koronawirus|termometr|termometr na podczerwień|termometry na podczerwień|termometr lekarski|termometry lekarskie|szybki termometr medyczny|szybkie termometry medyczne}. https://termometryn.pl/

  20. strzykawki trzyczęściowe tuberkulinowe on

    Dzięki za porad dotyczących naprawy kredytu na temat tego wspaniałego witryny. Kilka wskazówek i chciałbym powiedzieć ludziom powinno być to zrezygnować z konkretnej mentalności że mogą obecnie i wypłać później. Being a as be a} społeczeństwo {my|my wszyscy|my wszyscy|wielu z nas|większość z nas|większość ludzi} ma tendencję do {robienia tego|robienia tamtego|próbowania tego|zdarzyć się|powtórz to} dla wielu {rzeczy|problemów|czynników}. Obejmuje to {wakacje|wakacje|wypady|wyjazdy wakacyjne|wycieczki|rodzinne wakacje}, meble, {i|jak również|a także|wraz z|oprócz|plus} przedmiotów {chcemy|chcielibyśmy|życzymy|chcielibyśmy|naprawdę chcielibyśmy to mieć}. Jednak {musisz|musisz|powinieneś|powinieneś chcieć|wskazane jest, aby|musisz} oddzielić {swoje|swoje|to|twoje obecne|swoje|osoby} chcą {od wszystkich|z potrzeb|z}. {Kiedy jesteś|Kiedy jesteś|Kiedy jesteś|Jeśli jesteś|Tak długo, jak jesteś|Kiedy} pracujesz, aby {poprawić swój kredyt|poprawić swoją zdolność kredytową|zwiększyć swój kredyt|zwiększyć swój kredyt|podnieś swój ranking kredytowy|popraw swój kredyt} wynik {musisz zrobić|zrobić|faktycznie potrzebujesz|naprawdę musisz} dokonać kilku {poświęceń|kompromisów}. Na przykład {możesz|możesz|możesz|możesz|będziesz mógł|| możesz|prawdopodobnie możesz} robić zakupy online {aby zaoszczędzić pieniądze|aby zaoszczędzić pieniądze|aby zaoszczędzić} lub {możesz przejść do|może się zwrócić|może odwiedzić|może obejrzeć|może sprawdzić|może kliknąć} używane {sklepy|sklepy|detaliści|sprzedawcy|punkty sprzedaży|dostawcy} zamiast {drogie|drogie|drogie|drogie|drogie|drogich} domów towarowych {dla|w odniesieniu do|dotyczących|odnoszących się do|przeznaczonych dla|do zdobycia} odzieży {strzykawki insulinowe 1ml|strzykawki tuberkulinowe|strzykawki|strzykawka|strzykawki insulinowe|strzykawki do insuliny|strzykawki trzyczęściowe tuberkulinowe|strzykawka tuberkulinowa|strzykawka insulinowa|strzykawka do insuliny|strzykawka trzyczęściowe tuberkulinowa}. https://strzykawkin.pl/

  21. doctorhims.com on

    Can you lease sildenafil with alcohol. buy viagra over the counter uk tenable cannot save an erection after binge drinking. Anyway, run demon rum consumption should not affect getting an erection. Viagra should work as intended with moderate john barleycorn intake. Entire, it is justifiable to split a hire viagra without a doctor prescription viagra samples from doctor and spirits together.

  22. viagrakurka.com on

    How hanker after eating Can I take generic viagra. Timing matters. You need to delineate for a lowest of two hours between the last item you eat and ingesting the tablet. The dose viagra cialis viagra dosage should be taken people hour before sexual activity.

  23. Türkiye de bir çok kullanıcının istemekte olduğu üstelik Türkiyenin heryerinde yoğun bir ilginin söz hususu bulunduğu
    hizmetlerdendir.
    Instagram platformlarına ilginin yükselmesi ile beraber İnstagram da en mühim seçeneklerden biri durumuna gelmiştir.

    Bu bağlamda takipçi miktarını yükselterek tesir oranını çoğaltmak isteyen pek çok şahıs bulunmaktadır.

    Sizde Türkiye de ki bu ünlü olan yada olmak isteyen kişiler gibi hemen instagram takipçi satın al diye
    google de arayarak
    takip2018 den takipçi alabilirsiniz

    .

  24. I believe everything posted was very logical. But, consider this, what if
    you composed a catchier post title? I mean, I don’t wish to
    tell you how to run your blog, however suppose you added a
    post title that grabbed folk’s attention? I mean Smart Chart Using
    Parameterized CDS View – Pivox Labs Blog is a little vanilla.

    You could glance at Yahoo’s front page and see how they create post titles to grab people to click.

    You might add a related video or a related picture or two to grab people interested about everything’ve written. Just my
    opinion, it would make your blog a little livelier.

    Look into my web-site … takipçi satan adam

  25. That is a great tip particularly to those new to the blogosphere.
    Short but very precise information… Appreciate your sharing this one.

    A must read post!

    My web page; Shell Download

  26. Pingback: sildenafil 10 mg price

  27. Pingback: walmart otc cialis

  28. Pingback: generic viagra 100mg for sale

  29. Pingback: price for sildenafil 20 mg

  30. Pingback: sildenafil soft gel

  31. Pingback: viagra 100mg price canada

  32. 스피드바카라 on

    I would like to thank you for the efforts you have made in writing this article.

    스피드바카라

    Greetings! Very helpful advice in this particular article!
    It is the little changes that make the greatest changes.
    Thanks a lot for sharing!

  33. Pingback: how often to take amoxicillin

  34. instagram video izlenme satın al on

    I follow all the installation instructions, after downloading, but Mozilla Firefox blocks the installation..

  35. Pingback: amoxicillin and advil

  36. instagram video izlenme hilesi on

    Actually my blog name is not relevant to my blog niche..in this time i want to convert my blog to a website through blogger. but i dont know if i will do it ,then how much will affect my blog traffic?.

  37. Pingback: azithromycin and antacids

  38. Pingback: eliquis and celebrex

  39. Pingback: uses celecoxib

  40. Pingback: shelf life liquid keflex

  41. Pingback: is keflex safe in pregnancy

  42. Pingback: duloxetine suspension

  43. Pingback: cymbalta manufadturer

  44. Pingback: sildenafil tablets 150mg

  45. Pingback: teva generic cialis australia

  46. Pingback: cheap cialis pills australia

  47. Pingback: viagra reviews reddit south africa

  48. Pingback: buying viagra tablet low cost

  49. Pingback: low cost viagra buying tablets

  50. Pingback: cialis online purchase

  51. Pingback: cartoon florida redrawn viagra

  52. Pingback: buy generic viagra 50mg

  53. Pingback: cialis generico teva

  54. Pingback: achat de cialis generic

  55. Pingback: tadalafil efficacia

  56. Pingback: buying cialis cheap usnyc

  57. Pingback: whitney wright viagra

  58. Pingback: cialis otc status

  59. Pingback: price viagra 100mg

  60. Pingback: comprar viagra online

  61. Pingback: cialis not working first time australia

  62. Pingback: cheapest sildenafil 50 mg

  63. Pingback: generic viagra dosage australia

  64. Pingback: generic cialis 200mg

  65. Pingback: comprar sildenafil

  66. Pingback: viagra 50 mg coupon

  67. Pingback: female viagra in bangkok

  68. Pingback: cialis experience forum australia

  69. Pingback: online viagra usa

  70. Pingback: cialis otc us

  71. Pingback: how usde porn movies all viagra tablets

  72. GO!!!
    This phrase was said by the first cosmonaut on Earth – Yuri Gagarin. (Yuri Gagarin)
    He was the first astronaut on Earth. He was Russian! …
    Now Russia is becoming a strong country, gas pipelines, a vaccine against COVID-19, an army.
    Is this very reminiscent of the communist Soviet Union?
    How do you think?
    Now we have total control in our country. I am interested in the opinion of foreigners.

    Албонумисматико

    ПОЕХАЛИ!!

  73. Pingback: Zakhar Berkut hd

  74. GO!!!
    This phrase was said by the first cosmonaut on Earth – Yuri Gagarin. (Yuri Gagarin)
    He was the first astronaut on Earth. He was Russian! …
    Now Russia is becoming a strong country, gas pipelines, a vaccine against COVID-19, an army.
    Is this very reminiscent of the communist Soviet Union?
    How do you think?
    Now we have total control in our country. I am interested in the opinion of foreigners.

    Албонумисматико

    ПОЕХАЛИ!!

  75. I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get setup?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet savvy so I’m not 100% positive.

    Any recommendations or advice would be greatly appreciated.
    Thank you

    Here is my web-site instagram takipçi satın al

  76. It is in reality a nice and useful piece of information. I am satisfied that you simply
    shared this helpful info with us. Please keep us up to date like this.

    Thanks for sharing.

    Here is my web page; Ko Cuce

  77. This design is incredible! You obviously know how to keep a
    reader entertained. Between your wit and your videos, I was almost
    moved to start my own blog (well, almost…HaHa!) Wonderful
    job. I really loved what you had to say, and more than that, how you presented it.
    Too cool!

    Take a look at my site php shell

  78. Türkiyenin en güvenilir takipçi satın alma sitesinden en uygun fiyatlara takipçi satın alabilirsiniz, Takipçi satın alma
    işlemlerinde sizden kesinlikle şifre istemiyoruz Instagram, twitter,
    tiktok gibi soysal meyda platformların da takipçilerinizi arttırmak için artık uzun uzun beklemeye ve sürekli post paylaşmanıza gerek yok.
    Instagram takipçi satın alarak sıfır dan gerçek ve Türk takipçilere sahip
    olabilirsiniz. Sitemiz de bot takipçi satışı yoktur.

    Takipçi SATIN AL için takip2018 i Herkes tercih ediyor!

  79. Hello, i think that i saw you visited my site thus i came to “return the favor”.I am attempting to find things to improve
    my web site!I suppose its ok to use a few of your ideas!!

    My site :: Böcek ilaçlama

  80. Pingback: sildenafil pde4 inhibitor

  81. Pingback: stromectol online bestellen

  82. Pingback: tinderentrar.com

  83. En iyi Leke Kremi, Leke Kremi

    Cilt lekelerinin bir çok türü vardır sadece güneş, doğum ve sivilce lekeleri sıklıkla karşılaştığımız leke türleridir
    3. Özellikle ozon tabakasının giderek hasar görmesiyle UV ışınlarının zararlı etkilerine maruz kalma riskimiz artmıştır.

    3Güneş dolaysıcaklıkyla da ultraviyole ışınları lekelerin oluşmasında ya da koyulaşmasında en önemli etkenlerden biridir.

    Yüzümüzde ortaya çıkan lekeler ara sıra
    dış imajmüzü ve psikolojimizi olumsuz etkisinde
    bırakır.

    o halde hemen EN iyi leke kremi ile tanışmalısınız..

  84. Pingback: cialis from usa without a prescription?

  85. Pingback: viagra without dr prescription

  86. Pingback: viagra without a prescription