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.
Couldn't able to see picklist rules
-
- 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
"You Never Fail Until You Stop Trying......"
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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......"
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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......"
- 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
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
Thanks heaps,Jim.You were spot on there!It was actually the alias.
"You Never Fail Until You Stop Trying......"