473,396 Members | 1,989 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to create Cube

Hi All,
I want to create a cube using MSSQL2000 i dont know any thing how to
create and what is parameter required so if any body help me i will be
thankfull to him/her.For information : i have 4 tables
custdetailtable which contain all about a customer as per example
customer ID,name,add,CUSTOMERID IS PRIMARYKEY,
Proddetail table which contain all about a product mean
productcode,productname,productvalue,dman (dateof manufacture),dexp
date of expire,etc etc PRODUCTCODE IS PRIMARY.
Sales this table contain data aboutsale mean sales detail
cusomerid,productcode,noofpieces,priceperunit,prod uct name,date of
sale. etc etc SALEID IS PRIMARYKEY,PRODUCTCODE AND CUSTOMERID IS
FOREIGNKEY AND PRODUCTCODE IS PRIMARYKEY,
and atlast i have a table name stok detail which contain product
id,DTOFman and DTofexpire and amount of product
here product id,DTOFman and DTofexpire are foreign key.
Jul 20 '05 #1
3 27900
Hi

I am not an expert on this but I would expect a good start is to read:

http://msdn.microsoft.com/library/de...build_6b77.asp
http://msdn.microsoft.com/library/de...build_0lyq.asp

I would also recommend reading some of the background information.

John

"Biswajit Barik" <bi***********@rediffmail.com> wrote in message
news:31**************************@posting.google.c om...
Hi All,
I want to create a cube using MSSQL2000 i dont know any thing how to
create and what is parameter required so if any body help me i will be
thankfull to him/her.For information : i have 4 tables
custdetailtable which contain all about a customer as per example
customer ID,name,add,CUSTOMERID IS PRIMARYKEY,
Proddetail table which contain all about a product mean
productcode,productname,productvalue,dman (dateof manufacture),dexp
date of expire,etc etc PRODUCTCODE IS PRIMARY.
Sales this table contain data aboutsale mean sales detail
cusomerid,productcode,noofpieces,priceperunit,prod uct name,date of
sale. etc etc SALEID IS PRIMARYKEY,PRODUCTCODE AND CUSTOMERID IS
FOREIGNKEY AND PRODUCTCODE IS PRIMARYKEY,
and atlast i have a table name stok detail which contain product
id,DTOFman and DTofexpire and amount of product
here product id,DTOFman and DTofexpire are foreign key.

Jul 20 '05 #2
It is impossible to pass full data warehousing knowledge in a newsgroup
posting but here is my attempt :)

First get it out of your transactional environment (OLTP). Use DTS to
transfer this to another database (preferably another server depending
on size).

You will want to decide the subject matter of your cube which for you
would be the sales. This is your lowest granularity and you will use
this table to create what is called your fact table. Your fact table
will consist of the lowest granular aggregations (sales) and foreign
keys back to the other tables which will be used as dimension tables.

This is the structure that you will use to build the cube from. You need
to install Analysis Services for SQL Server 2000. Go into Analysis
Manager and say new database. call it whatever you want.Here you will
add a data source that points to wherever you sent your transformed
table. then right-click on cubes and say new cube, use the editor not
the wizard. it will ask you what tables you want to use, specify your
fact table (the one with sales data and your key columns) and add it.
You can then add your dimension tables (details - like customer, product
and possibly stock in your case). In the cube editor you will create
dimensions (all real cubes need a date dimension) dimensions are
typically what the customer says they want to see the data "by"
Examples:

I want to see the number of sales by region (region would be a
dimension)
I want to see the average sales by customer (customer would be a
dimension)

Again, these are examples, might not apply to you.

Then you will pick your measures, these are your aggregations, WHAT do
they want to see (dollars, total orders, etc.)

Calculated members are more advanced and you can get into those by
looking at MDX examples. From there you need to process the cube and
then you can connect to it by using Excel pivot tables (or something
better once you get the hang of it)

If you want to know the theory and use of data warehousing/cubing get
Ralph Kimball's data warehouse lifecycle toolkit book, if you want to
quickly learn how to use analysis services get Reed Jacobson's "Analysis
Services: Step by Step"

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3
BTW: Before I get attacked :), my post, of course, if no where near full
data warehousing information. There are several things that were left
out, checking out those two books and websites like dmreview.com or
intelligententerprise.com will help get more DW knowledge.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: mrwoopey | last post by:
Hi, My OLAP data cube is giving me the following error when I am manipulating OLAP data cube views: "the data being processed is over the allowed limit" I know that this message is caused by...
0
by: mrwoopey | last post by:
Hi, I am using the OLAP data cube in a web browser (using the code from the SQL 2000 toolkit). The OLAP services is on database server and the web interface is on the web server. If we do simple...
4
by: Dmitry Tkach | last post by:
Hi, everybody! I am trying to create a custom GiST index in 7.3, but getting an error, that I don't know how to interpret: testdb=# create table gist_test (field int8); CREATE TABLE testdb=#...
2
by: ravindra4s | last post by:
hi...I am very new to DB2 Cube views, I worked with MS Analyis services earlier and this is new assignment for me to work with DB2 Cube views, Can I get any help regarding this..........Is DB2...
0
by: Dip | last post by:
Hello Experts, I was wondering whether it is possible to create "Cube Roles" automatically. I have a table name called tblUsers which has "ProjectID" and "EmployeeID". Employees are allocated...
0
by: jai83 | last post by:
I have a doubt regarding alphablox-cube views. I have created a cube in the olap centre(using db2 cube view 8.1.10).I imported the cube in alphablox.But while drilling down i am not able to retrieve...
0
by: DC01 | last post by:
I have added a new measure successfully into the normal cube. I then add it to the virtual cube and reprocess all cubes. I can browse the normal cube successfully. Then when I try and browse the...
0
by: Tim | last post by:
Hi Folks, I'm not certain if this is the correct group to post this question in, if there is a more appropriate one please advise. We have a cube that takes a little time to build, length of...
6
by: blackraven1425 | last post by:
I'm using JMonkeyEngine, and trying to make objects in a cube. Meaning, a three-dimensional cube out of objects (Spheres, to be specific). However, the logic is escaping me. This is what I have so...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.