Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubble
Starting Member
24 Posts |
 Posted - 2007-09-11 : 12:37:17
|
| We are using SQL 2005, Visual Studio 2005, SSIS, and SSAS. We have built our Dimensional model in SQL 2005, we have build our packages to complete full refresh of Dimensional model using SSIS. We have built SSAS cube using VS 2005. We built source, data source, cube and dimensions using auto build. We processed cube in VS 2005 by right clicking on solution and click process. Cube was built in Analysis Services. We made some schema changes to model then data changes in SSIS packages. We then pulled up cube in VS 2005 right click on solution and process. Cube is being re-built. After completion we check cube using Proclarity and Excel 2007 and notice the schema changes and data changes did not take. We dropped cube, then deleted data source, dimensions, and cube then re-created data source view and cube auto build then process and now have new schema changes and data changes. Why is process not working to re-build schema and data changes when we have process FULL selected, Changes only. We even tried rebuild, deploy, and process. What is it we are missing or not doing correctly????????? Topic |
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-11 : 14:11:15
|
| If I am managing our cube within Studio 2005 and right mouse click on solution and then click PROCESS should that not implement all changes I have made to the Dimensional Model????? HELPPPPP |
 |
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-12 : 12:00:54
|
| No Answers or Help for RUBBLE yet on this. Can someone please help with this Question??????????????????????????????????????????????????????? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:14:55
|
| Processing cube is different from design cube, processing cube just get data from data source and generate aggregations. |
|
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-13 : 09:37:20
|
| Yes, but to get the new schema changes and data chagnes from dimensional model to Cube HOW DO YOU DO THAT?? We thought you just have to open BI Studio Analysis Services CUBE and <right click> and select <PROCESS> &&& that is not updating the CUBE with the new schema changes and it is not bringing over the new data.SO, We NEED HELP Because we are new to SSAS 2005 and from reading books, online, etc. that is what we read to do. HELP... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 23:24:34
|
| No, as I said processing cube doesn't change cube structure. You need to recreate it. |
|
|
|
rubble
Starting Member
24 Posts |
Posted - 2007-09-20 : 09:14:20
|
| Does that mean; we have to Delete Cube, then re-create Data source, Data Source View, and Cube within BI Studio??Your Help IS Greatly Appreciated due to the fact we need to update our dimensional model with new columns, and updated data types and everytime we <PROCESS> cube within Solution Explorer the changes due to not make it to the cube. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-22 : 23:08:10
|
| You can create new one and keep existing one. |
|
|
|
|
|
|
|
|
Process Cube changes