{"id":9659,"date":"2026-03-24T12:41:47","date_gmt":"2026-03-24T12:41:47","guid":{"rendered":"https:\/\/forquestsolutions.com\/staging\/7345\/?page_id=9659"},"modified":"2026-03-31T14:15:40","modified_gmt":"2026-03-31T14:15:40","slug":"functions","status":"publish","type":"page","link":"https:\/\/forquestsolutions.com\/staging\/7345\/paxcel\/functions\/","title":{"rendered":"Functions"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"9659\" class=\"elementor elementor-9659\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-12abda56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12abda56\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-extended\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-55 elementor-top-column elementor-element elementor-element-2456e725\" data-id=\"2456e725\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c269538 elementor-widget__width-auto elementor-invisible elementor-widget elementor-widget-heading\" data-id=\"1c269538\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInDown&quot;,&quot;_animation_delay&quot;:100}\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">PAXCEL\u00ae DOCUMENTATION<\/span>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-226c63be elementor-invisible elementor-widget elementor-widget-heading\" data-id=\"226c63be\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;,&quot;_animation_delay&quot;:200}\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Custom Functions Reference<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2eb0a70a elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"2eb0a70a\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;,&quot;_animation_delay&quot;:300}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>PAXcel\u2122 extends Excel with 10 custom functions that connect directly to IBM Planning Analytics (TM1) via REST API. Read data, write plan values, query dimensions, and run MDX \u2014 all from native Excel formulas that work in Excel for Web, Windows, and Mac.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3239d328 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-invisible elementor-widget elementor-widget-icon-list\" data-id=\"3239d328\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;,&quot;_animation_delay&quot;:400}\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-check-circle\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">10 custom functions for read, write, bi-directional, and discovery<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-check-circle\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Works in Excel for Web, Windows, and Mac<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-check-circle\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">REST API connectivity with OAuth 2.0 security<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-check-circle\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Native Excel formulas with cell reference support<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-128e9bea elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"128e9bea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-595e127 elementor-widget elementor-widget-spacer\" data-id=\"595e127\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-1c6fc649 elementor-section-full_width elementor-section-content-stretch elementor-section-height-default elementor-section-height-default\" data-id=\"1c6fc649\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33.3333 elementor-inner-column elementor-element elementor-element-718b54b8\" data-id=\"718b54b8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-68fb3798 elementor-widget elementor-widget-heading\" data-id=\"68fb3798\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">10 Custom<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38d80114 elementor-widget elementor-widget-text-editor\" data-id=\"38d80114\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Excel Functions<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33.3333 elementor-inner-column elementor-element elementor-element-2d4773cd fq-stat-sep\" data-id=\"2d4773cd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5d5498e2 elementor-widget elementor-widget-heading\" data-id=\"5d5498e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">REST API<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-32aa520d elementor-widget elementor-widget-text-editor\" data-id=\"32aa520d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Connectivity<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33.3333 elementor-inner-column elementor-element elementor-element-509d14ac fq-stat-sep\" data-id=\"509d14ac\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-10f82d6 elementor-widget elementor-widget-heading\" data-id=\"10f82d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">OAuth 2.0<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7404f160 elementor-widget elementor-widget-text-editor\" data-id=\"7404f160\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Per-User Security<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-64470e5c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64470e5c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-narrow\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-736b34e8\" data-id=\"736b34e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7c85f0ee elementor-align-left elementor-widget__width-initial elementor-invisible elementor-widget elementor-widget-button\" data-id=\"7c85f0ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;,&quot;_animation_delay&quot;:500}\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/marketplace.microsoft.com\/en-us\/product\/forquestsolutions.paxcel?tab=DetailsAndSupport\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Start Free Trial \u2192<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6f09d6ec\" data-id=\"6f09d6ec\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-27d40057 elementor-align-left elementor-widget__width-initial elementor-invisible elementor-widget elementor-widget-button\" data-id=\"27d40057\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;,&quot;_animation_delay&quot;:600}\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/outlook.office365.com\/owa\/calendar\/PlanningAnalyticsConsultation@forquestsolutions.com\/bookings\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Schedule a Demo<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-45 elementor-top-column elementor-element elementor-element-4d8c02a\" data-id=\"4d8c02a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-24c5ea8c elementor-invisible elementor-widget elementor-widget-html\" data-id=\"24c5ea8c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeIn&quot;,&quot;_animation_delay&quot;:300}\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div style=\"position:relative;width:100%;height:480px;\"><div style=\"position:absolute;top:50%;left:50%;transform:translate(-50%,-50%);width:380px;height:380px;background:radial-gradient(circle,rgba(59,106,221,0.13) 0%,transparent 70%);pointer-events:none;\"><\/div><div style=\"position:absolute;top:0;left:0;width:100%;background:rgba(255,255,255,0.04);backdrop-filter:blur(12px);border:1px solid rgba(255,255,255,0.08);border-radius:14px;padding:24px 28px;\">\n<div style=\"font-size:10px;font-weight:700;letter-spacing:1.5px;text-transform:uppercase;color:#FF6B35;margin-bottom:16px;font-family:DM Sans;\">QUICK NAVIGATION<\/div>\n<div style=\"display:flex;flex-direction:column;gap:5px;\">\n<a href=\"#hello\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#3B6ADD;font-weight:600;\">PAXCEL.HELLO<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">TEST<\/span><\/a>\n<a href=\"#server\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(34,197,94,0.08);border:1px solid rgba(34,197,94,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#22C55E;font-weight:600;\">PAXCEL.SERVER<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">NEW<\/span><\/a>\n<a href=\"#cubes\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(255,255,255,0.02);border:1px solid rgba(255,255,255,0.06);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:rgba(255,255,255,0.6);font-weight:500;\">PAXCEL.CUBES<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">DISCOVERY<\/span><\/a>\n<a href=\"#dimensions\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(255,255,255,0.02);border:1px solid rgba(255,255,255,0.06);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:rgba(255,255,255,0.6);font-weight:500;\">PAXCEL.DIMENSIONS<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">DISCOVERY<\/span><\/a>\n<a href=\"#get\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#3B6ADD;font-weight:600;\">PAXCEL.GET<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">READ\/WRITE<\/span><\/a>\n<a href=\"#view\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(34,197,94,0.08);border:1px solid rgba(34,197,94,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#22C55E;font-weight:600;\">PAXCEL.VIEW<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">READ<\/span><\/a>\n<a href=\"#attr\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(255,255,255,0.02);border:1px solid rgba(255,255,255,0.06);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:rgba(255,255,255,0.6);font-weight:500;\">PAXCEL.ATTR<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">METADATA<\/span><\/a>\n<a href=\"#mdx\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(139,92,246,0.08);border:1px solid rgba(139,92,246,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#A78BFA;font-weight:600;\">PAXCEL.MDX<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">ADVANCED<\/span><\/a>\n<a href=\"#subset\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(255,255,255,0.02);border:1px solid rgba(255,255,255,0.06);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:rgba(255,255,255,0.6);font-weight:500;\">PAXCEL.SUBSET<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">DISCOVERY<\/span><\/a>\n<a href=\"#send\" style=\"display:flex;align-items:center;gap:10px;padding:7px 14px;background:rgba(255,107,53,0.08);border:1px solid rgba(255,107,53,0.15);border-radius:8px;text-decoration:none;\"><span style=\"font-family:monospace;font-size:12px;color:#FF6B35;font-weight:600;\">PAXCEL.SEND<\/span><span style=\"font-size:9px;color:rgba(255,255,255,0.3);margin-left:auto;\">WRITE<\/span><\/a>\n<\/div>\n<\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-389359c6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"389359c6\" data-element_type=\"section\" data-e-type=\"section\" id=\"hello\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7caa4040\" data-id=\"7caa4040\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3228f3fa elementor-widget elementor-widget-text-editor\" data-id=\"3228f3fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.HELLO<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Connection Test<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15da9394 elementor-widget elementor-widget-text-editor\" data-id=\"15da9394\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Test function \u2014 returns a static string to verify the add-in is loaded. Use this to confirm PAXcel is active in your Excel session before running other queries.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-636e4541 elementor-widget elementor-widget-text-editor\" data-id=\"636e4541\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.HELLO()<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-342e5909 elementor-widget elementor-widget-text-editor\" data-id=\"342e5909\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong> None<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31bc671a elementor-widget elementor-widget-text-editor\" data-id=\"31bc671a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Static string confirming the add-in is loaded<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-721ad8af elementor-widget elementor-widget-text-editor\" data-id=\"721ad8af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Example:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.HELLO()<\/code><\/p><p>\u2192 Returns: <code>\"PAXcel is loaded\"<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-792ac079 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"792ac079\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-523f4733 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"523f4733\" data-element_type=\"section\" data-e-type=\"section\" id=\"server\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-540ed8de\" data-id=\"540ed8de\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-31cb63fd elementor-widget elementor-widget-text-editor\" data-id=\"31cb63fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.SERVER<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Server Info<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64682bb5 elementor-widget elementor-widget-text-editor\" data-id=\"64682bb5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Returns the connection alias of the active TM1 server. Use this to verify which server you\u2019re connected to, or to dynamically reference the server name in other formulas.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4fc8db5c elementor-widget elementor-widget-text-editor\" data-id=\"4fc8db5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.SERVER()<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87a15b7 elementor-widget elementor-widget-text-editor\" data-id=\"87a15b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong> None<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1dec6095 elementor-widget elementor-widget-text-editor\" data-id=\"1dec6095\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Connection alias string of the active TM1 server<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3bd4700c elementor-widget elementor-widget-text-editor\" data-id=\"3bd4700c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Examples:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.SERVER()<\/code><\/p><p>\u2192 Returns: <code>\"Planning_Analytics_Prod\"<\/code><\/p><p style=\"margin-top:10px;\"><strong>Tip:<\/strong> Use in combination with other functions:<\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.CUBES(PAXCEL.SERVER())<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4dad6d30 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"4dad6d30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5fb3f188 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5fb3f188\" data-element_type=\"section\" data-e-type=\"section\" id=\"cubes\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-66013dc9\" data-id=\"66013dc9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-704e2728 elementor-widget elementor-widget-text-editor\" data-id=\"704e2728\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.CUBES<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Discovery<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-746b03ae elementor-widget elementor-widget-text-editor\" data-id=\"746b03ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Lists all cube names from the connected TM1 server. Returns a spilling array of cube names for discovery and validation.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25dc5920 elementor-widget elementor-widget-text-editor\" data-id=\"25dc5920\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.CUBES(<span style=\"color:#FF6B35;\">serverName<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1b28ec17 elementor-widget elementor-widget-text-editor\" data-id=\"1b28ec17\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (optional) \u2014 Database server name for identification<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6947f252 elementor-widget elementor-widget-text-editor\" data-id=\"6947f252\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Dynamic spilling array of cube names<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ecf98ca elementor-widget elementor-widget-text-editor\" data-id=\"3ecf98ca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Example:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.CUBES(\"Planning_Analytics_Prod\")<\/code><\/p><p>\u2192 Returns: <code>[\"Finance_GL\", \"Revenue_Cube\", \"Workforce\", \"CapEx\", ...]<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29691d03 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"29691d03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1a4befc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a4befc6\" data-element_type=\"section\" data-e-type=\"section\" id=\"dimensions\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7af97ce5\" data-id=\"7af97ce5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7b3c0c19 elementor-widget elementor-widget-text-editor\" data-id=\"7b3c0c19\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.DIMENSIONS<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Discovery<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ebe1178 elementor-widget elementor-widget-text-editor\" data-id=\"6ebe1178\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Lists all dimension names for a TM1 cube. Use this to understand cube structure before building GET or VIEW queries.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f826dbb elementor-widget elementor-widget-text-editor\" data-id=\"1f826dbb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.DIMENSIONS(<span style=\"color:#FF6B35;\">serverName<\/span>, <span style=\"color:#A78BFA;\">cubeName<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0cf827 elementor-widget elementor-widget-text-editor\" data-id=\"d0cf827\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (required) \u2014 Database server name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">cubeName<\/span> (required) \u2014 Name of the TM1 cube<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4abb2d8f elementor-widget elementor-widget-text-editor\" data-id=\"4abb2d8f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Dynamic spilling array of dimension names<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-133abce8 elementor-widget elementor-widget-text-editor\" data-id=\"133abce8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Example:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.DIMENSIONS(\"Planning_Analytics_Prod\", \"Revenue_Cube\")<\/code><\/p><p>\u2192 Returns: <code>[\"Period\", \"Version\", \"Region\", \"Account\", \"Measure\"]<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1b6b8d36 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"1b6b8d36\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-466a8ff4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"466a8ff4\" data-element_type=\"section\" data-e-type=\"section\" id=\"get\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-39ae617f\" data-id=\"39ae617f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-61d240cb elementor-widget elementor-widget-text-editor\" data-id=\"61d240cb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#22C55E;\">PAXCEL.GET<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Read \/ Write<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-16ed045e elementor-widget elementor-widget-text-editor\" data-id=\"16ed045e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Get a cell value from TM1. Requests are batched for performance (like DBRW). Supports three calling modes: cache mode with a VIEW reference, paired mode with Dim::Hier notation, and bare element mode. This bi-directional function enables full read\/write planning workflows when used with PAXCEL.SEND.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-76953acd elementor-widget elementor-widget-text-editor\" data-id=\"76953acd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.GET(<span style=\"color:#A78BFA;\">args...<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a2e97cc elementor-widget elementor-widget-text-editor\" data-id=\"4a2e97cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong> (repeating \u2014 three calling modes)<\/p><p style=\"padding-left:16px;margin-top:12px;\"><strong style=\"color:#22C55E;\">Mode 1 \u2014 Cache:<\/strong><\/p><p style=\"padding-left:32px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">ViewRef, Elem1, Elem2, &#8230;<\/span><\/p><p style=\"padding-left:32px;color:#64748B;\">Use a cell reference to a PAXCEL.VIEW result for instant cached lookups<\/p><p style=\"padding-left:16px;margin-top:12px;\"><strong style=\"color:#22C55E;\">Mode 2 \u2014 Paired:<\/strong><\/p><p style=\"padding-left:32px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">Server, Cube, &#8220;Dim::Hier&#8221;, Elem, &#8230;<\/span><\/p><p style=\"padding-left:32px;color:#64748B;\">Explicitly specify dimension and hierarchy for each element<\/p><p style=\"padding-left:16px;margin-top:12px;\"><strong style=\"color:#22C55E;\">Mode 3 \u2014 Bare:<\/strong><\/p><p style=\"padding-left:32px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">Server, Cube, Elem1, Elem2, &#8230;<\/span><\/p><p style=\"padding-left:32px;color:#64748B;\">Elements in cube dimension order (like classic DBRW)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-56e659db elementor-widget elementor-widget-text-editor\" data-id=\"56e659db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Single numeric or string cell value<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-277da938 elementor-widget elementor-widget-text-editor\" data-id=\"277da938\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Examples:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.GET(A1, \"North America\", \"Revenue\", \"Q4\")<\/code><\/p><p>\u2192 <strong>Cache mode<\/strong> \u2014 A1 references a PAXCEL.VIEW cell<\/p><p style=\"margin-top:10px;\"><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.GET(\"Prod\", \"Revenue_Cube\", \"Region::Region\", \"North America\", \"Period::Period\", \"Q4\")<\/code><\/p><p>\u2192 <strong>Paired mode<\/strong> \u2014 Dim::Hier notation<\/p><p style=\"margin-top:10px;\"><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.GET(\"Prod\", \"Revenue_Cube\", \"2026\", \"Forecast\", \"North America\", \"Revenue\")<\/code><\/p><p>\u2192 <strong>Bare mode<\/strong> \u2014 elements in cube dimension order<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5b204b29 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"5b204b29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-37c8cc71 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"37c8cc71\" data-element_type=\"section\" data-e-type=\"section\" id=\"view\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-415a9e30\" data-id=\"415a9e30\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-273c3e3d elementor-widget elementor-widget-text-editor\" data-id=\"273c3e3d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(34,197,94,0.08);border:1px solid rgba(34,197,94,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#22C55E;\">PAXCEL.VIEW<\/span><span style=\"display:inline-block;font-size:12px;color:#22C55E;background:rgba(34,197,94,0.08);border:1px solid rgba(34,197,94,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Read Data<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c31224 elementor-widget elementor-widget-text-editor\" data-id=\"c31224\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Load a TM1 view into cache for instant PAXCEL.GET lookups, or render a full cube view in Excel. Supports named views (saved in TM1) and dynamic views built with axis definitions. Use Dim:Subset for named subsets, just Dim for all members, or Dim.Hier:Subset for alternative hierarchies.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47acac90 elementor-widget elementor-widget-text-editor\" data-id=\"47acac90\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.VIEW(<span style=\"color:#FF6B35;\">serverName<\/span>, <span style=\"color:#FF6B35;\">cubeName<\/span>, <span style=\"color:#A78BFA;\">viewName<\/span>, <span style=\"color:#A78BFA;\">dynamicParams...<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-292457b1 elementor-widget elementor-widget-text-editor\" data-id=\"292457b1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (required) \u2014 Database server name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">cubeName<\/span> (required) \u2014 Name of the TM1 cube<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">viewName<\/span> (required) \u2014 Name of saved view, or empty string &#8220;&#8221; for dynamic mode<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">dynamicParams<\/span> (repeating, optional) \u2014 Axis definitions:<\/p><p style=\"padding-left:48px;color:#64748B;\"><code>rows=Dim1:Subset1,Dim2<\/code> \u2014 row axis<\/p><p style=\"padding-left:48px;color:#64748B;\"><code>cols=Dim3:Subset3<\/code> \u2014 column axis<\/p><p style=\"padding-left:48px;color:#64748B;\"><code>where=Dim4:Element<\/code> \u2014 fixed slicer<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37db73b6 elementor-widget elementor-widget-text-editor\" data-id=\"37db73b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Spilling grid with view data (named view) or cache reference string (dynamic view)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6845bd33 elementor-widget elementor-widget-text-editor\" data-id=\"6845bd33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Named view:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.VIEW(\"Prod\", \"Revenue_Cube\", \"Q4_Forecast\")<\/code><\/p><p>\u2192 Loads saved view &#8220;Q4_Forecast&#8221;<\/p><p style=\"margin-top:10px;\"><strong>Dynamic view:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.VIEW(\"Prod\", \"Revenue_Cube\", \"\", \"rows=Region,Account\", \"cols=Period:Q_Periods\", \"where=Version:Forecast\")<\/code><\/p><p>\u2192 Dynamic view with Region\/Account on rows, Period subset on columns, Forecast filter<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44de49ca elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"44de49ca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2f30c741 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2f30c741\" data-element_type=\"section\" data-e-type=\"section\" id=\"attr\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-326bed94\" data-id=\"326bed94\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-58d6343b elementor-widget elementor-widget-text-editor\" data-id=\"58d6343b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.ATTR<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Metadata<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46d4d518 elementor-widget elementor-widget-text-editor\" data-id=\"46d4d518\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Retrieves an attribute value from a TM1 dimension element. Supports alternative hierarchies for dimension elements with multiple organizational structures.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddc04b9 elementor-widget elementor-widget-text-editor\" data-id=\"ddc04b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.ATTR(<span style=\"color:#FF6B35;\">serverName<\/span>, <span style=\"color:#A78BFA;\">dimension<\/span>, <span style=\"color:#A78BFA;\">hierarchy<\/span>, <span style=\"color:#A78BFA;\">element<\/span>, <span style=\"color:#A78BFA;\">attribute<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d1b6722 elementor-widget elementor-widget-text-editor\" data-id=\"1d1b6722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (required) \u2014 Database server name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">dimension<\/span> (required) \u2014 Dimension name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">hierarchy<\/span> (required) \u2014 Hierarchy name (use dimension name if default)<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">element<\/span> (required) \u2014 Element name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">attribute<\/span> (required) \u2014 Attribute name<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c27411a elementor-widget elementor-widget-text-editor\" data-id=\"1c27411a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> String or numeric attribute value<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-105dd794 elementor-widget elementor-widget-text-editor\" data-id=\"105dd794\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Example:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.ATTR(\"Prod\", \"Account\", \"Account\", \"4100\", \"Description\")<\/code><\/p><p>\u2192 Returns: <code>\"Net Revenue - Product Sales\"<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f205978 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"2f205978\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d9d7f16 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d9d7f16\" data-element_type=\"section\" data-e-type=\"section\" id=\"mdx\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b1622bb\" data-id=\"5b1622bb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-174369a5 elementor-widget elementor-widget-text-editor\" data-id=\"174369a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(139,92,246,0.08);border:1px solid rgba(139,92,246,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#A78BFA;\">PAXCEL.MDX<\/span><span style=\"display:inline-block;font-size:12px;color:#A78BFA;background:rgba(139,92,246,0.08);border:1px solid rgba(139,92,246,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Advanced<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7aa95c28 elementor-widget elementor-widget-text-editor\" data-id=\"7aa95c28\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Executes an MDX query against TM1 and returns the result as a 2D grid. For power users who need full control over data retrieval \u2014 custom filters, calculated members, and complex slicing.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36b0e94b elementor-widget elementor-widget-text-editor\" data-id=\"36b0e94b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.MDX(<span style=\"color:#FF6B35;\">serverName<\/span>, <span style=\"color:#A78BFA;\">mdxQuery<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-660cda3 elementor-widget elementor-widget-text-editor\" data-id=\"660cda3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (required) \u2014 Database server name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">mdxQuery<\/span> (required) \u2014 MDX SELECT statement<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4c57a2cd elementor-widget elementor-widget-text-editor\" data-id=\"4c57a2cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Dynamic spilling 2D grid with query results<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c3902b0 elementor-widget elementor-widget-text-editor\" data-id=\"5c3902b0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Example:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;line-height:1.6;\">=PAXCEL.MDX(\"Prod\", \"SELECT {[Period].[Q1],[Period].[Q2]} ON COLUMNS, {[Region].Members} ON ROWS FROM [Revenue_Cube] WHERE ([Version].[Forecast],[Measure].[Revenue])\")<\/code><\/p><p>\u2192 Returns Revenue by Region and Period for Forecast version<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c4d31b9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"2c4d31b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6472e33d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6472e33d\" data-element_type=\"section\" data-e-type=\"section\" id=\"subset\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-833596f\" data-id=\"833596f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-500e025e elementor-widget elementor-widget-text-editor\" data-id=\"500e025e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#3B6ADD;\">PAXCEL.SUBSET<\/span><span style=\"display:inline-block;font-size:12px;color:#3B6ADD;background:rgba(59,106,221,0.08);border:1px solid rgba(59,106,221,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Discovery<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4fdeebcf elementor-widget elementor-widget-text-editor\" data-id=\"4fdeebcf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Returns elements of a TM1 subset, or all members if subset is blank. Supports alternative hierarchies and an optional attribute column for element descriptions or aliases.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a0b5dd9 elementor-widget elementor-widget-text-editor\" data-id=\"4a0b5dd9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.SUBSET(<span style=\"color:#FF6B35;\">serverName<\/span>, <span style=\"color:#A78BFA;\">dimension<\/span>, <span style=\"color:#A78BFA;\">hierarchy<\/span>, <span style=\"color:#A78BFA;\">subsetName<\/span>, <span style=\"color:#A78BFA;\">attribute<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a772cf elementor-widget elementor-widget-text-editor\" data-id=\"3a772cf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong><\/p><p style=\"padding-left:16px;\"><span style=\"color:#FF6B35;font-weight:600;font-family:monospace;\">serverName<\/span> (required) \u2014 Database server name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">dimension<\/span> (required) \u2014 Dimension name<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">hierarchy<\/span> (required) \u2014 Hierarchy name (use dimension name if unsure)<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">subsetName<\/span> (optional) \u2014 Subset name, or &#8220;&#8221; for all members<\/p><p style=\"padding-left:16px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">attribute<\/span> (optional) \u2014 Adds a second column with attribute values<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49238008 elementor-widget elementor-widget-text-editor\" data-id=\"49238008\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> Dynamic spilling array of element names (with optional attribute column)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5604de elementor-widget elementor-widget-text-editor\" data-id=\"c5604de\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Examples:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.SUBSET(\"Prod\", \"Region\", \"Region\", \"Active_Regions\")<\/code><\/p><p>\u2192 Returns: <code>[\"North America\", \"EMEA\", \"APAC\", \"LATAM\"]<\/code><\/p><p style=\"margin-top:10px;\"><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;\">=PAXCEL.SUBSET(\"Prod\", \"Region\", \"Region\", \"\", \"Caption\")<\/code><\/p><p>\u2192 All members with Caption attribute in second column<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-142afeaf elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"142afeaf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-78ea051 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"78ea051\" data-element_type=\"section\" data-e-type=\"section\" id=\"send\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5821b6c5\" data-id=\"5821b6c5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66b163ed elementor-widget elementor-widget-text-editor\" data-id=\"66b163ed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"display:flex;align-items:center;gap:12px;flex-wrap:wrap;\"><span style=\"display:inline-block;background:rgba(255,107,53,0.08);border:1px solid rgba(255,107,53,0.2);border-radius:8px;padding:6px 14px;font-family:monospace;font-size:16px;font-weight:700;color:#FF6B35;\">PAXCEL.SEND<\/span><span style=\"display:inline-block;font-size:12px;color:#FF6B35;background:rgba(255,107,53,0.08);border:1px solid rgba(255,107,53,0.2);padding:3px 10px;border-radius:4px;font-weight:600;\">Write Data<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79b16f22 elementor-widget elementor-widget-text-editor\" data-id=\"79b16f22\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Write a value to a TM1 cell. Writes are batched for performance (like DBSW). The last argument is always the value to write. Supports paired mode with Dim::Hier notation and bare element mode. Returns the written value on success.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60bb7f2d elementor-widget elementor-widget-text-editor\" data-id=\"60bb7f2d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div style=\"background:#0F172A;border-radius:10px;padding:20px 24px;\"><div style=\"font-size:10px;color:#64748B;text-transform:uppercase;letter-spacing:1px;margin-bottom:8px;font-weight:600;\">SYNTAX<\/div><code style=\"font-size:14px;color:#22C55E;\">=PAXCEL.SEND(<span style=\"color:#A78BFA;\">args...<\/span>, <span style=\"color:#FF6B35;\">value<\/span>)<\/code><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b0fc389 elementor-widget elementor-widget-text-editor\" data-id=\"2b0fc389\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Parameters:<\/strong> (repeating \u2014 two modes, value is always last)<\/p><p style=\"padding-left:16px;margin-top:12px;\"><strong style=\"color:#FF6B35;\">Mode 1 \u2014 Paired:<\/strong><\/p><p style=\"padding-left:32px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">Server, Cube, &#8220;Dim::Hier&#8221;, Elem, &#8230;, Value<\/span><\/p><p style=\"padding-left:32px;color:#64748B;\">Explicit dimension and hierarchy for each element<\/p><p style=\"padding-left:16px;margin-top:12px;\"><strong style=\"color:#FF6B35;\">Mode 2 \u2014 Bare:<\/strong><\/p><p style=\"padding-left:32px;\"><span style=\"color:#A78BFA;font-weight:600;font-family:monospace;\">Server, Cube, Elem1, Elem2, &#8230;, Value<\/span><\/p><p style=\"padding-left:32px;color:#64748B;\">Elements in cube dimension order, value last<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-731b152a elementor-widget elementor-widget-text-editor\" data-id=\"731b152a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Returns:<\/strong> The written value on success, or error message<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48d3aa26 elementor-widget elementor-widget-text-editor\" data-id=\"48d3aa26\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u26a0 IMPORTANT:<\/strong> PAXCEL.SEND writes data to your Planning Analytics model. The user must have write access to the target cell. All writes are logged in the TM1 audit trail. TM1 security rules apply per-user based on OAuth 2.0 authentication.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6483ef32 elementor-widget elementor-widget-text-editor\" data-id=\"6483ef32\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>Bare mode:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.SEND(\"Prod\", \"Revenue_Cube\", \"2026\", \"Forecast\", \"North America\", \"Revenue\", \"Q4\", 4890000)<\/code><\/p><p>\u2192 Writes 4,890,000 and returns <strong>4890000<\/strong><\/p><p style=\"margin-top:10px;\"><strong>Paired mode:<\/strong><\/p><p><code style=\"background:#0F172A;color:#22C55E;padding:4px 10px;border-radius:4px;font-size:13px;display:inline-block;margin-bottom:6px;\">=PAXCEL.SEND(\"Prod\", \"Revenue_Cube\", \"Region::Region\", \"North America\", \"Period::Period\", \"Q4\", 4890000)<\/code><\/p><p>\u2192 Writes with explicit Dim::Hier mapping<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2972a5b9 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"2972a5b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-33e58ec1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"33e58ec1\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-17ce66d7\" data-id=\"17ce66d7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d964b8d elementor-widget elementor-widget-heading\" data-id=\"6d964b8d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">READY TO GET STARTED<\/span>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b0e3bdf elementor-widget elementor-widget-heading\" data-id=\"7b0e3bdf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">See PAXcel\u2122 Functions in Action<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c144519 elementor-widget elementor-widget-text-editor\" data-id=\"1c144519\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>See these functions working live with your own IBM Planning Analytics environment. Free trial available on Microsoft AppSource.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6f7249d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f7249d0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-narrow\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-1438202\" data-id=\"1438202\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e9af4b0 elementor-align-right elementor-widget__width-initial elementor-widget elementor-widget-button\" data-id=\"e9af4b0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/marketplace.microsoft.com\/en-us\/product\/forquestsolutions.paxcel?tab=DetailsAndSupport\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Start Free Trial \u2192<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6100ce03\" data-id=\"6100ce03\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b64ad0c elementor-align-left elementor-widget__width-initial elementor-widget elementor-widget-button\" data-id=\"4b64ad0c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-lg\" href=\"https:\/\/outlook.office365.com\/owa\/calendar\/PlanningAnalyticsConsultation@forquestsolutions.com\/bookings\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Schedule a Demo<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>PAXCEL\u00ae DOCUMENTATION Custom Functions Reference PAXcel\u2122 extends Excel with 10 custom functions that connect directly to IBM Planning Analytics (TM1) via REST API. Read data, write plan values, query dimensions, and run MDX \u2014 all from native Excel formulas that work in Excel for Web, Windows, and Mac. 10 custom functions for read, write, bi-directional, [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"parent":8172,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"nf_dc_page":"","site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-9659","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/pages\/9659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/comments?post=9659"}],"version-history":[{"count":18,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/pages\/9659\/revisions"}],"predecessor-version":[{"id":9731,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/pages\/9659\/revisions\/9731"}],"up":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/pages\/8172"}],"wp:attachment":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media?parent=9659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}