I am new to SSAS, when I connected to Analysis Services thru SSMS, I expanded the databases, and right click "Process" for a particular AS database in order to reprocess it. The process option for that database is set to "Process Full". It then going thru the preset processing cubes, measure groups, & partitions. However, it returned an error with one of the SQL Queries underneath one of the partition. I could expand the SQL Queries underneath, and view the details. I then copy & paste it to a Query window in SSMS, and found the cause of the error.
But how can I fix that ? I can't use SSMS to alter the queries. I understand that I might need to use BIDS to do the update. Can someone point me to somewhere which can give me some tour of how to achieve that, please ?