March 17, 2010 at 9:04 am
Hi All,
I have created a data source view in SSAS project connected to some tables in database x. After i created them there are some changes to the schema of the tables in database x. How to reflect those changes in my data source view. I tried to refresh but i was not able to see the changes. do i need to remove the table and add them again?
Appreciate your reply.
Thanks
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
March 18, 2010 at 5:04 am
Menu: DataSource View --> Refresh
Alternatively, there is a small refresh icon at the top left of the design window.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 3, 2010 at 12:23 pm
Thanks you just saved me tons of time!
July 5, 2013 at 5:28 am
Some occasion you get "Unable to prepare" under Change column. I had a situation where I changed the view name from vw_abc to vwabc and after that upon clicking refresh button I got "Unable to prepare" message.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply