Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating warehouse in SQL 2008..Unified Metadata layer to build report in Cognos Expand / Collapse
Author
Message
Posted Monday, April 20, 2009 1:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 19, 2010 9:54 AM
Points: 2, Visits: 43
Hello,
I am trying to build reporting warehouse that will have last 3 years of data. It will be in SQL server 2008.

My main goal of creating reporting database and then use cognos reports as reporting tool. We are planning to create metadata layer after building relational/multi dimentional data warehouse into SQL server 2008.


1) what would be best to develop, relational or dimensional datawarehouse?
2)Do i need to build cubes on top of these warehouse?
3) After creating warehouse how do i create that metadata layer?

This is a starting of project so i want to get clear idea what would be the best approach to achieve end goal.


I appreciate your fedback.

Aaddi.
Post #700963
Posted Tuesday, April 21, 2009 12:23 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 25, 2010 10:10 AM
Points: 297, Visits: 267
Why do you want to use Cognos? Does your client already have it implemented?


Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...
Post #701749
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse