March 16, 2012 at 9:01 am
Hello,
I created a cube using Visual Studio 2005, and it works fantastic. The only issue I have is refreshing the cube. When I try to refresh the cube after any changes are made to the fact and/or dimension tables I get an error that says the records do not exist either in the fact or dimension table. So, my solution to this is to delete all of the dimensions and the cube, and just create a new cube. This obviously is not best practice, but it works.
Does anyone know if there is an order that I have to follow when refreshing the cube? Perhaps I need to process the dimensions first and then the cube?
Any help would be appreciated,
Dave
March 16, 2012 at 11:35 am
You're on target there Dave - always process (refresh preferably) your dimensions first, and your facts (partitions in the measure groups) second. THink of it this way - you can't load a sales transaction fro widget X if Widget X isn't in your inventory list.
Steve.
March 16, 2012 at 1:31 pm
Thank you very much Steve 🙂
I am new to analysis Services, and I appreciate your help.
March 16, 2012 at 3:19 pm
Worked perfectly 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply