Search found 129 matches

by ajain86
Wed Oct 05, 2011 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: cube disappeared
Replies: 2
Views: 693

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 manually do a cu...
by ajain86
Thu Sep 08, 2011 2:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mass commit of users' sandboxes
Replies: 2
Views: 694

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...
by ajain86
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: 1977

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' ...
by ajain86
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: 23105

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.
by ajain86
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: 1890

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.
by ajain86
Fri Jul 29, 2011 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel Interaction
Replies: 7
Views: 1426

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.
by ajain86
Thu Jul 28, 2011 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel Interaction
Replies: 7
Views: 1426

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.
by ajain86
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: 1742

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.
by ajain86
Wed Jun 15, 2011 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Last Ran Date.
Replies: 2
Views: 522

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.
by ajain86
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: 791

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...
by ajain86
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: 1080

Re: Calculating Avg Unit Margin @ Consolidated Levels

In your tm1s.cfg file you have set:

AllowSeparateNandCRules=T
by ajain86
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: 1436

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.
by ajain86
Sat May 14, 2011 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM 1 Web error
Replies: 2
Views: 681

Re: TM 1 Web error

Make sure cube name and view name are not the same.

Is this on contributor or tm1 web?
by ajain86
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: 1375

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...
by ajain86
Wed May 11, 2011 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create attributes
Replies: 5
Views: 2229

Re: Create attributes

Use function ATTRINSERT to create a new attribute.

Use function ATTRPUTS or ATTRPUTN to populate the attribute.
by ajain86
Thu May 05, 2011 10:39 pm
Forum: Useful code, tips and tricks
Topic: Indirect variables in TI.
Replies: 12
Views: 8983

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( '%...
by ajain86
Wed May 04, 2011 6:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contributor Errors
Replies: 10
Views: 3606

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?
by ajain86
Tue May 03, 2011 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Duplicate values on TM1
Replies: 4
Views: 960

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...
by ajain86
Tue May 03, 2011 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Duplicate values on TM1
Replies: 4
Views: 960

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...