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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2010-04-19 : 15:34:29
|
| I just added two years of data to a cube. This should have added 700 new members to the PeriodEndDate dimension. And yet when i did a Process Full, only the Fact tables processed. None of the dimensions processed. Can you guys think of any reason why this would be? Incremental data that adds new dimension members isn't causing those dimensions to be processed, except when the cube has just been created without data. Is this correct behavior? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-20 : 01:03:14
|
| have you set the relationships with dimensions correctly?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2011-01-16 : 06:10:13
|
| I have the same problem - sometimes my cube fails because of addition of new values to Dim table. If I process that Dim manually, cube's full process succeeds. What is amiss? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-16 : 06:23:27
|
| are you trying to process the cube manually or via xmla script?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2011-01-16 : 06:41:09
|
| through SSIS process that runs automatically |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-16 : 06:52:25
|
| whats the process option selected? process full or process update?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2011-01-16 : 06:53:10
|
| process full |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2011-01-16 : 08:57:38
|
| I hope that here is the solution - for full process (with DIMS) you must choose database full process (not cube full process, as I did), for manuall run from BIDS - process the whole project, not cube |
|
|
|
|
|
|
why don't dimensions process when new data added?