{"id":3359,"date":"2023-04-12T15:32:48","date_gmt":"2023-04-12T15:32:48","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/"},"modified":"2023-04-12T16:58:59","modified_gmt":"2023-04-12T16:58:59","slug":"how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/","title":{"rendered":"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?"},"content":{"rendered":"<p>Clicking the Action Button icon adds a\u00a0<a href=\"https:\/\/quebit.com\/ibmPA\">Planning Analytics for Excel\u00a0<\/a>Action button to the worksheet (assuming trust is enabled).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-380\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-min.jpg\" alt=\"\" width=\"128\" height=\"175\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Once a PAx action button is added to your worksheet you can set its properties <em>to recalculate the worksheet<\/em> or workbook, <em>link to another location<\/em> or <em>run a TurboIntegrator process<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-381\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/button2-min.jpg\" alt=\"\" width=\"448\" height=\"466\" \/><\/p>\n<p><strong>How do I Update Existing Action Buttons?<\/strong><\/p>\n<p>If your Perspectives reports have any <em>action buttons<\/em>, you will need to upgrade those to be PAx compliant buttons (basically turn the button into a native Excel object). IBM does provide a utility to easily upgrade any legacy action buttons (see the screenshot below that shows where you can access the utility in the PAx options). Once connected to the desired TM1 server, you&#8217;ll be able to specify a backup and logs location for the conversion process, and then browse to the TM1 Applications folder location where your reports live to apply the conversion. The tool will automatically search across all reports in that location and upgrade any action buttons it finds.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-382 alignleft\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/button3-min.jpg\" alt=\"\" width=\"715\" height=\"440\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Save Time and automate your IBM Planning Analytics Reports with <a href=\"https:\/\/quebit.com\/what-we-offer\/products-our-products\/frameworq\/reportworq-4-0\/\">ReportWORQ<\/a>. Request your 30-day commitment free evaluation of ReportWORQ Today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Clicking the Action Button icon adds a\u00a0Planning Analytics for Excel\u00a0Action button to the worksheet (assuming trust is enabled). &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Once a PAx action button is added to your worksheet you can set its properties to recalculate the worksheet or workbook, link to another location or run a TurboIntegrator process. How do&hellip;<\/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-3359","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-planning-analytics","tag-planning-analytics-reporting","tag-reporting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - 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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Clicking the Action Button icon adds a\u00a0Planning Analytics for Excel\u00a0Action button to the worksheet (assuming trust is enabled). &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Once a PAx action button is added to your worksheet you can set its properties to recalculate the worksheet or workbook, link to another location or run a TurboIntegrator process. How do&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/\" \/>\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:58:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2023-04-12T16:58:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/\"},\"wordCount\":223,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/Button1-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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/\",\"name\":\"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/Button1-min.jpg\",\"datePublished\":\"2023-04-12T15:32:48+00:00\",\"dateModified\":\"2023-04-12T16:58:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/Button1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/Button1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?\"}]},{\"@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 add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - 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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/","og_locale":"en_US","og_type":"article","og_title":"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - QueBIT","og_description":"Clicking the Action Button icon adds a\u00a0Planning Analytics for Excel\u00a0Action button to the worksheet (assuming trust is enabled). &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Once a PAx action button is added to your worksheet you can set its properties to recalculate the worksheet or workbook, link to another location or run a TurboIntegrator process. How do&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:48+00:00","article_modified_time":"2023-04-12T16:58:59+00:00","og_image":[{"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2023-04-12T16:58:59+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/"},"wordCount":223,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-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-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/","url":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/","name":"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-min.jpg","datePublished":"2023-04-12T15:32:48+00:00","dateModified":"2023-04-12T16:58:59+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/09\/Button1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/how-can-i-add-a-pax-planning-analytics-for-excel-action-button-to-my-pax-worksheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How can I add a PAx (Planning Analytics for Excel) Action Button to my PAx worksheet?"}]},{"@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\/3359","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=3359"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3359\/revisions"}],"predecessor-version":[{"id":3727,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3359\/revisions\/3727"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}