{"id":3374,"date":"2023-04-12T15:32:53","date_gmt":"2023-04-12T15:32:53","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/"},"modified":"2026-01-16T17:00:46","modified_gmt":"2026-01-16T17:00:46","slug":"drag-and-drop-cube-load-in-planning-analytics-workspace-paw","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/","title":{"rendered":"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)?"},"content":{"rendered":"<p>In another #AskQueBIT article <a href=\"https:\/\/quebit.com\/askquebit\/performance-management\/drag-and-drop-a-file-to-create-a-dimension-in-paw\/\">(Drag and Drop a File to Create a Dimension in PAW<\/a>), we demonstrated how easy it is to build a dimension by dragging and dropping a file into the dimension editor in PAW (Planning Analytics Workspace) . In this article, we\u2019ll take our prototyping one step further by loading data into a cube using the same method.<\/p>\n<p>For this example, we\u2019ll use a cube called Oscar that has the Person dimension that we created in our previous example, as well as a Year and Award dimensions. Our file has columns for each of the dimensions, and a fourth column for the values to load to the cube.<\/p>\n<p>To load the data, we\u2019ll simply drag and drop the csv file onto the Oscar cube in PAW. In the resulting dialog box, we\u2019ll identify the columns with the drop downs and click Import. A dialog box will pop up showing how many records were found and loaded.<\/p>\n<p>Once the data is loaded, we can validate it by adding a view to our sheet and creating a visualization.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-513\" src=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/LoadCubeFromCSV.gif\" alt=\"\" width=\"1280\" height=\"720\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In another #AskQueBIT article (Drag and Drop a File to Create a Dimension in PAW), we demonstrated how easy it is to build a dimension by dragging and dropping a file into the dimension editor in PAW (Planning Analytics Workspace) . In this article, we\u2019ll take our prototyping one step further by loading data into&hellip;<\/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-3374","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-administration","tag-planning-analytics","tag-planning-analytics-administration"],"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 Use Drag-and-Drop to Load Data into a Cube 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-cube-load-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 Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"In another #AskQueBIT article (Drag and Drop a File to Create a Dimension in PAW), we demonstrated how easy it is to build a dimension by dragging and dropping a file into the dimension editor in PAW (Planning Analytics Workspace) . In this article, we\u2019ll take our prototyping one step further by loading data into&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-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-16T17:00: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=\"1 minute\" \/>\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-cube-load-in-planning-analytics-workspace-paw\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)?\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T17:00:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/\"},\"wordCount\":198,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/LoadCubeFromCSV.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-cube-load-in-planning-analytics-workspace-paw\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/\",\"name\":\"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/LoadCubeFromCSV.gif\",\"datePublished\":\"2023-04-12T15:32:53+00:00\",\"dateModified\":\"2026-01-16T17:00:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/LoadCubeFromCSV.gif\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/LoadCubeFromCSV.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/drag-and-drop-cube-load-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 Use Drag-and-Drop to Load Data into a Cube 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 Use Drag-and-Drop to Load Data into a Cube 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-cube-load-in-planning-analytics-workspace-paw\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)? - QueBIT","og_description":"In another #AskQueBIT article (Drag and Drop a File to Create a Dimension in PAW), we demonstrated how easy it is to build a dimension by dragging and dropping a file into the dimension editor in PAW (Planning Analytics Workspace) . In this article, we\u2019ll take our prototyping one step further by loading data into&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:32:53+00:00","article_modified_time":"2026-01-16T17:00:46+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)?","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T17:00:46+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/"},"wordCount":198,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/LoadCubeFromCSV.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-cube-load-in-planning-analytics-workspace-paw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/","url":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/","name":"How Do I Use Drag-and-Drop to Load Data into a Cube in Planning Analytics Workspace (PAW)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/LoadCubeFromCSV.gif","datePublished":"2023-04-12T15:32:53+00:00","dateModified":"2026-01-16T17:00:46+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-in-planning-analytics-workspace-paw\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/LoadCubeFromCSV.gif","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2019\/01\/LoadCubeFromCSV.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/drag-and-drop-cube-load-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 Use Drag-and-Drop to Load Data into a Cube 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\/3374","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=3374"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3374\/revisions"}],"predecessor-version":[{"id":5004,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3374\/revisions\/5004"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}