{"id":3988,"date":"2023-07-05T14:37:55","date_gmt":"2023-07-05T14:37:55","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=3988"},"modified":"2026-01-20T16:12:56","modified_gmt":"2026-01-20T16:12:56","slug":"target-selection-and-expandcollapse-features-in-paw","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/","title":{"rendered":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)?"},"content":{"rendered":"

Target Selection and Expand&Collapse Features in PAW<\/strong><\/p>\n

Two new buttons have been introduced to the toolbar of IBM Planning Analytics Workspace (PAW) since version 87. The first button is for the \u201cTarget Selection\u201d feature and the second button is for the \u201cExpand&Collapse Rows and Columns\u201d feature. The new features make cube-view manipulation faster. They are often used in data analysis, report building, or dashboard building. This article covers sample use cases of the new features with detailed explanations.<\/p>\n

\"\"<\/p>\n

Two new buttons in PAW<\/em><\/p>\n

Target Selection<\/strong><\/p>\n

When a user stacks two dimensions together, PAW displays all elements of the two dimensions in a cube view. However, the user may want to show only some elements from each dimension in the view. The target selection feature\/button allows the user to create the view mentioned earlier.<\/p>\n

For example, a user wants to show the actual data from January to March and the forecast data for the rest of the year. This means that the user wants to display only three elements (Jan \u2013 Mar) for Actual, which is an element in the Versions dimension, while showing nine elements (Apr \u2013 Dec) for Forecast, which is also an element in the Versions dimension. Without the target selection feature, the user would see twelve months for Actual and the same twelve months for Forecast. The steps below show how to show only three months for Actual and nine months for Forecast.<\/p>\n

Step 1: Create a cube view with twelve months and two versions, Actual and Forecast.<\/p>\n

\"\"<\/p>\n

Twelve months in the Periods dimension<\/em><\/p>\n

\"\"<\/p>\n

Actual and Forecast in the Versions dimension<\/em><\/p>\n

\"\"<\/p>\n

Twelve months for Actual<\/em><\/p>\n

\"\"<\/em><\/p>\n

Twelve months for Forecast<\/em><\/p>\n

Step 2: Click the Target Selection button.<\/p>\n

\"\"<\/p>\n

Target Selection Button<\/em><\/p>\n

\"\"<\/p>\n

The numbers in the cube view become light gray<\/em><\/p>\n

Step 3: Hold the Ctrl key and click the columns (or rows) that you want to keep. In this example, Jan 2023 to Mar 2023 are selected for Actual and Apr 2023 \u2013 Dec 2023 are selected for Forecast.<\/p>\n

\"\"<\/p>\n

Jan 2023 \u2013 Mar 2023 are selected<\/em><\/p>\n

\"\"<\/em><\/p>\n

Apr 2023 \u2013 Dec 2023 are selected<\/em><\/p>\n

Step 4: Right click on any selected month and click Keep. The unselected months will disappear.<\/p>\n

\"\"<\/p>\n

Keep selected months<\/em><\/p>\n

Step 5: Review the result in the cube view.<\/p>\n

Note: The Target Selection feature is automatically turned off after the selected months are kept.<\/p>\n

\"\"<\/p>\n

Only selected months are kept in the view<\/em><\/p>\n

 <\/p>\n

Expand&Collapse Rows and Columns Asymmetrically or Symmetrically<\/strong><\/p>\n

The new Expand&Collapse feature in PAW works with stacked dimensions. Since the expand and collapse features work similarly, this article will mainly focus on expanding rows and columns. The new button to switch between asymmetrical and symmetrical expansion is located on the left of the sandbox button. Please see the new button in the screenshot below. By default, a user asymmetrically expands rows (or columns) in PAW. If a user wants to symmetrically expand a hierarchy, she can do so by switching to the symmetrical mode.<\/p>\n

\"\"<\/p>\n

Expand&Collapse Rows and Columns<\/em><\/p>\n

For example, the Overhead Costs Measures dimension is stacked with the Products dimension. If a user wants to expand \u201cAll Products\u201d for \u201cAvg OH Fixed Cost\u201d and \u201cOverhead Cost\u201d in the view below, the user will have to expand the product hierarchy twice in the asymmetric mode. If the user uses the Expand&Collapse button to switch to the symmetrical mode, the user will only click \u201cAll Products\u201d once and the product hierarchy for both \u201cAvg OH Fixed Cost\u201d and \u201cOverhead Cost\u201d will expand.<\/p>\n

\"\"<\/p>\n

Expand&Collapse is in the asymmetrical mode by default<\/em><\/p>\n

\"\"<\/p>\n

The asymmetrical mode allows one hierarchy to expand at a time<\/em><\/p>\n

If a user wants to change the expansion mode, the user will click the Expand&Collapse button and select the symmetrical mode.<\/p>\n

\"\"<\/p>\n

The symmetrical mode is selected <\/em><\/p>\n

The screenshot below shows the expansion of \u201cAll Products\u201d in the symmetrical mode.<\/p>\n

\"\"<\/p>\n

One click in the symmetrical mode expands the product hierarchy for both measures<\/em><\/p>\n

The Target Selection and Expand&Collapse features are incredibly useful in PAW. The Target Selection feature gives users the ability to choose what rows and columns are kept in a cube view. The Expand&Collapse feature provides greater control over expanding and collapsing a hierarchy in a cube view with stacked dimensions. The new features are easy to learn and yet very powerful.<\/p>\n","protected":false},"excerpt":{"rendered":"

Target Selection and Expand&Collapse Features in PAW Two new buttons have been introduced to the toolbar of IBM Planning Analytics Workspace (PAW) since version 87. The first button is for the \u201cTarget Selection\u201d feature and the second button is for the \u201cExpand&Collapse Rows and Columns\u201d feature. The new features make cube-view manipulation faster. They are…<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[77,76,70,36,51],"class_list":["post-3988","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-ibm","tag-pa","tag-paw","tag-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\nHow Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Target Selection and Expand&Collapse Features in PAW Two new buttons have been introduced to the toolbar of IBM Planning Analytics Workspace (PAW) since version 87. The first button is for the \u201cTarget Selection\u201d feature and the second button is for the \u201cExpand&Collapse Rows and Columns\u201d feature. The new features make cube-view manipulation faster. They are…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T14:37:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T16:12:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"598\" \/>\n\t<meta property=\"og:image:height\" content=\"114\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Patrick Quirke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patrick Quirke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/\"},\"author\":{\"name\":\"Patrick Quirke\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/51bf83d531948247370683787d0f46ff\"},\"headline\":\"How Do Target Selection and Expand\\\/Collapse Features Work in Planning Analytics Workspace (PAW)?\",\"datePublished\":\"2023-07-05T14:37:55+00:00\",\"dateModified\":\"2026-01-20T16:12:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/\"},\"wordCount\":724,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Picture1-300x57.png\",\"keywords\":[\"IBM\",\"PA\",\"PAW\",\"Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/\",\"name\":\"How Do Target Selection and Expand\\\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Picture1-300x57.png\",\"datePublished\":\"2023-07-05T14:37:55+00:00\",\"dateModified\":\"2026-01-20T16:12:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/51bf83d531948247370683787d0f46ff\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Picture1.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Picture1.png\",\"width\":598,\"height\":114},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/target-selection-and-expandcollapse-features-in-paw\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do Target Selection and Expand\\\/Collapse Features Work in Planning Analytics Workspace (PAW)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/51bf83d531948247370683787d0f46ff\",\"name\":\"Patrick Quirke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g\",\"caption\":\"Patrick Quirke\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/pquirke\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/","og_locale":"en_US","og_type":"article","og_title":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT","og_description":"Target Selection and Expand&Collapse Features in PAW Two new buttons have been introduced to the toolbar of IBM Planning Analytics Workspace (PAW) since version 87. The first button is for the \u201cTarget Selection\u201d feature and the second button is for the \u201cExpand&Collapse Rows and Columns\u201d feature. The new features make cube-view manipulation faster. They are…","og_url":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/","og_site_name":"QueBIT","article_published_time":"2023-07-05T14:37:55+00:00","article_modified_time":"2026-01-20T16:12:56+00:00","og_image":[{"width":598,"height":114,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1.png","type":"image\/png"}],"author":"Patrick Quirke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patrick Quirke","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/"},"author":{"name":"Patrick Quirke","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/51bf83d531948247370683787d0f46ff"},"headline":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)?","datePublished":"2023-07-05T14:37:55+00:00","dateModified":"2026-01-20T16:12:56+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/"},"wordCount":724,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1-300x57.png","keywords":["IBM","PA","PAW","Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/","url":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/","name":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1-300x57.png","datePublished":"2023-07-05T14:37:55+00:00","dateModified":"2026-01-20T16:12:56+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/51bf83d531948247370683787d0f46ff"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/06\/Picture1.png","width":598,"height":114},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/target-selection-and-expandcollapse-features-in-paw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do Target Selection and Expand\/Collapse Features Work in Planning Analytics Workspace (PAW)?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/51bf83d531948247370683787d0f46ff","name":"Patrick Quirke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c2c5ed78cce873ccf3eb420007d81d4fcdacb9bf4936d8b0b463390b69fd05ff?s=96&d=mm&r=g","caption":"Patrick Quirke"},"sameAs":["https:\/\/quebit.com\/askquebit\/"],"url":"https:\/\/quebit.com\/askquebit\/author\/pquirke\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3988"}],"version-history":[{"count":3,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3988\/revisions"}],"predecessor-version":[{"id":5086,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3988\/revisions\/5086"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}