Post reply

Issue in developing simple cube

  • August 25, 2009 at 7:18 am

    #133136

    Hi

    I'm facing big issue over last two days in building a simple cube.

    I'm new to SSAS and trying to build a simple cube with two table.

    I have a one table called SOP10100 and another table called SOP10200

    Columns of SOP10100

    SOPNUMBER

    Columns of SOP10200

    SOPNUMBER

    ITEMNUMBER

    QUNATITY

    (Actually the table has more columns and values and i reduced unwanted things from you for your easy understand)

    I created a two dimension with above two tables and with their columns

    And a created a cube with only one measure (QUNATITY).

    Below is my table structure SOP10200

    This is expected output

    This is my current output.

    The values are continously repeating irrelevant of ITEMNUMBER

    Kindly help me to solve this issue.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • August 25, 2009 at 7:33 am

    #1044159

    Go to the dimension usage tab in the cube designer and review the join/relationship between your fact table {measure groups} and your dimension table/s, it looks like the relationship/s are not currently set correctly - ie fact table/measure group SOP10200 isn't related to the dimension SOP10100.

    HTH,

    Steve.

  • August 25, 2009 at 7:53 am

    #1044188

    Thanks Steve.

    I tried it but its showing the following error

    Error4Errors in the OLAP storage engine: An error occurred while processing the 'SOP10200' partition of the 'SOP10200' measure group for the 'TWO' cube from the GP SOP database.00

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • August 25, 2009 at 8:06 am

    #1044203

    Hey Arunkumar,

    That error alone doesn't really tell us much (ie makes it haard to determine what might/could have gone wrong). Going back first to the Dimension Usage tab, did you review this? What was it set to and what did you change it to, if you changed it at all?

    Assuming it showed no relationship between the measure group and the dimension, and then assuming you changed this, did you then perform a full process? An update only? No processing at all, the error occurred when you were trying to save?

    There's a lot of people on the forum willing to try and help you but you need to help them by putting as much info out there as you can.

    Steve.

  • August 25, 2009 at 8:13 am

    #1044208

    Thanks a lot steve. I can understand you.

    Now i clicked the process and i got the detailed error. I try to solve this myself. If i can't, i'll come back with detailed info for help.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 5 posts - 1 through 4 (of 4 total)

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