Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2006
    Posts
    19

    Unanswered: split olap dimension members

    Argent
    Need to split olap dimension members into three different dimension members
    example
    account dimension member = 11111200900
    account_num.member = 11111
    item_num.member = 200
    sub_item = 900

    Please help me
    Thanks

  2. #2
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Sounds like you need to snowflake the dimension, right?

  3. #3
    Join Date
    Apr 2006
    Posts
    19

    account dimension coming from single fact table

    why do I need snow flake schema , i am using single fact table

  4. #4
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Quote Originally Posted by rammanju
    why do I need snow flake schema , i am using single fact table
    Maybe you could provide some more information. Based on your post, you gave a classic snowflake example (as I read it). But, maybe I'm misunderstanding you.

    Are you using 2000 or 2005?

  5. #5
    Join Date
    Apr 2006
    Posts
    19
    I have account dimension in my cub
    Account dimension contains members like
    11111200900
    22222300900
    33333300600
    11111100000

    I need spilt these members and store it into another dimensions like
    11111 = accunt_num dimension
    200 = item_num dimension
    900 = sub_item dimension

  6. #6
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Quote Originally Posted by rammanju
    I have account dimension in my cub
    Account dimension contains members like
    11111200900
    22222300900
    33333300600
    11111100000

    I need spilt these members and store it into another dimensions like
    11111 = accunt_num dimension
    200 = item_num dimension
    900 = sub_item dimension
    Ok. Maybe you could use the LEFT and RIGHT functions (and combination) to build the dimensions? See attachment.
    Attached Thumbnails Attached Thumbnails testdim.jpg  

  7. #7
    Join Date
    Apr 2006
    Posts
    19

    Thank you very much

    works great for left and right
    how do I Retrieve middle numbers like
    (11111200900)
    200

  8. #8
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Quote Originally Posted by rammanju
    works great for left and right
    how do I Retrieve middle numbers like
    (11111200900)
    200
    You need to use both LEFT and RIGHT. Like this...


    LEFT(RIGHT(Account,6),3)

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by phikappa
    You need to use both LEFT and RIGHT. Like this...


    LEFT(RIGHT(Account,6),3)
    Or SubString, like:
    Code:
    SELECT SubString(Account, 3, 6)
    -PatP

  10. #10
    Join Date
    Apr 2006
    Posts
    19
    Tahnk you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •