INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Do I need a new Dimension?

Do I need a new Dimension?

(OP)
Hi,

I have an OLAP cube.  One of the dimensions is based on a table called 'site_dim'.  The table contains site_id, and site_description columns.  Currently when browing the cube users can only see the 'site_id' field but they would also like to see the site_description.

I added the site_description as a member property of the site_id dimension and did a 'full process' on the cube to no avail.  

Now I am wondering if I need to create a new virtual dimension?

Thanks.

 

RE: Do I need a new Dimension?

you need to set your properties for your dimension members.  When you are in the dim editor you will need to highlight your site_id member look at the properties and you should see a key and name property.  set the name to be your desc column.

RE: Do I need a new Dimension?

(OP)
O.K.  I did that and when I went to "Full Process" the cube it failed.  "Detected two sibling members with the same name: N/A"

Indeed some of the rows have 'N/A' values for the site_descrption column so I guess it must not like the fact that the values are not unique?

Thanks for your help.

RE: Do I need a new Dimension?

That would be correct.

If you use a view as your datasource for the dimension then you can concatinate the id and name column to make them unique.

N/A (101)
N/A (102)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close