{"id":3166,"date":"2017-01-29T17:18:07","date_gmt":"2017-01-29T16:18:07","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=3166"},"modified":"2017-01-29T17:43:07","modified_gmt":"2017-01-29T16:43:07","slug":"design-studio-1-x-and-hierarchies-not-assigned-node-filtering","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/design-studio-1-x-and-hierarchies-not-assigned-node-filtering","title":{"rendered":"Design Studio 1.x and hierarchies: Not Assigned node filtering"},"content":{"rendered":"

In BW hierarchies, the values that are not assigned to a hierarchy node are gathered\u00a0under the Not Assigned<\/strong> node. The query output shows this node in the hierarchy on the same level as the top node of the hierarchy. This works the same for all SAP front-end tools that support hierarchies (Design Studio, Analysis for Office, BEx Analyzer, BEx Web Analyzer).<\/p>\n

So far so good. Last week I ran into an issue with filtering<\/strong> on these Not Assigned nodes in\u00a0Design Studio. The option just isn’t\u00a0available! The whole hierarchy is visible\u00a0in the filter menu, expect for the Not Assigned node! This happens both in prompt filters and the normal filters via a component (i.e. Dimension Filter or filtering via context-menu on Crosstab).<\/p>\n

Filter in BEx Web\u00a0Analyzer:<\/em><\/p>\n

\"Web<\/a><\/p>\n

Display and filter in\u00a0Design Studio:<\/em><\/p>\n

\"Design<\/a><\/p>\n

I found some old SAP Community topics<\/a> about this behavior and the issue seems to be floating around\u00a0for a while already (Design Studio 1.4, 1.5, 1.6, probably also earlier versions). Eventually\u00a0I got a statement from SAP Support that this is not a bug, but the feature to filter on Not Assigned nodes is by design not available due to performance reasons. In\u00a0Lumira 2.0 (expected this summer) it\u00a0will be possible to either suppress REST_H from the client,\u00a0or filter on it.<\/p>\n

For now,\u00a0the workaround I’m\u00a0using is as follows:<\/p>\n

    \n
  1. Add<\/strong> the dimension you want to filter\u00a0the Not Assigned node on, to the rows or columns of the Crosstab.<\/li>\n
  2. Make sure the hierarchy is active and the Not Assigned node is\u00a0displayed.<\/li>\n
  3. Right-click the Not Assigned node and select\u00a0Keep Member on Axis<\/strong>. To select multiple values; hold the\u00a0CTRL<\/strong>\u00a0key while selecting the values.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    In BW hierarchies, the values that are not assigned to a hierarchy node are gathered\u00a0under the Not Assigned node. The query output shows this node in the hierarchy on the same level as the top node of the hierarchy. This works the same for all SAP front-end tools that support hierarchies (Design Studio, Analysis for […]<\/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":[5,44,163],"tags":[],"class_list":["post-3166","post","type-post","status-publish","format-standard","hentry","category-featured","category-knowledge-sharing","category-sap-businessobjects-design-studio"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-P4","jetpack-related-posts":[{"id":2192,"url":"https:\/\/www.hackingsap.com\/blog\/sap-design-studio-and-conditions","url_meta":{"origin":3166,"position":0},"title":"SAP Design Studio and Conditions","author":"Xavier Hacking","date":"June 8, 2013","format":false,"excerpt":"I got an email this week by Ado A. from Atlanta, GA about an issue he has with SAP BusinessObjects Design Studio. He is trying to filter a set of data in Top N categories, for example to get the 10 regions with the highest sales numbers (Top 10). Unfortunately,\u2026","rel":"","context":"In "Knowledge sharing"","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"DScond1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DScond1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2871,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-1-5-preview","url_meta":{"origin":3166,"position":1},"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 "Preview"","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":937,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bex-analyzer-sucks","url_meta":{"origin":3166,"position":2},"title":"SAP: “BEx Analyzer sucks”","author":"Xavier Hacking","date":"November 17, 2010","format":false,"excerpt":"SAP released a video that basically says that BEx Analyzer sucks. And it's true.","rel":"","context":"In "SAP"","block_context":{"text":"SAP","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap"},"img":{"alt_text":"SAP BEx Sucks, SAP BusinessObjects Analysis rules","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapbex.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3212,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-businessobjects-analysis-office-the-comprehensive-guide","url_meta":{"origin":3166,"position":3},"title":"Book review: SAP BusinessObjects Analysis Office – The Comprehensive Guide","author":"Xavier Hacking","date":"May 24, 2017","format":false,"excerpt":"With all the buzz around the big upcoming Lumira 2 release, you would almost forget that there are other SAP BI tools in the market as well. For example Analysis for Office: the successor of the good old BEx Analyzer. For some reason these tools have\u00a0never been a very popular\u2026","rel":"","context":"In "Analysis for Office"","block_context":{"text":"Analysis for Office","link":"https:\/\/www.hackingsap.com\/blog\/category\/analysis-for-office"},"img":{"alt_text":"afobook","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/afobook-212x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2496,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-updated-roadmap-january-2014","url_meta":{"origin":3166,"position":4},"title":"Design Studio updated roadmap January 2014","author":"Xavier Hacking","date":"January 26, 2014","format":false,"excerpt":"SAP put a new and updated version of the\u00a0Design Studio roadmap online last week. These roadmaps are publicly available via the SAP Road Maps page on the SAP Service Marketplace: http:\/\/service.sap.com\/roadmap. A product road map describes how the feature\/function capabilities in an SAP product or technology are planned to progress\u2026","rel":"","context":"In "SAP BusinessObjects Design Studio"","block_context":{"text":"SAP BusinessObjects Design Studio","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-businessobjects-design-studio"},"img":{"alt_text":"dsroadmap1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/dsroadmap1-1024x738.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/dsroadmap1-1024x738.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/dsroadmap1-1024x738.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/dsroadmap1-1024x738.png?resize=700%2C400 2x"},"classes":[]},{"id":3508,"url":"https:\/\/www.hackingsap.com\/blog\/video-sap-analytics-cloud-data-analyzer-2019-14","url_meta":{"origin":3166,"position":5},"title":"Video: SAP Analytics Cloud Data Analyzer [2019.14]","author":"Xavier Hacking","date":"July 21, 2019","format":false,"excerpt":"SAP Analytics Cloud version 2019.14 introduces a new cool feature: the Data\u00a0Analyzer. With the Data Analyzer we can instantly report on BEx Queries in SAP Analytics Cloud, without having to create a model first (don't panic, HANA views are also on the roadmap). For those who have used the Lumira\u2026","rel":"","context":"In "SAP Analytics Cloud"","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/q_UtfZYqqhg\/0.jpg?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\/3166","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=3166"}],"version-history":[{"count":9,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3166\/revisions"}],"predecessor-version":[{"id":3179,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3166\/revisions\/3179"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=3166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=3166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=3166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}