

{"id":2905,"date":"2015-10-29T07:32:21","date_gmt":"2015-10-29T06:32:21","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=2905"},"modified":"2015-10-29T07:32:21","modified_gmt":"2015-10-29T06:32:21","slug":"sap-businessobjects-design-studio-1-6-preview","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/sap-businessobjects-design-studio-1-6-preview","title":{"rendered":"SAP BusinessObjects Design Studio 1.6 Preview"},"content":{"rendered":"<p><strong>SAP BusinessObjects\u00a0Design Studio 1.6<\/strong> is coming up later this quarter so it is time to do a little previewing! You can find the full roadmap for\u00a0Design Studio <a href=\"https:\/\/service.sap.com\/~sapidb\/011000358700000390622012D.pdf\" target=\"_blank\">here<\/a>. Below I&#8217;ll discuss the highlights of all the new features that we can expect.<\/p>\n<h4>New Scorecard component<\/h4>\n<p>Design Studio 1.6 brings a new component that we have seen before in Xcelsius (SAP BusinessObjects Dashboards): the Scorecard component, or formatted table. This component can display multiple visualizations on a single table row. A table can display multiple of these rows, for example for each product type or region a separate row. We can show simple numbers but also charts (micro charts\/trend lines without x\/y-axis). Exceptions as defined in the underlying BEx Query can be shown as trend icons, colored text or colored cell backgrounds.<\/p>\n<p>Very\u00a0very useful if you want to display a lot of performance indicators in a compact way. Should also be easy to develop as you now only need a single scorecard component to achieve this, instead of using multiple text, chart etc. components to to the same.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2915\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1-1024x618.png\" alt=\"ds16_1\" width=\"1024\" height=\"618\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1-1024x618.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1-150x90.png 150w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1-300x181.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_1.png 1512w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>New Spreadsheet component<\/h4>\n<p>A bit of a surprise is this new Spreadsheet component. It has the same functionality as the Crosstab component, so it can display data and has a context menu with all the OLAP features (filter, sort etc.). Difference is that you can now copy and paste data to and from this component. This is meant for planning scenarios, where you have to enter values (the planning template also uses the spreadsheet component). Now you can copy the data from a\u00a0Design Studio app to Excel, make some adjustments there, and copy and paste them back into the spreadsheet component in the\u00a0Design Studio app and use the planning functionality to save the data. The component also really looks like a familiar spreadsheet environment as in MS Excel, so that is also a plus. There is no info on using formulas or such as we are used to in Excel.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2916\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2-1024x448.png\" alt=\"ds16_2\" width=\"1024\" height=\"448\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2-1024x448.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2-150x66.png 150w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2-300x131.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_2.png 1198w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>Geo pie charts<\/h4>\n<p>You can now use custom point markers (images) in the\u00a0Geo Map component. Also pie charts can be plotted on the geo layers. Don&#8217;t use this, as pie charts suck.<!--more--><\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2917\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3-1024x721.png\" alt=\"ds16_3\" width=\"1024\" height=\"721\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3-1024x721.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3-128x90.png 128w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3-300x211.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_3.png 1290w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>Info charts + Chart feeding component<\/h4>\n<p>Design Studio 1.6 introduces a totally new charting component called the Info chart. The old chart component is still there, but for new developments we should use the new component. It has new chart types (bullet, combo, stacked), a context menu and support for BEx Query exceptions. It also supports the trellis chart feature we know from SAP Lumira, where you get multiple versions of the same chart to show\u00a0different parts of a dataset.<\/p>\n<p>The Chart feeding component lets the user set up a chart (Info chart) themselves on runtime.<\/p>\n<p>So it&#8217;s a bit weird that they introduce a new component instead of updating the existing one, but anyway, more consistency in looks and usability between different applications (Lumira\/Design Studio) is always a good thing.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2918\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4-1024x769.png\" alt=\"ds16_4\" width=\"1024\" height=\"769\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4-1024x769.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4-120x90.png 120w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4-300x225.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_4.png 1220w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>More context menu options in cross tab\/spreadsheet<\/h4>\n<p>End users can now add an additional column to a table\u00a0with a different aggregation of a measure. These are the options:<\/p>\n<ul>\n<li>Moving minimum value<\/li>\n<li>Moving maximum value<\/li>\n<li>Accumulative Sum<\/li>\n<li>Accumulative Sum of Rounded Values<\/li>\n<li>Accumulative Count of All Values<\/li>\n<li>Accumulative Count of All Values that are Not Zero, Null or Error<\/li>\n<li>Moving Average<\/li>\n<li>Moving average for values that are not zero, null or error<\/li>\n<li>Rank number<\/li>\n<li>Olympic Rank Number<\/li>\n<li>Percentage Contribution<\/li>\n<\/ul>\n<p>Users can also create a new calculated measure (column) based on two other measures. The options for this are:<\/p>\n<ul>\n<li>Add<\/li>\n<li>Substract<\/li>\n<li>Multiply<\/li>\n<li>Divide<\/li>\n<li>Percentage Difference<\/li>\n<li>Percentage Share<\/li>\n<\/ul>\n<p>In later releases a real formula editor will be added. So this is a nice first start, but probably a bit too limited\/simple to be really useful. The column names of these new columns can be edited by the way. Another new feature is that end users can create top\/bottom N filters on measures.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2919\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5-1024x835.png\" alt=\"ds16_5\" width=\"1024\" height=\"835\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5-1024x835.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5-110x90.png 110w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5-300x245.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5-245x200.png 245w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_5.png 1216w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>Prototyping<\/h4>\n<p>In local mode it is possible to use a CSV-file to load data for prototyping. It is even an option to download SAP BW data and use that for your prototype. This is great! This was always an important feature of Xcelsius, where it was easy to enter some dummy data in the spreadsheet to quickly create a good looking dashboard prototype.<\/p>\n<h4>Integrated CSS editor<\/h4>\n<p>We can finally edit and upload\/update the custom CSS file from within the\u00a0Design Studio client tool, instead of having to use Notepad++ or another CSS editor and manually upload the file to the BI Platform after each edit. Excellent!<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2920\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6-1024x900.png\" alt=\"ds16_6\" width=\"1024\" height=\"900\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6-1024x900.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6-102x90.png 102w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6-300x264.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_6.png 1126w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>Miscellaneous<\/h4>\n<p>This one has been on my wish list for a long time: Drag &amp; Drop between the Navigation Panel and the Crosstab or Spreadsheet component is finally available. This means that the functionality as we know it from BEx Web\/Analysis can now be fully replicated with a\u00a0Design Studio application.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2921\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7-1024x664.png\" alt=\"ds16_7\" width=\"1024\" height=\"664\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7-1024x664.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7-139x90.png 139w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7-300x194.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_7.png 1318w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Export functionality has been improved a bit: Export to PDF now supports multi-panels and Export to Excel\/CSV includes hierarchies.<\/p>\n<p>There are two more new components that we\u00a0know from\u00a0SAP BusinessObjects Dashboards: Timer and Tree component. The Timer component can trigger scripts at a set interval, for example the refresh of a data source. The Tree component can display hierarchical structures.<\/p>\n<p>An icon library is now included.<\/p>\n<p><a href=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-2922\" src=\"http:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8-1024x805.png\" alt=\"ds16_8\" width=\"1024\" height=\"805\" srcset=\"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8-1024x805.png 1024w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8-114x90.png 114w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8-300x236.png 300w, https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/ds16_8.png 1216w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h4>Conclusion<\/h4>\n<p>This is a great update and I can&#8217;t wait to try it out! Good stuff. For the next version I expect more on the Geo Map component, commenting in combination with BI4.2 and the formula editor for adding new measures and manipulating data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SAP BusinessObjects\u00a0Design Studio 1.6 is coming up later this quarter so it is time to do a little previewing! You can find the full roadmap for\u00a0Design Studio here. Below I&#8217;ll discuss the highlights of all the new features that we can expect. New Scorecard component Design Studio 1.6 brings a new component that we have [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[163],"tags":[296],"class_list":["post-2905","post","type-post","status-publish","format-standard","hentry","category-sap-businessobjects-design-studio","tag-sap-businessobjects-design-studio"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-KR","jetpack-related-posts":[{"id":2871,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-1-5-preview","url_meta":{"origin":2905,"position":0},"title":"Design Studio 1.5 Preview","author":"Xavier Hacking","date":"May 16, 2015","format":false,"excerpt":"Later this quarter the next big\u00a0SAP BusinessObjects\u00a0Design Studio update will be generally available: version 1.5. Let's have a look at what we can expect in this edition. Performance, performance, performance Despite the fact that\u00a0Design Studio is\u00a0developed in\u00a0a much more future proof way than\u00a0SAP BusinessObjects Dashboards (Xcelsius), it still appears to\u2026","rel":"","context":"In &quot;Preview&quot;","block_context":{"text":"Preview","link":"https:\/\/www.hackingsap.com\/blog\/category\/preview"},"img":{"alt_text":"Design-Studio-1.5-3","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Design-Studio-1.5-3.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2314,"url":"https:\/\/www.hackingsap.com\/blog\/getting-started-with-design-studio-book-now-available-coupon-code-in-post","url_meta":{"origin":2905,"position":1},"title":"Getting Started with Design Studio book now available (coupon code in post!)","author":"Xavier Hacking","date":"November 14, 2013","format":false,"excerpt":"Getting Started with\u00a0SAP BusinessObjects\u00a0Design Studio is available for order right now! If you haven't picked it up at the SAP Press book stand at SAP TechEd Las Vegas or Amsterdam you can get your copy now at SAP-Press.com. Make sure you use coupon code\u00a0QR7N5G when finishing your order, which will\u2026","rel":"","context":"In &quot;Books&quot;","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"DesignStudioCover","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DesignStudioCover-288x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3022,"url":"https:\/\/www.hackingsap.com\/blog\/sapinsider-qa-on-design-studio-1-6","url_meta":{"origin":2905,"position":2},"title":"SAPinsider Q&#038;A webinar on Design Studio 1.6","author":"Xavier Hacking","date":"March 20, 2016","format":false,"excerpt":"Jeroen and I are doing a Q&A webinar on\u00a0SAP BusinessObjects\u00a0Design Studio 1.6 hosted by SAPinsider.com Thursday next week (March 31). This webinar is free and you can already submit your questions at SAPinsider.com. The chat will start at 10.30AM EDT\/3.30PM GMT.\u00a0If you can\u2019t join us live, there will be a\u2026","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"SAPinsider logo","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/00082_sap_insider.gif?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2399,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-add-ons-graphomate-charts-2-0","url_meta":{"origin":2905,"position":3},"title":"Design Studio add-ons: Graphomate Charts 2.0","author":"Xavier Hacking","date":"December 26, 2013","format":false,"excerpt":"2014 is going to be a big year for\u00a0SAP BusinessObjects\u00a0Design Studio, especially since the recent 1.2 version of\u00a0Design Studio offers an SDK to create custom components. I expect to see a lot of cool new add-ons in the coming year. One of the first companies that created such an add-on\u2026","rel":"","context":"In &quot;Featured&quot;","block_context":{"text":"Featured","link":"https:\/\/www.hackingsap.com\/blog\/category\/featured"},"img":{"alt_text":"logo_gpm","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/logo_gpm.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2971,"url":"https:\/\/www.hackingsap.com\/blog\/sap-businessobjects-design-studio-the-comprehensive-guide-2nd-edition-coming-early-2016","url_meta":{"origin":2905,"position":4},"title":"SAP BusinessObjects Design Studio: The Comprehensive Guide (2nd edition) coming early 2016","author":"Xavier Hacking","date":"December 29, 2015","format":false,"excerpt":"SAP\u00a0Design Studio has changed and improved a lot over the past three years; arriving at version 1.6 last month. It was clear that our\u00a02013 book Getting Started with\u00a0SAP BusinessObjects\u00a0Design Studio needed a big update, as it included only the features up until Design Studio version 1.1. So the wait is\u2026","rel":"","context":"In &quot;Books&quot;","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"design_studio_boek2_2","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/design_studio_boek2_2-221x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2468,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-accepted-ideas-for-next-releases","url_meta":{"origin":2905,"position":5},"title":"Design Studio accepted ideas for next release(s)","author":"Xavier Hacking","date":"January 20, 2014","format":false,"excerpt":"SAP has this Idea Place website set up where users can submit ideas for new features or actually any change to an SAP product. Very few people know this but this site is actually quite useful. Users can vote and comment on each other's ideas and the top ideas will\u2026","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"Schermafbeelding 2014-01-20 om 21.17.20","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Schermafbeelding-2014-01-20-om-21.17.20.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/comments?post=2905"}],"version-history":[{"count":12,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2905\/revisions"}],"predecessor-version":[{"id":2925,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/2905\/revisions\/2925"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=2905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=2905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=2905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}