dbTalk Databases Forums  

AS2000 issue - member names not updating

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2000 issue - member names not updating in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jesse O
 
Posts: n/a

Default AS2000 issue - member names not updating - 11-15-2005 , 02:26 PM






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!










Reply With Quote
  #2  
Old   
Tiago Rente
 
Posts: n/a

Default RE: AS2000 issue - member names not updating - 11-16-2005 , 08:54 AM






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:

Quote:
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!











Reply With Quote
  #3  
Old   
Jesse O
 
Posts: n/a

Default Re: AS2000 issue - member names not updating - 11-16-2005 , 02:40 PM



Not member properties I believe.

Can anyone from MS chime in?


"Tiago Rente" <TiagoRente (AT) discussions (DOT) microsoft.com> wrote

Quote:
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!













Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.