Link to home
Start Free TrialLog in
Avatar of patd1
patd1Flag for United States of America

asked on

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.
Avatar of James Elliott
James Elliott
Flag of United Kingdom of Great Britain and Northern Ireland image

Have you tried refreshing the intellisense (CTRL+SHIFT+R)?
Avatar of patd1

ASKER

Intelisense? I am not working in management studio. I am working in visual studio (analysis services project)
apologies. Fridays.
ASKER CERTIFIED SOLUTION
Avatar of patd1
patd1
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of patd1

ASKER

Replace table with new named query on data source view worked to add columns correctly.