Post reply

Regarding Cube Creation....

  • May 21, 2008 at 2:43 am

    #187987

    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. EmpCode EmpName Date In Out Actual In HRS Total HRS. Department

    1 010 DEVALINGAM 5/16/2008 09:04 19:47 8 10:43 Admin

    2 035 GEETHA G 5/16/2008 14:00 19:00 05:00 05:00 Admin

    3 159 TAMIZHSELVI M 5/16/2008 09:41 19:21 09:17 09:40 Admin

    4 165 RAMASAMY T R 5/16/2008 08:23 20:12 11 11:49 Admin

    5 181 AISHWARYA K 5/16/2008 09:31 20:12 10:21 10:41 Admin

    6 135 SREEKANTH R S 5/16/2008 07:00 16:00 08:43 09:00 AP

    7 156 HARIKRISHNAN R 5/16/2008 09:17 20:55 11:14 11:38 AP

    8 164 THIRUNAVUKKARASU A 5/16/2008 08:26 17:05 08:29

    9 200 NARAYANAN R 5/16/2008 07:32 19:05 11:21 11:33 AP

    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

    #818449

    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

    #818625

    Go buy the Kimball groups book 'The Microsoft Data Warehouse Toolkit'. It contains all that you seek...

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • May 28, 2008 at 1:39 am

    #821009

    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