SAP BW InfoCube/Query Design Template

Table of Contents

SAP BW InfoCube/Query Design Template

 

Hi Fellow SAP BW Consultants

 

 

Today will be a short one as I just wanted to share a template that SAP doesn't seem to provide, although they provide a picture of it.

This is a SAP BW Infocube/Query Design Template based on excel. I could not find it on SDN nor out there on the web anywhere, so had to create it on my own. 

 

Convert an Oracle Data Model

 

Would be interested in knowing if anybody , perhaps someone from another SAP Partner, has used this or has a better one to share. I recently had a chance to use this to convert a data model based on Oracle Express into a SAP BW Data Model and seemed to work fine, though need to work on the Hierarchy Design part a little bit more than data governance

SAP BW Business Content

My plan is to make a video of taking business content and actually completing one of these to see if it is really helpful in the build process.  It should reduce the risk considerably of a bad build.

 Query Designer Image

 

Get the SAP BW  Query Design Template

 

 If you find this template useful or have a useful update to it, would like to hear you comments on it.

 

Thanks


 

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

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

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by 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.