Hi,
please find the attachment, i have an issue with the branch and franchise, the branch codes are repeating for franchise and franchise codes for branch as well.
I have changed by giving prefixes.
Thanks and regards
TM1 9.5
excel 2007
Sorting of elements
-
viswaraju
- Regular Participant
- Posts: 177
- Joined: Thu Nov 05, 2009 8:45 am
- OLAP Product: IBM COGNOS TM1
- Version: 9.5
- Excel Version: 2007
Sorting of elements
- Attachments
-
- hierarchy issue
- HIERARCHY.jpg (46.02 KiB) Viewed 2339 times
-
Duncan P
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Sorting of elements
If you could reply attaching the process (file with .PRO extension) that builds this dimension and the datasource from which it get the members it will be easier to see what the problem is. I am presuming by the way that this is a continuation of the "Filters in TM1" thread.
Cheers,
Duncan.
Cheers,
Duncan.
-
vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Re: Sorting of elements
Yes
The repeating or circular loops may occur if the Data Source you are loading have repeating hierarchy.Until and unless you provide your data source or a sample source which is exactly similar to your source and your process file (.Pro) then i or any one can help you out.
The repeating or circular loops may occur if the Data Source you are loading have repeating hierarchy.Until and unless you provide your data source or a sample source which is exactly similar to your source and your process file (.Pro) then i or any one can help you out.
Thanks
Vinnusea
Vinnusea