Search found 129 matches
- Wed Oct 05, 2011 11:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: cube disappeared
- Replies: 2
- Views: 2365
Re: cube disappeared
I have seen this issue as well. I have noticed that sometimes when you unload a cube it somehow removes it from memory. In my experience, the cube returns with a restart of the TM1 instance. Do you have any processing that would to do a "CUBEUNLOAD"? Mine has go away at times when I manual...
- Thu Sep 08, 2011 2:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mass commit of users' sandboxes
- Replies: 2
- Views: 2371
Re: Mass commit of users' sandboxes
There is no function to do such action. Although it may seem that such a function would be useful, it can be greatly harmful to commit a user's data without their permission. The user may be in the initial phase of submitting and may have just been inputting some test numbers to gauge how it would a...
- Mon Aug 22, 2011 4:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help with a specific Feeder stmt...
- Replies: 11
- Views: 7146
Re: Need help with a specific Feeder stmt...
After a quick glance, the feeders on the cube GL Budget Balances Revised seem wrong. Current: ['Open Bal']=DB('GL Budget Balances Revised',DB('zTime Navigation',!Fiscal Period,'Prior Period'),!Account Class,!GL Accounts,!Period Distributions,'Close Bal'); ['Close Bal' ] =['Open Bal' ] + ['BUD Adjs' ...
- Wed Aug 17, 2011 9:45 pm
- Forum: Useful code, tips and tricks
- Topic: Copying Data from 1 Element to Another via TI
- Replies: 29
- Views: 77623
Re: Copying Data from 1 Element to Another via TI
I have attached my latest version of the process which is much cleaner / easier to use. I also added the subsequent clear process. I have made several changes to improve the process.
Do let me know if you experience any issues with this.
Do let me know if you experience any issues with this.
- Tue Aug 02, 2011 11:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: incorrect consolidation value due to rounding at leaf level
- Replies: 5
- Views: 4921
Re: incorrect consolidation value due to rounding at leaf le
Where are you performing the rounding? If you have only formatted your view to not show decimals, then that does not change the underlying data values and would cause the situation you presented.
- Fri Jul 29, 2011 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel Interaction
- Replies: 7
- Views: 4529
Re: Parallel Interaction
when you ran the chore without the security update, was system still locked for the entire chore?
If so, you can also manually create cube dependencies which not create the locks.
If so, you can also manually create cube dependencies which not create the locks.
- Thu Jul 28, 2011 1:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel Interaction
- Replies: 7
- Views: 4529
Re: Parallel Interaction
Is the security update the first item in the chore, if so it will create a server lock when the process starts to when the entire chore finishes.
- Wed Jun 15, 2011 2:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Client name does not exist on the server - CognosBI security
- Replies: 4
- Views: 4134
Re: Client name does not exist on the server - CognosBI secu
After trying to login once with security at 4, have you gone back to security at 2 and checked if your user name is exists in the Client dimension.
- Wed Jun 15, 2011 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process Last Ran Date.
- Replies: 2
- Views: 2509
Re: Process Last Ran Date.
I do not believe that such a property exists. Neither a property to check if a process is connected to another process.
600 is a lot of processes. There have to be at least that are doing the same task.
600 is a lot of processes. There have to be at least that are doing the same task.
- Wed Jun 15, 2011 2:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Process create element and add Data
- Replies: 2
- Views: 2431
Re: TM1 Process create element and add Data
Firstly, I would suggest splitting up this into 2 processes. Although, you can add elements and then subsequently load data to it in the same process, I have found that it is best to split this task into 2. Do you have any alias on your elements? Or is this there any unique identifier that you can a...
- Wed May 25, 2011 5:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculating Avg Unit Margin @ Consolidated Levels
- Replies: 2
- Views: 2948
Re: Calculating Avg Unit Margin @ Consolidated Levels
In your tm1s.cfg file you have set:
AllowSeparateNandCRules=T
AllowSeparateNandCRules=T
- Tue May 24, 2011 4:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to create a view through TI process
- Replies: 3
- Views: 3877
Re: how to create a view through TI process
In TM1 WEB, you can hide dimensions to not display in the main screen, but they are still part of the view.
There is no similar functionality in Cube Viewer. All dimensions part of the cube are displayed.
There is no similar functionality in Cube Viewer. All dimensions part of the cube are displayed.
- Sat May 14, 2011 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM 1 Web error
- Replies: 2
- Views: 2317
Re: TM 1 Web error
Make sure cube name and view name are not the same.
Is this on contributor or tm1 web?
Is this on contributor or tm1 web?
- Thu May 12, 2011 12:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: someone help me to write feeder for this
- Replies: 5
- Views: 3930
Re: someone help me to write feeder for this
For a rule with addition / subtraction, best practice for a feeder would be to have a separate feeder where each element from the right side feeds the left side. The 1st one is straightforward: ['Budget'] => ['Target']. Since the next four are dependent on an attribute from the month dimension, ther...
- Wed May 11, 2011 2:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create attributes
- Replies: 5
- Views: 5400
Re: Create attributes
Use function ATTRINSERT to create a new attribute.
Use function ATTRPUTS or ATTRPUTN to populate the attribute.
Use function ATTRPUTS or ATTRPUTN to populate the attribute.
- Tue May 10, 2011 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to load file dynamically with dynamic column order
- Replies: 3
- Views: 2983
- Thu May 05, 2011 10:39 pm
- Forum: Useful code, tips and tricks
- Topic: Indirect variables in TI.
- Replies: 13
- Views: 39032
Re: Indirect variables in TI.
Your discovery gave me an idea. I always hate writing a long string of IF statements when I need to check something in variables in a sequence ( v1, v2, v3, v4, v5, v6, v7, and so on...). I used your idea to make it simpler. nNum = 1; While( nNum <= 7 ); sNum = NumberToString( nNum ); IF( EXPAND( '%...
- Wed May 04, 2011 6:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Contributor Errors
- Replies: 10
- Views: 8905
Re: Contributor Errors
You have setup security for that hierarchy and that node through contributor and assigned appropriate groups the proper security?
The user is assigned to the group where they are trying to take ownership?
Is the issue occurring for all users in that particular group?
The user is assigned to the group where they are trying to take ownership?
Is the issue occurring for all users in that particular group?
- Tue May 03, 2011 3:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Duplicate values on TM1
- Replies: 4
- Views: 3490
Re: Duplicate values on TM1
To copy data from 1 element to another, would you to create a view (either manually or using dynamic scripts) and then using that view as a datasource in a TI process. Then in the data tab, as the process goes through each record in the view, you can utilize the CellPutN function to place the data t...
- Tue May 03, 2011 1:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Duplicate values on TM1
- Replies: 4
- Views: 3490
Re: Duplicate values on TM1
You can add an additional member called forecast adjustment which would be open for manual input. Create a rule in the cube for the forecast element = budget + forecast adjustment. Or you can use a TI process to copy over the data from budget to forecast, but this would require the process to either...