{"id":11724,"date":"2021-08-17T00:00:12","date_gmt":"2021-08-17T07:00:12","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11724"},"modified":"2025-06-13T17:32:19","modified_gmt":"2025-06-14T00:32:19","slug":"level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/","title":{"rendered":"Mejora tu an\u00e1lisis de datos con la nueva funcionalidad CUBE de Couchbase Analytics"},"content":{"rendered":"<p><strong>Las funciones de an\u00e1lisis de datos de Couchbase son ahora m\u00e1s potentes<\/strong> con la versi\u00f3n 7.0.<\/p>\n<p>Estoy emocionado de anunciar dos nuevas y poderosas capacidades ahora disponibles como parte de Couchbase Analytics: 1) el <code>CUBO<\/code> y 2) <code>ROLLUP<\/code> agregaci\u00f3n, ambos para ayudarle a agregar datos a trav\u00e9s de m\u00faltiples atributos del documento.<\/p>\n<p>La adici\u00f3n del <code>CUBO<\/code> funcionalidad de extensi\u00f3n a <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/introduction.html?ref=blog\" target=\"_blank\" rel=\"noopener\">el servicio Couchbase Analytics<\/a> forma parte de <a href=\"https:\/\/www.couchbase.com\/blog\/es\/couchbase-server-7-0-release\/?ref=blog\" target=\"_blank\" rel=\"noopener\">la versi\u00f3n 7.0 de Couchbase Server<\/a>. (Cubrimos <a href=\"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/?ref=blog\" target=\"_blank\" rel=\"noopener\">el <code>ROLLUP<\/code> funcionalidad<\/a> en un art\u00edculo de la semana pasada).<\/p>\n<h2>Un ejemplo de la nueva funcionalidad CUBE<\/h2>\n<p>Como en SQL, la capacidad de agregaci\u00f3n CUBE es una extensi\u00f3n de <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/primer-beer.html?ref=blog#Query_9\" target=\"_blank\" rel=\"noopener\">la cl\u00e1usula GROUP BY<\/a>.<\/p>\n<p>La subcl\u00e1usula de extensi\u00f3n CUBE permite generar subtotales para todas las combinaciones de columnas de agrupaci\u00f3n especificadas en la cl\u00e1usula GROUP BY. En concreto, el resultado incluye filas adicionales que representan subtotales en sus datos -com\u00fanmente denominadas filas superagregadas- junto con la fila habitual del total general.<\/p>\n<p>Por ejemplo, supongamos que tiene una colecci\u00f3n de an\u00e1lisis de muestra llamada Pedidos que realiza un seguimiento de la informaci\u00f3n de comercio electr\u00f3nico. Los elementos de datos clave que m\u00e1s le interesan son regi\u00f3n\/estado, fecha de pedido, cantidad y precio. (Y digamos que calcula Ventas como Ventas = cantidad * precio).<\/p>\n<p>A continuaci\u00f3n se muestra una muestra de los datos de comercio electr\u00f3nico para nuestro ejemplo:<\/p>\n<pre> {\r\n    \"orderDate\": \"2020-11-30\",\r\n    \"region\": \"California\",\r\n    \"qty\": 5,\r\n    \"price\": 596.37\r\n  },\r\n  {\r\n    \"orderDate\": \"2020-05-08\",\r\n    \"region\": \"California\",\r\n    \"qty\": 3,\r\n    \"price\": 814.69\r\n  },\r\n  {\r\n    \"orderDate\": \"2020-03-17\",\r\n    \"region\": \"Connecticut\",\r\n    \"qty\": 2,\r\n    \"price\": 270.04\r\n  },\r\n  {\r\n    \"orderDate\": \"2020-03-11\",\r\n    \"region\": \"Colorado\",\r\n    \"qty\": 4,\r\n    \"price\": 795.73\r\n  }\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>Supongamos que a los usuarios de su empresa les gustar\u00eda saber lo siguiente a partir de los datos de su comercio electr\u00f3nico:<\/p>\n<p>1) Ventas totales de todos los a\u00f1os por regi\u00f3n<br \/>\n2) Ventas totales de todas las regiones por a\u00f1o<br \/>\n3) Ventas totales de cada regi\u00f3n por a\u00f1o<br \/>\n4) Ventas totales de todas las regiones y todos los a\u00f1os<\/p>\n<p>La extensi\u00f3n CUBE es un buen caso de uso para responder a estas preguntas de an\u00e1lisis de datos basados en la agregaci\u00f3n. Su ingeniero de datos o analista de datos simplemente utiliza <a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/n1ql\/?ref=blog\" target=\"_blank\" rel=\"noopener\">la consulta N1QL<\/a> que se muestra a continuaci\u00f3n dentro del servicio Couchbase Analytics.<\/p>\n<pre class=\"\">-- Generates four grouping sets:\r\n-- 1. All Region &amp; All Years (Grand Total)\r\n-- 2. All Regions, Year\r\n-- 3. All Years, Region\r\n-- 4. Region, Year\r\nSELECT   IFNULL(region,\"All Regions\") Region,\r\n   IFNULL(year, \"All Years\") Year,\r\n                  ROUND(SUM(o.qty * o.price),0) Sales\r\nFROM      orders o\r\nLET           year = DATE_PART_STR(o.orderDate, \"year\"), \r\n                 region = o.region\r\nGROUP BY CUBE(region, year)\r\nORDER BY region, year\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>In the above N1QL query, we&#8217;ve used `year` and `region` as variables for convenience. As a result, `CUBE(region, year)` generates the following query results for our sample data:<\/p>\n<pre> {  \"Region\": \"All Regions\",\r\n    \"Year\": \"All Years\",\r\n    \"Sales\": 3372854458},\r\n  { \"Region\": \"All Regions\",\r\n    \"Year\": 2020,\r\n    \"Sales\": 3371122342},\r\n  {\r\n    \"Region\": \"All Regions\",\r\n    \"Year\": 2021,\r\n    \"Sales\": 1732116},\r\n  {\r\n    \"Year\": \"All Years\",\r\n    \"Region\": \"Alabama\",\r\n    \"Sales\": 66383297},  \r\n{ \"Year\": \"All Years\",\r\n    \"Region\": \"California\",\r\n    \"Sales\": 66108045},\r\n  { \"Region\": \"California\",\r\n    \"Year\": 2020,\r\n    \"Sales\": 66053233},\r\n...\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>Tenga en cuenta que el resultado es exactamente lo que sus usuarios buscaban en un principio:<\/p>\n<ol>\n<li>At the top of the results, a grand total shows the total sales over all years and regions. In the query output, the `NULL` values in the country and region attributes are transformed to &#8220;All Years&#8221; and &#8220;All Regions&#8221; respectively to make the output more readable.<\/li>\n<li>Then, you&#8217;ll see the result of another subtotal summarizing All Regions by each Year, e.g., 2020 and 2021, displaying the total sales. In these JSON fields, values in the `region` attribute are transformed from `NULL` to &#8220;All Regions&#8221;.<\/li>\n<li>After that, we see another subtotal summary for &#8220;All Years&#8221; displaying the total sales for each region, e.g., Alabama &amp; California. In these fields, values in the `region` attribute are transformed from `NULL` to &#8220;All Regions&#8221;.<\/li>\n<li>Por \u00faltimo, el resultado muestra las ventas totales de cada regi\u00f3n para cada a\u00f1o. En este ejemplo, las ventas de California para el a\u00f1o 2020<\/li>\n<\/ol>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<h2>Conclusi\u00f3n<\/h2>\n<p>Espero que est\u00e9s entusiasmado con esta nueva capacidad de agregaci\u00f3n CUBE que extiende las poderosas expresiones anal\u00edticas disponibles para ti en Couchbase Analytics. Para m\u00e1s informaci\u00f3n, <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/3_query.html?ref=blog#Cube\" target=\"_blank\" rel=\"noopener\">consulte el <code>CUBO<\/code> documentaci\u00f3n<\/a>. Espero que esta nueva capacidad le resulte \u00fatil para futuros proyectos de an\u00e1lisis de datos en su empresa.<\/p>\n<p>Estoy deseando <a href=\"https:\/\/www.couchbase.com\/blog\/es\/forums\/?ref=blog\" target=\"_blank\" rel=\"noopener\">sus comentarios en los foros de Couchbase<\/a> - \u00a1H\u00e1ganos saber lo que piensa!<\/p>\n<div class=\"wp-block-spacer\" style=\"height: 30px\" aria-hidden=\"true\"><\/div>\n<div style=\"text-align: center\"><strong>Pruebe Couchbase Analytics:<br \/><a href=\"https:\/\/www.couchbase.com\/blog\/es\/downloads\/?ref=blog\" target=\"_blank\" rel=\"noopener\">Descargar Couchbase hoy<\/a><\/strong><\/div>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Data analytics capabilities in Couchbase just got more robust with the 7.0 release. I&#8217;m excited to announce two new powerful capabilities now available as part of Couchbase Analytics: 1) the CUBE functionality, and 2) ROLLUP aggregation, both to help you [&hellip;]<\/p>","protected":false},"author":58630,"featured_media":11726,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2294,1816,1812],"tags":[2014,9237,2155,9354,1261,9353],"ppma_author":[8967],"class_list":["post-11724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-couchbase-server","category-n1ql-query","tag-data-analysis","tag-data-analytics","tag-ecommerce","tag-group-by","tag-json","tag-super-aggregate-rows"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.4 (Yoast SEO v26.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics<\/title>\n<meta name=\"description\" content=\"Walk through this example of the new CUBE extension in Couchbase Analytics to learn how to generate super-aggregate rows as part of your data analysis.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics\" \/>\n<meta property=\"og:description\" content=\"Walk through this example of the new CUBE extension in Couchbase Analytics to learn how to generate super-aggregate rows as part of your data analysis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-17T07:00:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:32:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics-social.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Idris Motiwala\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics-social.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Idris Motiwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\"},\"author\":{\"name\":\"Idris Motiwala\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\"},\"headline\":\"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics\",\"datePublished\":\"2021-08-17T07:00:12+00:00\",\"dateModified\":\"2025-06-14T00:32:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\"},\"wordCount\":553,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg\",\"keywords\":[\"Data Analysis\",\"data analytics\",\"ecommerce\",\"GROUP BY\",\"JSON\",\"super-aggregate rows\"],\"articleSection\":[\"Couchbase Analytics\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\",\"name\":\"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg\",\"datePublished\":\"2021-08-17T07:00:12+00:00\",\"dateModified\":\"2025-06-14T00:32:19+00:00\",\"description\":\"Walk through this example of the new CUBE extension in Couchbase Analytics to learn how to generate super-aggregate rows as part of your data analysis.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Learn about the CUBE sub-clause in Couchbase Analytics in this working example using ecommerce data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\",\"name\":\"Idris Motiwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"caption\":\"Idris Motiwala\"},\"description\":\"Idris is a Principal Product Manager, Analytics at Couchbase with 20+ years experience in design, development and execution of software products at both Fortune 500s and startups leading teams in digital transformation, cloud and analytics. Idris holds an MS in Technology Management and certifications in product management .\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/idrismotiwala\/\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Mejora tu an\u00e1lisis de datos con la nueva funcionalidad CUBE de Couchbase Analytics","description":"Recorre este ejemplo de la nueva extensi\u00f3n CUBE en Couchbase Analytics para aprender a generar filas superagregadas como parte de tu an\u00e1lisis de datos.","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:\/\/www.couchbase.com\/blog\/es\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/","og_locale":"es_MX","og_type":"article","og_title":"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics","og_description":"Walk through this example of the new CUBE extension in Couchbase Analytics to learn how to generate super-aggregate rows as part of your data analysis.","og_url":"https:\/\/www.couchbase.com\/blog\/es\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-08-17T07:00:12+00:00","article_modified_time":"2025-06-14T00:32:19+00:00","og_image":[{"width":800,"height":418,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics-social.jpg","type":"image\/jpeg"}],"author":"Idris Motiwala","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics-social.jpg","twitter_misc":{"Written by":"Idris Motiwala","Est. reading time":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/"},"author":{"name":"Idris Motiwala","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8"},"headline":"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics","datePublished":"2021-08-17T07:00:12+00:00","dateModified":"2025-06-14T00:32:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/"},"wordCount":553,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg","keywords":["Data Analysis","data analytics","ecommerce","GROUP BY","JSON","super-aggregate rows"],"articleSection":["Couchbase Analytics","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/","url":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/","name":"Mejora tu an\u00e1lisis de datos con la nueva funcionalidad CUBE de Couchbase Analytics","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg","datePublished":"2021-08-17T07:00:12+00:00","dateModified":"2025-06-14T00:32:19+00:00","description":"Recorre este ejemplo de la nueva extensi\u00f3n CUBE en Couchbase Analytics para aprender a generar filas superagregadas como parte de tu an\u00e1lisis de datos.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/couchbase-analytics-cube-sql-extension-for-data-analytics.jpg","width":1200,"height":628,"caption":"Learn about the CUBE sub-clause in Couchbase Analytics in this working example using ecommerce data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/level-up-your-data-analytics-with-the-new-cube-functionality-in-couchbase-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8","name":"Idris Motiwala","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a","url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","caption":"Idris Motiwala"},"description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos .","sameAs":["https:\/\/www.linkedin.com\/in\/idrismotiwala\/"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/"}]}},"authors":[{"term_id":8967,"user_id":58630,"is_guest":0,"slug":"idris-motiwala","display_name":"Idris Motiwala","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","author_category":"","last_name":"Motiwala","first_name":"Idris","job_title":"","user_url":"","description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos ."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/11724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/58630"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=11724"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/11724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/11726"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=11724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=11724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=11724"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=11724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}