{"id":3363,"date":"2023-04-12T15:32:48","date_gmt":"2023-04-12T15:32:48","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/"},"modified":"2023-04-12T16:59:09","modified_gmt":"2023-04-12T16:59:09","slug":"how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/","title":{"rendered":"How Can I create an Exploration view in Planning Analytics for Excel (PAx)?"},"content":{"rendered":"

How Can I create an Exploration view in PAx (IBM Planning Analytics<\/a>)? An Exploration View shows data in rows and columns. An Exploration View also has a context<\/strong> area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Next you can select an existing view from the task pane and drag it onto the exploration object in your worksheet.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Planning Analytics for Excel (<\/a>PAx )\u201cbuilds\u201d your Exploration View for you (shown above) and then you can modify the view (just like you would in the TM1 or Planning Analytics cube viewer). You can also \u201cbuild from scratch\u201d (rather than selecting an existing view).\u00a0 To do this, you click the Exploration icon and then drag dimension\/subsets to the rows and columns (and optionally) context area above the worksheet:<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

In the exploration view, you can update data<\/em><\/strong> (in valid intersections) by entering or updating the data and clicking Commit<\/strong>.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Then select Yes:<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Save Time and automate your IBM Planning Analytics Reports with ReportWORQ<\/a>. Request your 30-day commitment free evaluation of ReportWORQ Today!<\/p>\n","protected":false},"excerpt":{"rendered":"

How Can I create an Exploration view in PAx (IBM Planning Analytics)? An Exploration View shows data in rows and columns. An Exploration View also has a context area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon:        …<\/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":[36,58,37],"class_list":["post-3363","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-planning-analytics","tag-planning-analytics-reporting","tag-reporting"],"acf":[],"yoast_head":"\nHow Can I create an Exploration view in Planning Analytics for Excel (PAx)? - 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\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Can I create an Exploration view in Planning Analytics for Excel (PAx)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"How Can I create an Exploration view in PAx (IBM Planning Analytics)? An Exploration View shows data in rows and columns. An Exploration View also has a context area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon:        …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-12T16:59:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Can I create an Exploration view in Planning Analytics for Excel (PAx)?\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2023-04-12T16:59:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\"},\"wordCount\":242,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg\",\"keywords\":[\"Planning Analytics\",\"Planning Analytics Reporting\",\"Reporting\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\",\"url\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\",\"name\":\"How Can I create an Exploration view in Planning Analytics for Excel (PAx)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2023-04-12T16:59:09+00:00\",\"author\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage\",\"url\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg\",\"contentUrl\":\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/quebit.com\/askquebit\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Can I create an Exploration view in Planning Analytics for Excel (PAx)?\"}]},{\"@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 Can I create an Exploration view in Planning Analytics for Excel (PAx)? - 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\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/","og_locale":"en_US","og_type":"article","og_title":"How Can I create an Exploration view in Planning Analytics for Excel (PAx)? - QueBIT","og_description":"How Can I create an Exploration view in PAx (IBM Planning Analytics)? An Exploration View shows data in rows and columns. An Exploration View also has a context area, which you can use to filter the data in the Exploration View. You create an exploration view by clicking the Exploration icon:        …","og_url":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:48+00:00","article_modified_time":"2023-04-12T16:59:09+00:00","og_image":[{"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg","type":"","width":"","height":""}],"author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Can I create an Exploration view in Planning Analytics for Excel (PAx)?","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2023-04-12T16:59:09+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/"},"wordCount":242,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg","keywords":["Planning Analytics","Planning Analytics Reporting","Reporting"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/","url":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/","name":"How Can I create an Exploration view in Planning Analytics for Excel (PAx)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2023-04-12T16:59:09+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/10\/Pax1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-create-an-exploration-view-in-planning-analytics-for-excel-pax\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Can I create an Exploration view in Planning Analytics for Excel (PAx)?"}]},{"@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\/3363","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=3363"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3363\/revisions"}],"predecessor-version":[{"id":3730,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3363\/revisions\/3730"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}