What I would do is use a third "Dummy" Attribute to do the swapping.
So we have attribute A, attribute B, and our Dummy attribute C.
So the Operation would be
A-->C
B-->A
C-->B
Blank or zero "C".
EDIT: In case you just want to swap data is the same operation.
Search found 9 matches
- Tue Aug 02, 2016 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SwapAliasWithPrincipalName
- Replies: 6
- Views: 8996
- Thu Apr 28, 2016 5:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: headcount planning cube design
- Replies: 5
- Views: 4847
Re: headcount planning cube design
hello guys.. can anybody please help me.. i need to design a cube for HEADCOUNT PLANNING ..i will be calculating the Total headcount comprising of various RGFTEs.. please help me out how to write the rules and feeders for this.. and a basic cube design for this.. i am new to cognos tm1. So basicall...
- Thu Apr 28, 2016 12:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to extract the input values from the picklist and transfer to different cube
- Replies: 3
- Views: 2922
Re: How to extract the input values from the picklist and transfer to different cube
Hi, New to TM1,trying to learn. I would like to know ,how to extract the input values from the picklist and transfer to a different cube. Example: Car model year color Camry 95 red I want to assign "camry,95, red " values to a different cube. Thanks in advance. I might be wrong but as far...
- Thu Apr 28, 2016 12:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: linking cubes
- Replies: 4
- Views: 3869
Re: linking cubes
i have one cube A which contains, lets say, 4 dimensions: name, location, amount, sum total. and other cube b: location, currency, exchange rates. Now i want that if user inputs something in cube A according to the location , then TM1 must take the corresponding exchange rates from cube B , multipl...
- Thu Apr 28, 2016 12:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Execute Powershell Script from TI
- Replies: 6
- Views: 10775
Re: Execute Powershell Script from TI
While I don't pretend to be an expert when it comes to Powershell scripts, I do execute a few in various models. The Powershell script reference has always been initiated without issue using the syntax below (in TM1 versions 10.1 - 10.2.2): ExecuteCommand( 'Powershell E:\Restore\Planning_Prod.ps1',...
- Thu Apr 28, 2016 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: editing views & subsets
- Replies: 3
- Views: 3304
Re: editing views & subsets
Cubes cannot be edited in that way. The only way to "switch" dimensions in a cube is actually destroying the actual cube and re-creating it. There are some TI's out there that can help you move data from the original cube to a new one having the dimensions you need, but in case of the view...
- Mon Mar 04, 2013 1:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Link in Performance Modeler giving Validation error
- Replies: 10
- Views: 9194
Re: TM1 Link in Performance Modeler giving Validation error
I found the solution to this issue "should be a validated member": Actually seems pretty silly but it works (at least it worked for me), you have to open the dimension that contains the elements that have the picklists on them and are being displayed as virtual dimensions, Once you open th...
- Mon Mar 04, 2013 12:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Link in Performance Modeler giving Validation error
- Replies: 10
- Views: 9194
Re: TM1 Link in Performance Modeler giving Validation error
Im having this exact same issue and I don't know how to fix this.
Did anyone come up with a good idea?
Thanks,
Bruno
Did anyone come up with a good idea?
Thanks,
Bruno
- Fri Jun 22, 2012 2:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issues Regarding TI CellPut
- Replies: 1
- Views: 2102
Issues Regarding TI CellPut
Hi everyone, again I'm asking for your help again so you can drive away our shadows with your light of wisdom. When we have a user to select paramaters that are used in a TI to generate a Temporal Dinamic View of a cube, and we run a process using this dinamic view, and the process executes a Cellge...