[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1587
  • Last Modified:

Where can I find some good templates for business design specifications for a dimensionally modeled cube?

I'm going to be designing a data cube for Cognos PowerPlay, using Cognos Transformer.  I'd like to lay out all of the business requirements in a very organized fashion.  Historically, our company has not done this in a standard way.  Each project collects the business requirements in its own unique way, and has its own unique type of requirements documentation...some don't have any at all.

Are there any websites that might have a handful of document templates I can reference, or can you share any from your own experience?
0
Tim86
Asked:
Tim86
1 Solution
 
welchb123Commented:
Here are a couple of possible sites for you to try.

Bi PM INstitute
This link has a pre-interview cover letter and interview tracking sheets to collect business requirements.
http://www.bipminstitute.com/data-warehouse/business-requirements.php

Kimball University
This is not a template but I think you will find it interesting.  The templates are in the toolkit books which if you don't have them already you should get them (The DataWarehouse toolkit - Kimball http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247 )
http://intelligent-enterprise.informationweek.com/channels/business_intelligence/showArticle.jhtml;jsessionid=IYNFPENKR3QYLQE1GHPCKHWATMY32JVN?articleID=199900328&pgno=1

If you are using SQL server I would recommend the templates in the documentation.
0
 
Tim86Author Commented:
Thanks.  This got me pointed in the right direction.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now