{"id":3477,"date":"2023-04-12T15:33:22","date_gmt":"2023-04-12T15:33:22","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/"},"modified":"2026-01-20T16:30:46","modified_gmt":"2026-01-20T16:30:46","slug":"using-the-modeling-workbench-in-planning-analytics","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/","title":{"rendered":"How Do I Use the Modeling Workbench in IBM Planning Analytics?"},"content":{"rendered":"

The modeling workbench<\/a> was introduced in IBM Planning Analytics and remains available as a beta feature (in 2.0.65). You can now open the modeling workbench from the Planning Analytics Workspace environment (in earlier versions entry was through a separate URL). \u00a0You can use the workbench to do almost anything you need to do within a model, from creating, editing and deleting objects and running processes and chores to more \u201cadministrative\u201d tasks like editing settings, importing data, reloading an unloading cube and even effect security.<\/p>\n

To use the workbench, you first need to create one by clicking the\u00a0Home<\/strong>\u00a0menu, then click\u00a0New<\/strong>\u00a0>\u00a0Workbench<\/strong>.<\/p>\n

\"\"<\/p>\n

A blank<\/em> workbench is shown below, with the Modeling tools<\/strong> (object editors) section in the upper left, Databases<\/strong> in the lower left and the general \u201cediting area<\/strong>\u201d, in the center:<\/p>\n

\"\"<\/p>\n

Working with Objects<\/strong><\/p>\n

To create a new object (like a cube, dimension, process, or chore) on the workbench you can click the appropriate link in the\u00a0Modeling tools<\/strong>\u00a0list, or you can create the new object directly from the Databases data tree<\/strong> by right clicking the applicable node, then clicking\u00a0Create asset_type<\/strong>. To open and edit an existing object, you right-click it in the data tree and then click\u00a0Edit asset_type<\/strong>.<\/p>\n

When you initially open or create an object, the modeling tool for the object is inserted as a new tab on the active tabset within the workbench<\/em>. Once there, you can\u00a0move the modeling tool within the workbench to create an editing environment that you are comfortable with \u2013 again more like a real IDE! In addition, the workbench even allows you to drag and drop<\/em> an existing object from the Databases data tree directly onto the workbench, choosing where you want to drop the object.<\/p>\n

\"\"<\/p>\n

The flexibility managing the workbench layout is a feature that takes a step towards providing more of an \u201cIDE\u201d or Integrated Development Environment experience that as a developer you may be used to working in.<\/p>\n

Floating Windows<\/strong><\/p>\n

Another \u201ccool\u201d feature of the workbench is the ability to utilize \u201cfloating windows\u201d. Basically, you can open any modeling tool in a separate window that is \u201cdetached\u201d from the workbench (the functionality of the modeling tool is the same whether you open it in a floating window or work within the modeling workbench).<\/p>\n

To open a modeling tool in a separate window you click the tab for the editor, then click\u00a0Open tab in floating window<\/strong>. To return the separate editor window to the workbench, click\u00a0Return to workbench<\/strong>.<\/p>\n

\"\"<\/p>\n

Where is it?<\/strong><\/p>\n

A keen time saver in the Modeling Workbench is the search feature <\/strong>which allows you to perform a global search for any data item (cubes, dimensions, views, sets, processes, chores, rules, and control objects) within a selected database. To perform a search, you click the Search button <\/strong>on the left side of the workbench:<\/p>\n

\"\"<\/p>\n

In the panel that opens, you need to select the database (if you are logged into multiple databases) in which you want to search in and then enter the name of the data item you are searching for. Here is an example. I\u2019ve typed the word \u201cbudget\u201d into the search field and the results are immediately shown below. We can see that there are numerous references within the Planning Sample database containing the phrase budget, including a number of saved cube views<\/em>:<\/p>\n

\"\"<\/p>\n

Another handy feature is that you can scroll-through the list (of search results) and then right click on an object to edit\/run\/delete or find out more about that object:<\/p>\n

\"\"<\/p>\n

Interested in Learning More?<\/strong><\/p>\n

Are you interested in finding out more about how to use the Planning Analytics Modeling Workbench? Then Contact QueBIT<\/a> today and we\u2019ll be happy to introduce you to this new tool!<\/p>\n","protected":false},"excerpt":{"rendered":"

The modeling workbench was introduced in IBM Planning Analytics and remains available as a beta feature (in 2.0.65). You can now open the modeling workbench from the Planning Analytics Workspace environment (in earlier versions entry was through a separate URL). \u00a0You can use the workbench to do almost anything you need to do within a…<\/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":[38,36,51],"class_list":["post-3477","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-how-tos","tag-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\nHow Do I Use the Modeling Workbench in IBM Planning Analytics? - 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\/using-the-modeling-workbench-in-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 Use the Modeling Workbench in IBM Planning Analytics? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"The modeling workbench was introduced in IBM Planning Analytics and remains available as a beta feature (in 2.0.65). You can now open the modeling workbench from the Planning Analytics Workspace environment (in earlier versions entry was through a separate URL). \u00a0You can use the workbench to do almost anything you need to do within a…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:33:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T16:30:46+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=\"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-the-modeling-workbench-in-planning-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Use the Modeling Workbench in IBM Planning Analytics?\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-20T16:30:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/\"},\"wordCount\":635,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/WB1-min.jpg\",\"keywords\":[\"How To\u2019s\",\"Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/\",\"name\":\"How Do I Use the Modeling Workbench in IBM Planning Analytics? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/WB1-min.jpg\",\"datePublished\":\"2023-04-12T15:33:22+00:00\",\"dateModified\":\"2026-01-20T16:30:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/WB1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/WB1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/using-the-modeling-workbench-in-planning-analytics\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Use the Modeling Workbench 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\\\/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 Use the Modeling Workbench in IBM Planning Analytics? - 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\/using-the-modeling-workbench-in-planning-analytics\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Use the Modeling Workbench in IBM Planning Analytics? - QueBIT","og_description":"The modeling workbench was introduced in IBM Planning Analytics and remains available as a beta feature (in 2.0.65). You can now open the modeling workbench from the Planning Analytics Workspace environment (in earlier versions entry was through a separate URL). \u00a0You can use the workbench to do almost anything you need to do within a…","og_url":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:33:22+00:00","article_modified_time":"2026-01-20T16:30:46+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Use the Modeling Workbench in IBM Planning Analytics?","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-20T16:30:46+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/"},"wordCount":635,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/WB1-min.jpg","keywords":["How To\u2019s","Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/","url":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/","name":"How Do I Use the Modeling Workbench in IBM Planning Analytics? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/WB1-min.jpg","datePublished":"2023-04-12T15:33:22+00:00","dateModified":"2026-01-20T16:30:46+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/WB1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2022\/06\/WB1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/using-the-modeling-workbench-in-planning-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Use the Modeling Workbench 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\/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\/3477","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=3477"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3477\/revisions"}],"predecessor-version":[{"id":5101,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3477\/revisions\/5101"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}