Search found 9 matches

by bmrizzuti
Tue Aug 02, 2016 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SwapAliasWithPrincipalName
Replies: 6
Views: 8996

Re: SwapAliasWithPrincipalName

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.
by bmrizzuti
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...
by bmrizzuti
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...
by bmrizzuti
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...
by bmrizzuti
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',...
by bmrizzuti
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...
by bmrizzuti
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...
by bmrizzuti
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
by bmrizzuti
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...