What it is
CUBE-it Zero is one of a range of Business Intelligence based products designed and built by Academy Software Products. It is designed to make the process of building OLAP cubes in SQL Server simple. CUBE-it Zero removes the need for a data warehouse to produce functional OLAP cubes. It does not require dimension data in order to be able to produce analysis services cubes. Why Zero? Because that's the level of SQL Server Analysis Services experience you'll need to produce a cube.
CUBE-it Zero is a Windows application that prompts you for the information it needs to build the cube. All you need to do is the following:
- Point it to your source database, e.g. a SQL Server or Access database
- Build or select a query in that database that produces all of your data
- Identify which columns in the query are dimensions (e.g. Product, Country) and which are Measures (e.g. Cost)
- Let CUBE-it Zero do the rest for you
It will open up the world of OLAP type reporting to those that it was previously a mystery to.
What it's Not
CUBE-it Zero is not a Data Warehousing tool. It will not take the place of properly designed and built Business Intelligence Solutions. Academy Software Products have a history of producing tools that provide this type of capability, the product is Data Academy® (http://www.dataacademy.com/) and is designed specifically to assist Data Warehousing professionals achieve higher quality results in a faster time.
CUBE-it Zero is designed to make the cube building process as simple as possible and therefore compromises have inevitably been made.
To find out more about CUBE-it Zero see the Product Overview.
For a tutorial guiding you through the steps taken to produce a simple cube see the Tutorial.
For more detailed analysis of each screen you'll use to build your cube see the Reference pages.
If you require any assistance with using Cube-it Zero, please feel free to mail the support desk at service@bi-lite.com
If you have any comments or thoughts you would like to share with us about Cube-it Zero, you can mail them to us at service@bi-lite.com or send them directly using the online form at http://www.bi-lite.com/support/comments.aspx
If you found CUBE-it Zero helpful, and would like to know more about Data Warehousing and what a Data Warehouse productivity tool can provide then either register your enquiry at http://www.dataacademy.com/product/enquiry.aspx and we'll get in touch, or call us on +44 (118) 921 1555.