Post reply

Refresh data source view in SSAS

  • March 17, 2010 at 9:04 am

    #139503

    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

    #1135835

    Menu: DataSource View --> Refresh

    Alternatively, there is a small refresh icon at the top left of the design window.

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

  • August 3, 2010 at 12:23 pm

    #1201734

    Thanks you just saved me tons of time!

  • July 5, 2013 at 5:28 am

    #1630022

    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