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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-12-17 : 04:29:01
|
| Hi,I have saved one of my favourite views (in my front-end tool) view gives me a day wise snapshot.At the moment the underlying dimension for this is not defined as a changing dimension. When I populated the tables in my data mart and then did a fullprocess of the dimensions and the cubes I noticed that the front-end did not automatically show a new day in my view and I had to do a manual refresh (via the front-end) top get the updated data.I then thought that this I can avoid this manual refresh I I define my dimension as a Changing Dimension. However this causes problems while processing the cubes as it givesme errors related to uniqueness at the last level of my dimension i.e. Minute (in this particular example).Can someone kindly guide me how to solve this.Many TIA.Thanks & Regards.-J |
|
|
|
|
|
Question related to Changing Dimensions