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

    Unanswered: Create dimension without member

    Hi

    Analysis manager won’t let me create dimension unless fact table filed has value init. Other words, how do I create MT dimension(dimension without member)

    thanks

  2. #2
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    I'm confused. Is this really a dimension? Or is this a dimension that doesn't exist now, but will in the future? (i.e. you're rolling out a new type of product and you've created new product dimension, but the fact table has no corresponding records). Can you plug an 'unknown' attribute into your fact and dimension?

    Let me know if I'm way off.

  3. #3
    Join Date
    Apr 2006
    Posts
    19
    Fact table has field called Due date which contains null values. When I create Due_date dimension, it won’t let me create, gives a message unable to count the members. I have to create dimensions out of all the fields in the fact table and send the cub to this person. Later this person will load the cub into his server and change data source and run the cub.
    But my question is , If in his source table due_Date has null values(no data) , when this person runs the cube , it will give the error right?

    Right now his source table due_date doen’t have values, but later he will had value into it.


    He wants me to create each field in the fact table one dimension, doesn’t matter the fact table filed contains data or not? Can I do that?

  4. #4
    Join Date
    Sep 2004
    Location
    CA
    Posts
    41
    Is this 2000 or 2005? I just tried this in 2000 and it worked. No errors.

  5. #5
    Join Date
    Apr 2006
    Posts
    19
    It's 2000, you mean , it let you create a dimension with out a member.

Posting Permissions

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