{"id":3469,"date":"2023-04-12T15:33:22","date_gmt":"2023-04-12T15:33:22","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/"},"modified":"2026-01-20T16:23:48","modified_gmt":"2026-01-20T16:23:48","slug":"manipulating-an-exploration-view-in-planning-analytics-workspace","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/","title":{"rendered":"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)?"},"content":{"rendered":"

You can explore IBM Planning Analytics data using\u00a0Exploration Views<\/strong><\/a>. Using\u00a0Exploration Views, you can not only quickly change how you see data \u2013 you can also manipulate the data to better understand relationships within the data. Here are just a few techniques you can use to manipulate an Exploration view in Planning Analytics Workspace (PAW):<\/p>\n

To start, make sure that you are using an Exploration view by clicking on the visualization then (on the shortcut bar) <\/strong>picking Exploration<\/strong>:<\/p>\n

\"\"<\/p>\n

Summarize All<\/strong><\/p>\n

A summary calculation<\/strong> applies to all leaf members as well as all unexpanded consolidated members that are visible on a row or column and updates automatically as you change the members visible in the view. To create a summary calculation, you can:<\/p>\n

Right-click a row or column label and then click Calculations<\/strong>, then Summarize All:<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

On the Summarize ALL<\/strong> dialog you select the type of calculation you want to create and can enter a name for the calculation (this is the name that will appear as a row or column label in the view).<\/p>\n

\"\"<\/p>\n

Click OK<\/strong> and your Exploration will be updated to include the Summary Calculation<\/strong>:<\/p>\n

\"\"<\/p>\n

Sort Hierarchical<\/strong><\/p>\n

You can sort labels or values<\/strong> in ascending or descending order and can choose to sort by hierarchy, or to sort breaking the hierarchy. To sort by label<\/em>, right-click either the row selector , or the column selector , and select the sort option you want. To sort by value<\/em>, right-click in the row or column and select the sort option you want. To sort values within a hierarchy, right-click on the hierarchy label, select Sort hierarchical, then choose your option:<\/p>\n

\"\"<\/p>\n

Show Totals as Trailing<\/strong><\/p>\n

You can also show and hide totals<\/strong> in a view as well as choose whether totals are leading or trailing<\/strong>. To affect a total, you can right-click on either the row selector, or the column selector, and select one of the Show totals<\/strong> options. When you edit a set, you can click the Show Leading\/Show Trailing icon on the Set Editor to toggle the position of totals:<\/p>\n

\"\"<\/p>\n

\u00a0<\/strong>Expand to Level<\/strong><\/p>\n

You can expand levels in a dimensional hierarchy to a specific depth<\/em>. To select a specific level to expand from the menu you right-click a consolidated member that you want to expand then click Expand to level<\/strong>, then select the level you desire:<\/p>\n

\"\"<\/p>\n

Undo<\/strong><\/p>\n

Keep in mind that the Undo feature is always available on the shortcut bar. If you are experimenting with the above manipulations and don\u2019t like the result just click undo and start over.<\/p>\n

\"\"<\/p>\n

Final Thoughts<\/strong><\/p>\n

Are you interested in improving your skills with IBM Planning Analytics Workspace? Contact QueBIT<\/a> today. We would be happy to discuss your needs and offer recommendations.<\/p>\n","protected":false},"excerpt":{"rendered":"

You can explore IBM Planning Analytics data using\u00a0Exploration Views. Using\u00a0Exploration Views, you can not only quickly change how you see data \u2013 you can also manipulate the data to better understand relationships within the data. Here are just a few techniques you can use to manipulate an Exploration view in Planning Analytics Workspace (PAW): To…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[38,36,51],"class_list":["post-3469","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-how-tos","tag-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\nHow Do I Manipulate an Exploration View 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\/manipulating-an-exploration-view-in-planning-analytics-workspace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"You can explore IBM Planning Analytics data using\u00a0Exploration Views. Using\u00a0Exploration Views, you can not only quickly change how you see data \u2013 you can also manipulate the data to better understand relationships within the data. Here are just a few techniques you can use to manipulate an Exploration view in Planning Analytics Workspace (PAW): To…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T16:23:48+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)?\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-20T16:23:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/\"},\"wordCount\":461,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MAN1-min.jpg\",\"keywords\":[\"How To\u2019s\",\"Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/\",\"name\":\"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MAN1-min.jpg\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-20T16:23:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MAN1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/MAN1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/manipulating-an-exploration-view-in-planning-analytics-workspace\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Manipulate an Exploration View 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\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Manipulate an Exploration View 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\/manipulating-an-exploration-view-in-planning-analytics-workspace\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)? - QueBIT","og_description":"You can explore IBM Planning Analytics data using\u00a0Exploration Views. Using\u00a0Exploration Views, you can not only quickly change how you see data \u2013 you can also manipulate the data to better understand relationships within the data. Here are just a few techniques you can use to manipulate an Exploration view in Planning Analytics Workspace (PAW): To…","og_url":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:22+00:00","article_modified_time":"2026-01-20T16:23:48+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)?","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-20T16:23:48+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/"},"wordCount":461,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/MAN1-min.jpg","keywords":["How To\u2019s","Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/","url":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/","name":"How Do I Manipulate an Exploration View in Planning Analytics Workspace (PAW)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/MAN1-min.jpg","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-20T16:23:48+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/MAN1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/MAN1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/manipulating-an-exploration-view-in-planning-analytics-workspace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Manipulate an Exploration View 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\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3469","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3469"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3469\/revisions"}],"predecessor-version":[{"id":5095,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3469\/revisions\/5095"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}