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 |
|
ThoseWhereTheDays
Starting Member
2 Posts |
 Posted - 2010-03-17 : 12:31:52
|
| According to hint "Do not ignore duplicate key errors." ( http://technet.microsoft.com/en-us/library/bb630297.aspx ) it is strongly advised to change the default setting of processing a cube or dimension. (Status warning: medium)How To: Hit Process Icon > Process Cube Dialog > [Change settings...] > Change Settings Dialog (Two tab window)> Tab: Dimension key errors > Use custom error configuration > Specific error conditions become changeable > Change Duplicate Key from "ignore error" to either "Report and continue" or "Report and stop". Reason: It is said that it can be difficult to detect problems with incorrect key columns, incorrectly defined attribute relationships or data consistency issues. Instead of using the "Ignore Error" setting, it is typically better to correct your design and clean the data.Seems to be a reasonable suggestion! However, by implementing this suggestion, I noticed that changing this setting is not accepted somehow. Although, I have not seen this warning deploying my own fresh build cube, it's one of those warnings which persists in the tutorial of AdventureWorksDW2008, which I use as a sort of guide (http://technet.microsoft.com/en-us/library/ms170208.aspx).Changing the process default settings, in both cases (tutorial and my own) and deploying those cubes again, in both cases: "Deployment Successfully", I noticed that the settings are reset to default. Moreover, trying to change to custom setting at the server: no luck as well! As well on the server as within the analysis projects, every change is directly reset to default values (at cube level and at dimension level). On top of this, trying to let the system write to a log file, is not possible either. Questions: Is this because changing to custom settings is not supported at a standard edition of Analysis Service? No such message did pop up.Why does Analysis Services Project reset to default values instead of keeping changes as suggested???UpdateSomebody is telling/suggesting: that every time a process is performed, either in project or from server instance, these settings are changed back to default "by design". I should make them every time I perform a process. It is very possible, due to some lack of knowledge of AS 2008, that this behavior: every time a process of a cube or dimension is performed it will change its settings back to default ... triggers my eyebrows frowning ...is this really true?? |
|
|
|
|
|
|
|
Change Settings does not keep "changed settings"