patd1
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.
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.
Have you tried refreshing the intellisense (CTRL+SHIFT+R)?
ASKER
Intelisense? I am not working in management studio. I am working in visual studio (analysis services project)
apologies. Fridays.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Replace table with new named query on data source view worked to add columns correctly.