{"id":3373,"date":"2023-04-12T15:32:53","date_gmt":"2023-04-12T15:32:53","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/"},"modified":"2026-01-16T16:59:40","modified_gmt":"2026-01-16T16:59:40","slug":"drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/","title":{"rendered":"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)?"},"content":{"rendered":"

Planning Analytics Workspace (PAW) is a lot more than just a pretty face \u2013 it\u2019s the primary tool for developing and maintaining Planning Analytics models. It can be used for everything from building structures, to writing rules or TI processes, and even maintaining security.<\/p>\n

Development and prototyping in PAW is a lot faster and easier than with previous TM1 interfaces. For example, Planning Analytics dimensions can be created automatically simply dragging and dropping a .csv file into the workspace.<\/p>\n

To demonstrate, we will create a \u201cPerson\u201d dimension for a cube we are creating to store Oscar Award data. The .csv file that we will use to create the dimension has 5 columns:<\/p>\n

    \n
  1. Parent (root element)<\/li>\n
  2. Child (person)<\/li>\n
  3. Birth Country (attribute)<\/li>\n
  4. Ethnicity (attribute)<\/li>\n
  5. Religion (attribute)<\/li>\n<\/ol>\n

    To build the dimension, we\u2019ll simply drag and drop the .csv file onto the dimension editor in PAW. In the resulting dialog box, we are presented with the following settings:<\/p>\n

    Import Type<\/strong>: Leaf only or Parent-Child (we\u2019ll select Parent-Child in this example and then use the dropdowns to indicate which column is parent vs. child)<\/p>\n

    Header Rows<\/strong>: Number of header rows (we\u2019ll select 1 in this example)<\/p>\n

    Delimiter Type<\/strong>: Comma, Tab, Space, Semicolon, Colon, Vertical line, Caret, Other (we\u2019ll select Comma)<\/p>\n

    Finally, we\u2019ll identify each column using the dropdowns and click Import to create the dimension.<\/p>\n

    \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

    Planning Analytics Workspace (PAW) is a lot more than just a pretty face \u2013 it\u2019s the primary tool for developing and maintaining Planning Analytics models. It can be used for everything from building structures, to writing rules or TI processes, and even maintaining security. Development and prototyping in PAW is a lot faster and easier…<\/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":[43,36,49],"class_list":["post-3373","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-administration","tag-planning-analytics","tag-planning-analytics-administration"],"acf":[],"yoast_head":"\nHow Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - 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\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Planning Analytics Workspace (PAW) is a lot more than just a pretty face \u2013 it\u2019s the primary tool for developing and maintaining Planning Analytics models. It can be used for everything from building structures, to writing rules or TI processes, and even maintaining security. Development and prototyping in PAW is a lot faster and easier…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:32:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T16:59:40+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)?\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T16:59:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/\"},\"wordCount\":240,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/DimBuild.gif\",\"keywords\":[\"Administration\",\"Planning Analytics\",\"Planning Analytics Administration\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/\",\"name\":\"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/DimBuild.gif\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T16:59:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/DimBuild.gif\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/DimBuild.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)?\"}]},{\"@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 Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - 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\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - QueBIT","og_description":"Planning Analytics Workspace (PAW) is a lot more than just a pretty face \u2013 it\u2019s the primary tool for developing and maintaining Planning Analytics models. It can be used for everything from building structures, to writing rules or TI processes, and even maintaining security. Development and prototyping in PAW is a lot faster and easier…","og_url":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:53+00:00","article_modified_time":"2026-01-16T16:59:40+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)?","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T16:59:40+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/"},"wordCount":240,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/DimBuild.gif","keywords":["Administration","Planning Analytics","Planning Analytics Administration"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/","url":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/","name":"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/DimBuild.gif","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T16:59:40+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/DimBuild.gif","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/DimBuild.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-a-file-to-create-a-dimension-in-planning-analytics-workspace-paw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Drag and Drop a File to Create a Dimension in Planning Analytics Workspace (PAW)?"}]},{"@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\/3373","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=3373"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3373\/revisions"}],"predecessor-version":[{"id":5003,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3373\/revisions\/5003"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}