TM1 Forum

When I am copying data from one cube to another ,Cube A has picklists defined on it.The process is giving me an error "dimension name,element name invalid key error,and it is true those elements are not part of the target cube dimensions.
Strangely these elements doesn't exist in the named dimension of source cube ,error log file shows valid data entries against these interactions for these elements.
So ,I think these elements are also defined through picklist rules since I wrote a process which picks up static picklists on dimensions and it returned blank.I searched for rules for these may be picklist (with extra elements)but couldn't able to find it ,doesn't have anything in control cubes or even data directory in terms of .Rux files.
Has somebody else also come across this? How do I find it and delete them.Thanks in advance for your help.

Have you tried looking in the attributes for the dimension where the picklist is defined? Remember there are 2 ways to create a picklist.

Thanks Jim,I forgot to mention this before,Yes,I did looked at the attributes of dimensions in questions,Nothing in there!

Did you use PM to set them up? I know that can do some weird and wacky things with cube links. I would check there as well.

Thanks a lot again,No ,I didn't use PM ,We are still using 9.5.2.Could anything to do with it?

I've just re-read your original post. Are you sure this anything to do with picklists? elements aren't defined by picklist, data is. If your getting invalid elements it's more likely to do with an alias than anything else. Are defining the alias via a picklist?

Thanks heaps,Jim.You were spot on there!It was actually the alias.