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

Posted on 2009-12-17
Last Modified: 2013-11-26
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?
Question by:Tim86
    LVL 5

    Accepted Solution

    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.

    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 );jsessionid=IYNFPENKR3QYLQE1GHPCKHWATMY32JVN?articleID=199900328&pgno=1

    If you are using SQL server I would recommend the templates in the documentation.
    LVL 46

    Expert Comment


    Author Closing Comment

    Thanks.  This got me pointed in the right direction.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    "Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now