SSAS: column missing in measure group columns list for dimension usage

using SQL server 2008 R2 enterprise edition.

I added some new columns (dimension ids) to my fact table and refreshed the data source view. Now the new columns show up in the data source view for this fact table. But when I go to dimension usage to tie the new dimensions to this measure, I am not able to find the columns just added in the measure group columns list.

What do I have to do to be able to see my new columns in this list so that I can update dimension usage.



Thanks.
patd1Asked:
Who is Participating?
 
patd1Connect With a Mentor Author Commented:
Replace table with new named query on data source view worked to add columns correctly.
0
 
James ElliottManaging DirectorCommented:
Have you tried refreshing the intellisense (CTRL+SHIFT+R)?
0
 
patd1Author Commented:
Intelisense? I am not working in management studio. I am working in visual studio (analysis services project)
0
 
James ElliottManaging DirectorCommented:
apologies. Fridays.
0
 
patd1Author Commented:
Replace table with new named query on data source view worked to add columns correctly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.