May 21, 2008 at 2:43 am
hi friends,
In cube creation what are all the basic things i have to follow....
Is the primary key and foreign key relationship must be there for creating a cube ?
what a fact table?
The following is the table i want to create a cube?
S.No.EmpCodeEmpNameDate In OutActual In HRSTotal HRS. Department
1010DEVALINGAM5/16/200809:0419:47810:43 Admin
2035GEETHA G5/16/200814:0019:0005:0005:00 Admin
3159TAMIZHSELVI M5/16/200809:4119:2109:1709:40 Admin
4165RAMASAMY T R5/16/200808:2320:121111:49 Admin
5181AISHWARYA K5/16/200809:3120:1210:2110:41 Admin
6135SREEKANTH R S5/16/200807:0016:0008:4309:00AP
7156HARIKRISHNAN R5/16/200809:1720:5511:1411:38AP
8164THIRUNAVUKKARASU A5/16/200808:2617:0508:29
9200NARAYANAN R5/16/200807:3219:0511:2111:33AP
The table has no primary key defined I tried to make a cube out of this..But it doesnot worked...
Fact table must not have dimension is the error i got....SO i went on to split the table into two tables by making EMPCOde as primary key
Factet Table
--------------
EMPcode
Empname
Department
Dimension Table
---------------
Empcode
In
out
Actual In hrs
Total Hrs
Date
Can u please tell me the approach is correct...How to set the dimesion and Hierachies for the table....am new to this BI.....Kindly help me out ASAP....
Thanks & Regards
Vijay
May 21, 2008 at 4:13 am
hi,
Share any ideas mate with me mate..am a new bie in this....any discussion will surely helps me...
Regards
vijay
May 21, 2008 at 8:55 am
Go buy the Kimball groups book 'The Microsoft Data Warehouse Toolkit'. It contains all that you seek...
Ben Sullins
bensullins.com
Beer is my primary key...
May 28, 2008 at 1:39 am
Hi,
Without understanding your exact requirement, it would be difficult to help. How do you want your cube to look like? what do you want to analyze? what are the dimensions?
Be clear about your requirements first before starting with your design.
Regards,
Vijay.
Warm Regards,
Neel aka Vijay.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply