--- title: SAP BW InfoCube/Query Design Template description: Building SAP BW Query's requires some advanced planning. We have built this SAP BW Infocube/Query Template for your usage when building your query's. image: https://www.sapbwconsulting.com/hs-fs/file-16580622-png/images/query_designer_image.png --- ![](https://www.sapbwconsulting.com/hs-fs/file-16580622-png/images/query_designer_image.png) # SAP BW InfoCube/Query Design Template Table of Contents ## SAP BW InfoCube/Query [Design Template](https://www.sapbwconsulting.com/resources/sap-bi-technical-definition)   Hi Fellow [SAP BW Consultants](https://www.sapbwconsulting.com/blog/introducing-sap-bw-consulting-business-intelligence-that-works)     Today [will be a](https://www.sapbwconsulting.com/blog/inbound-marketing/how-important-is-data-governance-to-internet-marketing) short one as I just wanted to share a [template](https://www.sapbwconsulting.com/blog/what-is-the-tco-of-that-shinny-new-system-youre-about-to-buy) that SAP doesn't seem to provide, although they provide a picture of it.   This is a [SAP BW Infocube/Query Design Template](https://www.sapbwconsulting.com/get-our-query-design-template/) based on [excel](https://www.sapbwconsulting.com/how-to-increase-profitability-sap-profitability-management-guide). I could not find it on SDN nor out there on the web anywhere, so had to [create it](https://www.sapbwconsulting.com/blog/cots-vs-custom-development-decision-tree-analysis) on my own.  It helps when you finalize your [SAP BW InfoCube](https://www.sapbwconsulting.com/how-to-increase-profitability-sap-profitability-management-guide)/Query [design requirements specification](https://www.sapbwconsulting.com/blog/sap-bw-tutorial-best-practice-on-requirements-gathering).   ## Convert an Oracle [Data Model](https://www.sapbwconsulting.com/request-sap-business-planning-and-consolidation-sap-bpc-consulting-support)   Would be interested in knowing if [anybody , perhaps](https://www.sapbwconsulting.com/develop-a-data-governance-framework) someone from another [SAP Partner](https://www.sapbwconsulting.com/sap-partnership-advisory-services), has used this or has a better one to share. I recently had a chance to use this to convert a [data model](https://www.sapbwconsulting.com/blog/identifying-cause-of-data-load-error-when-using-a-sap-bw-dtp) based on Oracle Express into a [SAP BW Data Model](https://www.sapbwconsulting.com/request-sap-bw-naming-conventions-review) and seemed to work fine, though need to work on the [Hierarchy Design](https://www.sapbwconsulting.com/blog/5-kpi-design-best-practice-guidelines) part a little bit more than [data governance](https://www.sapbwconsulting.com/develop-a-data-governance-framework).  ## SAP BW Business Content My plan is to [make a video](https://www.sapbwconsulting.com/blog/inbound-marketing/5-best-ideas-how-business-can-grow-with-video) of taking [business content](https://www.sapbwconsulting.com/blog/inbound-marketing/does-pci-dss-compliance-affect-you) and actually completing one of these to see if it is really helpful in the build process.  It should [reduce the risk](https://www.sapbwconsulting.com/sap-sem-cpm-risk-register-design-template) considerably of a bad build.  ![Query Designer Image](https://www.sapbwconsulting.com/hs-fs/file-16580622-png/images/query_designer_image.png?width=186&height=134&name=query_designer_image.png)   [![Get the SAP BW Query Design Template](https://no-cache.hubspot.com/cta/default/118735/93d5422b-1d84-49d2-8070-e942c49aa5cd.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/93d5422b-1d84-49d2-8070-e942c49aa5cd)    *If you find this [template](https://www.sapbwconsulting.com/blog/how-to-use-a-project-charter-to-start-a-project) useful or have a [useful update](https://www.sapbwconsulting.com/resources/sap-bi-technical-definition) to it, would like to hear you comments on it.*   ## **Not Your Average SAP Shop** *We don’t just implement SAP — we drive adoption, accountability, and acceleration. Our differentiator? A unique mix of PMP-certified leadership, enterprise architecture, inbound marketing mastery, and business strategy execution.*   ### **Enterprise Growth. Engineered** *[SAP BW Consulting](https://www.sapbwconsulting.com/blog/understanding-the-most-common-sap-data-warehousing-concepts), Inc. is a high-performance consulting firm built for companies that run on SAP but want more than just technical implementation. We engineer profitability using a precision blend of SAP expertise, Balanced Scorecard strategy, and performance marketing firepower — all delivered by executive-level consultants.*     Topics from this blog: [SAP BW Consulting](https://www.sapbwconsulting.com/blog/topic/sap-bw-consulting) [Query Template](https://www.sapbwconsulting.com/blog/topic/query-template) [SAP BW InfoCube Design Template](https://www.sapbwconsulting.com/blog/topic/sap-bw-infocube-design-template) [How-To](https://www.sapbwconsulting.com/blog/topic/how-to) ### Download SAP BW Mindmap Learn what SAP Business Warehouse is and what it does in under five minutes [![Get this Mindmap](https://no-cache.hubspot.com/cta/default/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b.png)](https://cta-redirect.hubspot.com/cta/redirect/118735/8db2ad37-8211-47a3-86ae-09b6b2bb297b) [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ### Lonnie D. Ayers, PMP About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and ** remote coaching. ** ![Balanced Scorecard Consultant](https://www.sapbwconsulting.com/hubfs/social-suggested-images/Balanced%20Scorecard%20Certified%20Graduate.jpg) He also recently released a book **"How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results",** which is available on [ Amazon.](https://www.amazon.com/Dominate-Turbocharging-Digital-Marketing-Results/dp/1728357950/ref=sr_1_1?dchild=1&qid=1589182458&refinements=p_27%3ALonnie+D.+Ayers&s=books&sr=1-1&text=Lonnie+D.+Ayers)**** [View All Articles by Lonnie D. Ayers, PMP](https://www.sapbwconsulting.com/blog/author/lonnie-d-ayers-pmp) ## The SAP Blog Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email. [mailto:someone@yoursite.com](mailto:someone@yoursite.com) ![SAP](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/960101754/?value=0&guid=ON&script=0) ![](https://www.facebook.com/tr?id=199270410761059&ev=PageView&noscript=1) ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#blogposting", "@type" : "BlogPosting", "about" : [ { "@type" : "Organization", "name" : "SAP", "sameAs" : "https://en.wikipedia.org/wiki/SAP" }, { "@type" : "Thing", "name" : "SAP BW", "sameAs" : "https://en.wikipedia.org/wiki/SAP_Business_Warehouse" }, { "@type" : "Thing", "name" : "InfoCube", "sameAs" : "https://en.wikipedia.org/wiki/InfoCube" }, { "@type" : "Thing", "name" : "Information retrieval", "sameAs" : "https://en.wikipedia.org/wiki/Information_retrieval" }, { "@type" : "Thing", "name" : "Project management", "sameAs" : "https://en.wikipedia.org/wiki/Project_management" } ], "author" : { "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person" }, "description" : "This blog provides insights into SAP BW InfoCube query design and offers a free template to streamline your project management and query planning.", "headline" : "SAP BW InfoCube Query Design Template", "inLanguage" : "en", "mainEntityOfPage" : { "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#webpage" }, "mentions" : [ { "@type" : "Thing", "name" : "Microsoft Excel", "sameAs" : "https://en.wikipedia.org/wiki/Microsoft_Excel" }, { "@type" : "Thing", "name" : "Data", "sameAs" : "https://en.wikipedia.org/wiki/Data" } ], "name" : "SAP BW InfoCube Query Design Template", "potentialAction" : { "@type" : "ViewAction", "name" : "Get the SAP BW Query Design Template", "target" : { "@type" : "EntryPoint", "actionPlatform" : [ "http://schema.org/DesktopWebPlatform", "http://schema.org/MobileWebPlatform" ], "inLanguage" : "en", "urlTemplate" : "https://www.sapbwconsulting.com/get-our-query-design-template" } }, "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#website", "@type" : "WebSite", "name" : "SAP BW Consulting, Inc.", "publisher" : { "@id" : "https://www.sapbwconsulting.com#organization" }, "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#organization", "@type" : "Organization", "logo" : { "@id" : "https://www.sapbwconsulting.com#logo" }, "name" : "SAP BW Consulting, Inc.", "sameAs" : [ "https://www.linkedin.com/company/543163/admin/", "https://www.youtube.com/user/SAPBWConsulting/", "https://twitter.com/Lonniea39", "https://www.facebook.com/SAPBWConsulting" ], "url" : "https://www.sapbwconsulting.com" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com#logo", "@type" : "ImageObject", "caption" : "SAP BW Consulting, Inc. logo", "url" : "https://www.sapbwconsulting.com/hs-fs/hubfs/sapbw-consulting.png?width=2847&name=sapbw-consulting.png" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/about-lonnie-ayers#person", "@type" : "Person", "name" : "Lonnie D. Ayers", "sameAs" : [ "https://www.linkedin.com/in/lonnieayers" ], "url" : "https://www.sapbwconsulting.com/about-lonnie-ayers", "worksFor" : { "@id" : "https://www.sapbwconsulting.com#organization" } } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#webpage", "@type" : "WebPage", "breadcrumb" : { "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#breadcrumbs" }, "description" : "This blog provides insights into SAP BW InfoCube query design and offers a free template to streamline your project management and query planning.", "headline" : "SAP BW InfoCube Query Design Template", "inLanguage" : "en", "isPartOf" : { "@id" : "https://www.sapbwconsulting.com#website" }, "mainEntity" : { "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#blogposting" }, "name" : "SAP BW InfoCube Query Design Template", "url" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template" } ``` ```json { "@context" : "https://schema.org", "@id" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template#breadcrumbs", "@type" : "BreadcrumbList", "itemListElement" : [ { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com", "name" : "Home", "position" : 1 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog", "name" : "Blog", "position" : 2 }, { "@type" : "ListItem", "item" : "https://www.sapbwconsulting.com/blog/sap-bw-infocube-query-design-template", "name" : "SAP BW InfoCube Query Design Template", "position" : 3 } ] } ```