Couldn't able to see picklist rules

Post Reply
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Couldn't able to see picklist rules

Post by BariAbdul »

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.
"You Never Fail Until You Stop Trying......"
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Couldn't able to see picklist rules

Post by jim wood »

Have you tried looking in the attributes for the dimension where the picklist is defined? Remember there are 2 ways to create a picklist.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Couldn't able to see picklist rules

Post by BariAbdul »

Thanks Jim,I forgot to mention this before,Yes,I did looked at the attributes of dimensions in questions,Nothing in there!
"You Never Fail Until You Stop Trying......"
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Couldn't able to see picklist rules

Post by jim wood »

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.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Couldn't able to see picklist rules

Post by BariAbdul »

Thanks a lot again,No ,I didn't use PM ,We are still using 9.5.2.Could anything to do with it?
"You Never Fail Until You Stop Trying......"
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Couldn't able to see picklist rules

Post by jim wood »

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?
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Couldn't able to see picklist rules

Post by BariAbdul »

Thanks heaps,Jim.You were spot on there!It was actually the alias.
"You Never Fail Until You Stop Trying......"
Post Reply