Data warehousing in sql server 2008

Posted by 3bd on Stack Overflow See other posts from Stack Overflow or by 3bd
Published on 2010-04-22T21:38:29Z Indexed on 2010/04/22 21:43 UTC
Read the original article Hit count: 289

Filed under:

SQLServer

|

datawarehousing

|

visual-studio-2008

Hi All:
I am new to data warehousing and I am a little confused
plz provide some simple steps to create a cube and fill it and make querey on it
to know :
I have a database with the original data
and I have designed the star schema and made appropriate tables
I have created an analysis service project in VS 2008
and then I have made the data source -data source view-dimensions - and the cube
all that based on the star schema i have created previously

now: what should I do to:

fill this cube
make query on this cube

© Stack Overflow or respective owner

Related posts about SQLServer

High Sqlservr.exe Memory Usage

as seen on Server Fault - Search for 'Server Fault'
I have a problem with sqlservr.exe (version 2008). It use a more memory. I checked on windows taskbar manager, sqlservr.exe usage ( Mem usage - 8GB Ram). I dont know how can I fix it.Got the following metrics of the server using Perfmon: SQLServer:Buffer Manager Buffer cache hit ratio 13 SQLServer:Buffer… >>> More
SQL server 2008 R2 installation error

as seen on Super User - Search for 'Super User'
I have a windows 7,32 bit laptop. I am the administrator with all permissions. when I click on the SQL server 2008R2 set up file,it says : "SQL server set up has encountered the following error:Failed to retreive data for this request" click on OK. I have uninstalled all the components of SQL from… >>> More
SQL Monitor’s data repository: Alerts

as seen on Simple Talk - Search for 'Simple Talk'
In my previous post, I introduced the SQL Monitor data repository, and described how the monitored objects are stored in a hierarchy in the data schema, in a series of tables with a _Keys suffix. In this post I had planned to describe how the actual data for the monitored objects is stored in corresponding… >>> More
CreationName for SSIS 2008 and adding components programmatically

as seen on SQLIS - Search for 'SQLIS'
If you are building SSIS 2008 packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post. See also CreationName for SSS 2005. We start with… >>> More
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries

as seen on SQL Authority - Search for 'SQL Authority'
The job of an SQL Consultant is very interesting as always. The month before, I was busy doing query optimization and performance tuning projects for our clients, and this month, I am busy delivering my performance in Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning Course… >>> More

Related posts about datawarehousing

Tech Article: Using Oracle GoldenGate for Real-Time Data Integration

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Learn how to install, set up, and configure Oracle GoldenGate to easily achieve seamless replication of data between Oracle Database 10g and 11g. >>> More
Tech Article: Oracle Essbase Studio Deep-Dive

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Dive into a step-by-step tutorial that reflects real-world data warehousing complexities. >>> More
Finding the maximum value/date across columns

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
While working on some code recently I discovered a neat little trick to find the maximum value across several columns….. So the starting point was finding the maximum date across several related tables and storing the maximum value against an aggregated record. Here's the sample setup code:… >>> More
Insert into a star-schema

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read a lot about star-schema's, about fact/deminsion tables, select statements to quickly report data, however the matter of data entry into a star-schema seems aloof to me. How does one "theoretically" enter data into a star-schema db? while maintaining the fact table. Is a series of INSERT… >>> More
What is the best FREE solution to implement one ETL project in MySql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, What is the best FREE solution to implement one ETL project in MySql? Regards, Pedro >>> More