{"id":4659,"date":"2025-07-02T15:44:41","date_gmt":"2025-07-02T15:44:41","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4659"},"modified":"2026-01-20T15:31:51","modified_gmt":"2026-01-20T15:31:51","slug":"using-formats-on-multiple-dimensions-in-ibm-planning-analytics","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/","title":{"rendered":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics?"},"content":{"rendered":"<h2>Using Formats on Multiple Dimensions in Planning Analytics<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4670\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png\" alt=\"\" width=\"1171\" height=\"694\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png 1171w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002-300x178.png 300w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002-1024x607.png 1024w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002-768x455.png 768w\" sizes=\"auto, (max-width: 1171px) 100vw, 1171px\" \/><\/p>\n<p>IBM Recommends applying formats to a single dimension, typically the last dimension in the cube which is commonly referred to as the \u201cmeasures\u201d dimension. However, there may be instances where a particular display of data requires a different set of formats. For instance, when you are trying to display a mix of amounts and percentages in the same view. This article will walk through an example of using formats on multiple dimensions and the governance of those formats within Planning Analytics.<\/p>\n<h2>Example Cube Setup<\/h2>\n<p>We will be using a simple 3 dimensional cube for this example. Cost Center, Account and Measure will be our dimensions. The measures dimension will have a single element in it called \u201cAmount\u201d. The Account dimension has Income, Expense and Ratio. The Ratio is a simple calculation of Expense \/ Income.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4660 aligncenter\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture1.png\" alt=\"\" width=\"250\" height=\"177\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4661\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture2.png\" alt=\"\" width=\"624\" height=\"148\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture2.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture2-300x71.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<h2>Applying a format to the Measure dimension<\/h2>\n<p>The default behavior for the cube is to show values in a rounded currency format. So we use the dimension editor to apply this format in the measure dimension:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4662\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture3.png\" alt=\"\" width=\"395\" height=\"198\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture3.png 395w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture3-300x150.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/p>\n<p>After applying the format, we notice that our Ratio stat account has also had the rounded currency format applied. We would like the Ratio to be displayed as a percentage.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4663\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture4.png\" alt=\"\" width=\"624\" height=\"150\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture4.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture4-300x72.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<h2>Applying formats to the Account dimension<\/h2>\n<p>We will be applying additional formats to our cube using multiple dimensions. It is important to note that when doing this the order of the dimensions in the view will impact the way the data is displayed. How this order is applied is outlined in the last section of this document.<\/p>\n<p>In the dimension editor for the Account dimension, we have selected Percentage on the Ratio element.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4664\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture5.png\" alt=\"\" width=\"467\" height=\"240\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture5.png 467w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture5-300x154.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/p>\n<p>When refreshing our view we can now see that the Ratio element is displayed in a percentage format:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4665\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture6.png\" alt=\"\" width=\"624\" height=\"150\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture6.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture6-300x72.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>Note: We did not need to update the formats for the other accounts since the default format is already being applied from the measures dimension.<\/p>\n<h2>What happens when we stack dimensions?<\/h2>\n<p>As mentioned earlier, the display format is impacted by the order of the dimensions in the view. When dimensions are stacked, PA will start with the columns and look from the bottom layer to the top and apply the first format found.<\/p>\n<h3>Stacking Columns<\/h3>\n<p>Using our example if I move the Measure dimension to the columns you can see that the format is being picked up from the Measure dimension only ( Currency Rounded ).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4666\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture7.png\" alt=\"\" width=\"624\" height=\"136\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture7.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture7-300x65.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>However, if I move the Account dimension below, or to the right, of the Measure dimension you can see the Account format being applied to Ratio and then the default being applied to the rest of the accounts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4667\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture8.png\" alt=\"\" width=\"624\" height=\"132\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture8.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture8-300x63.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<h3>Stacking Rows<\/h3>\n<p>We see the same behavior when stacking rows. If no format is found in the columns PA will look to the rows next. The lowest level ( furthest to the right ) wins.<\/p>\n<p>Here we have Measure on the right in the row stack:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4668\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture9.png\" alt=\"\" width=\"624\" height=\"179\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture9.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture9-300x86.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>When we swap we get the formatting from the Account dimension:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4669\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture10.png\" alt=\"\" width=\"624\" height=\"181\" srcset=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture10.png 624w, https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/Picture10-300x87.png 300w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>Note: The Measure could be moved to the Title section or benched since these areas are checked last for formats.<\/p>\n<h2>Multiple Dimension Format Governance Order<\/h2>\n<p>In summary, multiple dimension formats are applied in the following order:<\/p>\n<ol>\n<li>Columns \u2013 Lowest ( furthest right ) to highest<\/li>\n<li>Rows \u2013 Lowest ( furthest right ) to highest<\/li>\n<li>Title \u2013 Lowest ( furthest right ) to highest<\/li>\n<li>Bench \u2013 Bottom to Top<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Using Formats on Multiple Dimensions in Planning Analytics IBM Recommends applying formats to a single dimension, typically the last dimension in the cube which is commonly referred to as the \u201cmeasures\u201d dimension. However, there may be instances where a particular display of data requires a different set of formats. For instance, when you are trying&hellip;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[108,51],"class_list":["post-4659","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-ibm-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT<\/title>\n<meta name=\"description\" content=\"Using Conditional Formatting &amp; Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.\" \/>\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\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Using Conditional Formatting &amp; Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-02T15:44:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:31:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1171\" \/>\n\t<meta property=\"og:image:height\" content=\"694\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics?\",\"datePublished\":\"2025-07-02T15:44:41+00:00\",\"dateModified\":\"2026-01-20T15:31:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/\"},\"wordCount\":565,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/thumbnail_image002.png\",\"keywords\":[\"IBM Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/\",\"name\":\"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/thumbnail_image002.png\",\"datePublished\":\"2025-07-02T15:44:41+00:00\",\"dateModified\":\"2026-01-20T15:31:51+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"description\":\"Using Conditional Formatting & Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/thumbnail_image002.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/thumbnail_image002.png\",\"width\":1171,\"height\":694},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics?\"}]},{\"@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\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT","description":"Using Conditional Formatting & Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.","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\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT","og_description":"Using Conditional Formatting & Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.","og_url":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/","og_site_name":"QueBIT","article_published_time":"2025-07-02T15:44:41+00:00","article_modified_time":"2026-01-20T15:31:51+00:00","og_image":[{"width":1171,"height":694,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png","type":"image\/png"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics?","datePublished":"2025-07-02T15:44:41+00:00","dateModified":"2026-01-20T15:31:51+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/"},"wordCount":565,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png","keywords":["IBM Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/","url":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/","name":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png","datePublished":"2025-07-02T15:44:41+00:00","dateModified":"2026-01-20T15:31:51+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"description":"Using Conditional Formatting & Calculations in IBM Planning Analytics Workspace: learn how to highlight data, apply custom rules and add member calculations step\u2011by\u2011step.","breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/06\/thumbnail_image002.png","width":1171,"height":694},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/using-formats-on-multiple-dimensions-in-ibm-planning-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Apply Formats to Multiple Dimensions in IBM Planning Analytics?"}]},{"@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\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4659","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4659"}],"version-history":[{"count":4,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4659\/revisions"}],"predecessor-version":[{"id":5048,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4659\/revisions\/5048"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}