Dynamic Subsets\u2013 subsets that do change and are updated over time or as the dimension is modified.<\/p>\n
- \n
- Are created by assigning an MDX expression to the subset.<\/li>\n
- The expression will run each time the subset is called by the TM1 server.<\/li>\n
- You can record actions performed in the Subset Editor in Architect to simplify the creation of an expression in a subset.<\/li>\n
- Use the Record Expression and Stop Recording from the Tools menu to capture actions for your expression.<\/li>\n
- You can type MDX statements in the editor.<\/li>\n<\/ul>\n
What is MDX<\/h3>\n
As MDX (Multi-Dimensional eXpressions) is the query language used to define dynamic subsets.\u00a0 MDX is an industry-standard query language for multi-dimensional databases like Planning Analytics, although Planning Analytics only supports a certain category of the entire language and adds a few unique features of its own as well.<\/p>\n
When you define a subset using MDX instead of a standard static subset, Planning Analytics stores the MDX definition rather than the resulting set.<\/p>\n
This means the definition \u2013 or query \u2013 is re-run every time a user accesses the subset \u2013 requiring no further action by the user or administrator.<\/p>\n
If the database, specifically the dimension, has changed from the last time the subset was accessed, then you may get different results.<\/p>\n
Syntax and Layout<\/h3>\n
When writing the MDX statement in Architect, you can break up a query into multiple lines to make it more readable and to correct any syntax errors, such as forgetting to close a parenthesis.<\/p>\n
You can prefix the dimension name of specific members.\u00a0 It is optional, if the element name Bikes is unique within the entire server, then you do not need to prefix it with the dimension name, Products.<\/p>\n
For example:<\/p>\n
- \n
- {{[Products].[Bikes].CHILDREN}}<\/li>\n<\/ul>\n
This query will return all children of the Bikes element, which is found in the Products dimension.<\/p>\n
If the element is not unique and you do not use the dimension name as a prefix, you will receive an error, such as:<\/p>\n
\u201cLevel or member name \u201c[Retail]\u201d ambiguous: found in dimensions\u2026\u201d<\/p>\n
The use of square brackets can sometimes seem a bit arbitrary when reading examples of MDX queries.<\/p>\n
The reason is due to an Online Analytical Processing OLAP object name.\u00a0 For example, the cube name, dimension name, member name, must be enclosed in square brackets, only if it contains a space, starts with a number or is an MDX reserved word (e.g. Select).<\/p>\n
It can be simpler to decide to always use brackets.\u00a0 Similar, queries can be compared side by side more easily.<\/p>\n
The exact definition of a member in Planning Analytics is almost always expressed as [Dimension Name].[Member Name] and no more.<\/p>\n
MDX and Planning Analytics are not case sensitive.<\/p>\n
Demonstration:\u00a0 Creating a Dynamic subset<\/h3>\n
Objectives<\/em><\/h4>\n
In this demonstration, we will:<\/p>\n
- \n
- create and save dynamic and static subsets<\/li>\n
- utilize the \u201cRecord Expression\u201d command to create a subset for all years for 201?<\/li>\n
- create a static subset of 201? Years.<\/li>\n
- run a TI process to add a new year for 2018<\/li>\n
- evaluate differences between a dynamic and static subset<\/li>\n<\/ul>\n
Results after creating a dynamic subset<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/dynamic-subset-min.jpg\")
<\/p>\nResults after running a TI Process to add a new year<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/ti-process-min.jpg\")
<\/p>\nDemonstration:\u00a0 Step-by-Step<\/strong><\/p>\n
- \n
- Open Planning Analytics Architect.<\/li>\n
- Expand and sign into a TM1 Server<\/strong>, such as AdventureWorks2017<\/strong>.<\/li>\n
- Expand the server<\/strong>, Cubes<\/strong>, and double-click the Financials cube<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/financial-cubes-min.jpg\")
<\/p>\n- \n
- Create the following view and save it as a public view called Profit and Loss<\/strong>:<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/profit-loss.jpg\")
<\/p>\n- \n
- Click on the Period <\/strong>dimension to open the subset editor.<\/li>\n
- From the View<\/strong> menu, select Expression Window<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/expression-window-min.jpg\")
<\/p>\n- \n
- From the Tools <\/strong>menu, select Record Expression<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/record-expression-min.jpg\")
<\/p>\n- \n
- From the toolbar, click the All<\/strong><\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/all-button-min.jpg\")
<\/p>\nImportant Note<\/strong><\/p>\n
The All button is the most important button to select when recording an expression because it searches through the TM1 server for the dimension you are viewing and retrieves all elements you can see based on your security privileges.<\/p>\n
You can also have the ALL function appear, when you select a parent element and drill down or up the hierarchy, using other MDX functions.<\/p>\n
- \n
- If necessary, select All Time<\/strong> and expand All Time<\/strong>.<\/li>\n
- From the toolbar, click the Filter by Wildcard<\/strong><\/li>\n
- In the Expression box, type \u201c201?<\/strong>\u201d<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/type-201-min.jpg\")
<\/p>\n- \n
- Click OK<\/strong>.<\/li>\n<\/ol>\n
The results appear below:<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/results-min.jpg\")
<\/p>\nImportant Note<\/strong><\/p>\n
The ALL function is surrounded by the DRILLDOWNMEMBER function.\u00a0 The MDX expression will first analyze if there are any new elements within the Period dimension.\u00a0 Then, it will filter by wildcard for any periods that start with the characters \u2018201\u2019.<\/p>\n
- \n
- From the Tools<\/strong> menu, select \u201cStop Recording<\/strong>\u201d.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/stop-recording-min.jpg\")
<\/p>\n- \n
- Click Yes<\/strong> to attach the expression to the subset.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/attach-expression-min.jpg\")
<\/p>\n- \n
- From the Subset <\/strong>menu, choose Save As.<\/strong><\/li>\n
- In the Select or Enter Subset Name field, type \u201cAll Years<\/strong>\u201d.<\/li>\n
- Uncheck Private<\/strong> and make certain Save Expression<\/strong> is checked.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/save-expression-min.jpg\")
<\/p>\n- \n
- Click OK<\/strong>.<\/li>\n<\/ol>\n
Run a TI Process to add a year<\/strong><\/p>\n
- \n
- Navigate to the Server Explorer \u2013 IBM Cognos Planning Analytics Architect<\/strong><\/li>\n
- Expand Processes and select the Period \u2013 Add 1 Year to Time Dimension<\/strong><\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/time-dimension-min.jpg\")
<\/p>\n- \n
- Right-click and choose Run<\/strong>.<\/li>\n
- Expand the window and the Prompt Question<\/strong> column:<\/li>\n
- In the Default Value<\/strong> column, make certain you modify the Default Value as what is pictured below:<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/default-value-min.jpg\")
<\/p>\n- \n
- Click OK<\/strong> to run the process.<\/li>\n
- Click OK<\/strong> on the Process Completed Successfully message window.<\/li>\n
- Navigate back to the Profit and Loss<\/strong><\/li>\n
- From the toolbar, deselect Zero Suppression<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/zero-supression-min.jpg\")
<\/p>\n- \n
- Open the private Profit and Loss Static<\/strong> view and deselect Zero Suppression<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/profit-loss-stat-min.jpg\")
<\/p>\n- \n
- Double click the Period <\/strong>dimension to open the Subset Editor.<\/li>\n
- Pull down the Subset drop-down, select the All Years <\/strong>subset from the list.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/all-years-min.jpg\")
<\/p>\nThe results appear below:<\/p>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/all-years-results-min.jpg\")
<\/p>\n- \n
- Pull down the Subset drop-down, select All Years Static<\/strong> subset from the list.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/all-years-static-min.jpg\")
<\/p>\nNotice how one subset has the new year, while the other All Years Static subset does not contain 2018.\u00a0 It is recommended that the administrator\/developer of the model create public dynamic subsets for dimensions that change over time.<\/p>\n
This concludes this demonstration.<\/strong><\/p>\n
Demonstration:\u00a0 Summary<\/p>\n
In this demonstration, we:<\/p>\n
- \n
- created dynamic and static subsets<\/li>\n
- after adding a new year by running an existing process, we compared the differences between the dynamic versus the static subset<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule.\u00a0 Customized subsets are utilized to speed the selection of…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[35,36,52],"class_list":["post-3327","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-development","tag-planning-analytics","tag-planning-analytics-development"],"acf":[],"yoast_head":"\n
How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule.\u00a0 Customized subsets are utilized to speed the selection of…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:18:43+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?\",\"datePublished\":\"2023-04-12T15:32:43+00:00\",\"dateModified\":\"2026-01-20T15:18:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/\"},\"wordCount\":1113,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/dynamic-subset-min.jpg\",\"keywords\":[\"Development\",\"Planning Analytics\",\"Planning Analytics Development\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/\",\"name\":\"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/dynamic-subset-min.jpg\",\"datePublished\":\"2023-04-12T15:32:43+00:00\",\"dateModified\":\"2026-01-20T15:18:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/dynamic-subset-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/dynamic-subset-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-mdx-expressions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT","og_description":"How to create MDX expressions According to the dimension and your business need, dimensions may be large. You may want to limit the data shown in the report or input schedule. You can create customized categories or subsets of dimensions for your report or input schedule.\u00a0 Customized subsets are utilized to speed the selection of…","og_url":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:43+00:00","article_modified_time":"2026-01-20T15:18:43+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?","datePublished":"2023-04-12T15:32:43+00:00","dateModified":"2026-01-20T15:18:43+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/"},"wordCount":1113,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/dynamic-subset-min.jpg","keywords":["Development","Planning Analytics","Planning Analytics Development"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/","url":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/","name":"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/dynamic-subset-min.jpg","datePublished":"2023-04-12T15:32:43+00:00","dateModified":"2026-01-20T15:18:43+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/dynamic-subset-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2018\/03\/dynamic-subset-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/create-mdx-expressions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Create MDX Expressions in IBM Planning Analytics to Customize Queries and Reports?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3327"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3327\/revisions"}],"predecessor-version":[{"id":5040,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3327\/revisions\/5040"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Pull down the Subset drop-down, select the All Years <\/strong>subset from the list.<\/li>\n<\/ol>\n
- Double click the Period <\/strong>dimension to open the Subset Editor.<\/li>\n
- Click OK<\/strong> on the Process Completed Successfully message window.<\/li>\n
- Expand the window and the Prompt Question<\/strong> column:<\/li>\n
- Expand Processes and select the Period \u2013 Add 1 Year to Time Dimension<\/strong><\/li>\n<\/ol>\n
- Navigate to the Server Explorer \u2013 IBM Cognos Planning Analytics Architect<\/strong><\/li>\n
- In the Select or Enter Subset Name field, type \u201cAll Years<\/strong>\u201d.<\/li>\n
- From the Subset <\/strong>menu, choose Save As.<\/strong><\/li>\n
- Click Yes<\/strong> to attach the expression to the subset.<\/li>\n<\/ol>\n
- From the Tools<\/strong> menu, select \u201cStop Recording<\/strong>\u201d.<\/li>\n<\/ol>\n
- From the toolbar, click the Filter by Wildcard<\/strong><\/li>\n
- If necessary, select All Time<\/strong> and expand All Time<\/strong>.<\/li>\n
- From the toolbar, click the All<\/strong><\/li>\n<\/ol>\n
- From the View<\/strong> menu, select Expression Window<\/strong>.<\/li>\n<\/ol>\n
- Click on the Period <\/strong>dimension to open the subset editor.<\/li>\n
- Expand the server<\/strong>, Cubes<\/strong>, and double-click the Financials cube<\/strong>.<\/li>\n<\/ol>\n
- {{[Products].[Bikes].CHILDREN}}<\/li>\n<\/ul>\n