Post reply

Olap cube help in AS2005

  • June 23, 2009 at 5:00 am

    #207453

    D/A,

    Pls help on the below scenario.. created fact & dimension table & need to build a cube in ssas2005.

    FACT TABLE DIMENSION TABLE

    FKEY NAME FKEY AMOUNT

    1 YAS 1 100

    2 WAS 2 200

    3 RAS

    when i use above tables in ssas(fkey as relationship).. it showing error in 2005..i.e attribute key '3'

    not available in dimension table. Pls help whether i need to change any properties.

    Note:

    Above cube/table can be build in AS2000 without any error.

  • June 23, 2009 at 7:30 am

    #1013911

    Hi,

    In AS your dimension table has to account for all the foreign keys in the fact table. How can you have a foreign key value in a transactional(FACT) table that doesn't have a link to a primary key in a dimension table? If there is such a situation, it should still be catered for in your dimension table to ensure accurate reporting by including an 'Unknown'. Your dimension table should then contain:

    PKI Value

    1 USA

    2 UK

    3 Unknown

    as an example.

    ----------------------------------------------------------------------------------------------
    Struggling to find the question?
    http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply