![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have a shared dimension in a AS2000 database and am having an issue with incremental processing. The member name is not getting updated when the shared dimension is in a cube which has data (the norm), however if the same shared dimension is not in a cubes the name gets updated fine. Basically once the dimension starts being used in cubes the member name are no longer updating. The dimension has three levels and is set to Changing = False. Member Keys on each level are set to uniqueness of True; on the entire dimension the property is set to False. Member names are set to uniqueness of False on all levels. It will update fine if Changing is set to True, however it's not a changing dimension in the sense of the members changing parents. They don't move, and anytime they do, we create a new key. It doesn't make any sense to have to set the dimension to Changing if just the member names are changing. I really have no idea what to do, or what the solution is. It's driving the end users nuts, and myself crazy! |
#3
| |||
| |||
|
|
Hi, I think that the problem is just the "Changing = False" property. The "Changing" property is regarding everything not just parent/child relations. "Jesse O" wrote: I have a shared dimension in a AS2000 database and am having an issue with incremental processing. The member name is not getting updated when the shared dimension is in a cube which has data (the norm), however if the same shared dimension is not in a cubes the name gets updated fine. Basically once the dimension starts being used in cubes the member name are no longer updating. The dimension has three levels and is set to Changing = False. Member Keys on each level are set to uniqueness of True; on the entire dimension the property is set to False. Member names are set to uniqueness of False on all levels. It will update fine if Changing is set to True, however it's not a changing dimension in the sense of the members changing parents. They don't move, and anytime they do, we create a new key. It doesn't make any sense to have to set the dimension to Changing if just the member names are changing. I really have no idea what to do, or what the solution is. It's driving the end users nuts, and myself crazy! |
![]() |
| Thread Tools | |
| Display Modes | |
| |