Search found 2750 matches

by tomok
Mon Oct 12, 2020 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: file object is Not Found
Replies: 2
Views: 368

Re: file object is Not Found

bunchukokoy wrote:
Mon Oct 12, 2020 3:43 pm
We generate zip files in this directory --> C:\Program Files\ibm\cognos\tm1_64\webapps\Sales\Reports (alpha is name of the server)
Do the users have READ access to this directory on the new server? If not, the links will tell you that the file does not exist.
by tomok
Mon Oct 05, 2020 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for elements that exist in both subsets
Replies: 4
Views: 147

Re: MDX for elements that exist in both subsets

MarenC wrote:
Mon Oct 05, 2020 1:01 pm
Hi Tomok,

you had one too many parenthesis in that but otherwise worked perfectly, thanks!

Maren
I accept no responsibility for syntax errors. :)
by tomok
Mon Oct 05, 2020 12:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for elements that exist in both subsets
Replies: 4
Views: 147

Re: MDX for elements that exist in both subsets

Hi, I have 2 mdx based subsets, one to find a variance between the current and next period and another which asks if an employee has an end date. I now want to combine the 2 to see where the variance is possibly due to an end date. I can combine the mdx statements into one with an and condition, wh...
by tomok
Fri Oct 02, 2020 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Batch file with gpg4win is not executing from TI process
Replies: 6
Views: 241

Re: Batch file with gpg4win is not executing from TI process

Can you assist me what or where i should start looking for permission? How about all the folders where the programs called from your batch file are stored. Does the TM1 service account have access to these? What about any files that are written. Does the service account have permissions to create f...
by tomok
Thu Oct 01, 2020 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Batch file with gpg4win is not executing from TI process
Replies: 6
Views: 241

Re: Batch file with gpg4win is not executing from TI process

When batch files run when you initiate them and they don't run under TM1 it is due to permission issues about 99% of the time.
by tomok
Tue Sep 29, 2020 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance impact of many timestamped transaction logs
Replies: 1
Views: 105

Re: Performance impact of many timestamped transaction logs

Hello all, In our environment we have a daily SaveDataAll chore running during off-hours. As a consequence, we have accumulated many timestamped tm1s*.log file as we don't presently archive these. I recall from a prior thread there IS a performance hit with keeping the timestamp'd transaction logs ...
by tomok
Wed Sep 16, 2020 4:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing data from one cell to another
Replies: 2
Views: 140

Re: Passing data from one cell to another

This forum is not a substitute for taking a training class or reading the manuals. This is a very basic question that cannot be answered in a simple forum post. It requires a lot of background which you will find either in a training class or in the manuals.
by tomok
Tue Sep 15, 2020 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Persistent Feeders
Replies: 1
Views: 114

Re: Understanding Persistent Feeders

If you have conditional feeders, meaning an IF statement in there somewhere, then persistent feeders may not work properly for you without a rule save (to make the feeders recalculate).
by tomok
Mon Sep 14, 2020 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a subset with a while loop
Replies: 2
Views: 157

Re: Creating a subset with a while loop

Hey guys, I have created filtered subsets using the code below (i am new to tm1 so it may be somehwat sloppy) I was wondering if there is a way i could do this using a while loop? IF(vCatDir @= 'Filter by Category' % Scan ('*',vCatDIR) =1); ITEMSKIP; ENDIF; sSub ='zzzCD-CAT'| vCatDIR; #=====Create ...
by tomok
Thu Sep 10, 2020 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 930

Re: Active form hell

Input on March, Y2 and March Y1 is visible. Who invented this ? I should now expect phone calls by customers I guess, since I never paid attention to that "design decision". AFAIK, it has always worked this way. This is actually one of the drawbacks of using separate year and month dimensions in TM...
by tomok
Thu Sep 03, 2020 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 930

Re: Active form hell

The issue you are having is due to the fact columns are not dynamic in an active form. If you had just the one time dimension then the form would work but since you have it split into two it doesn't. I don't know of any way to make it zero suppress in this scenario except to do a "pseudo suppression...
by tomok
Fri Aug 28, 2020 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero Suppression - very small #'s
Replies: 3
Views: 188

Re: Zero Suppression - very small #'s

TM1 stores values in double precision, not decimal. This has been around since the tool was first developed and it can causes issues with zero suppression when you have a scenario like yours. The only way I know to fix it is to assign a ROUNDP rule to the consolidated elements. Doing a ROUNDP throug...
by tomok
Wed Aug 19, 2020 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC connection to EXCEL
Replies: 4
Views: 449

Re: ODBC connection to EXCEL

roei61 wrote:
Wed Aug 19, 2020 4:27 pm
Hi,

My Excel in the server is 32Bit and I cannot change the installation.

I don't think I'll be able to install 62bit ODBC driver if my Excel is 32
Then you won't be able to do what you asked about.
by tomok
Fri Aug 14, 2020 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC connection to EXCEL
Replies: 4
Views: 449

Re: ODBC connection to EXCEL

Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?
by tomok
Wed Aug 12, 2020 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 7
Views: 358

Re: LOGGING for }StatsBy Control Cubes

I can't think of any reason why you would want to log the activity in the {StatsXXX cubes because they are already set up to capture history. As to the other control cubes it depends on what type of activity you want to be able to track. I generally have logging set to YES for control cubes.
by tomok
Tue Aug 11, 2020 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 7
Views: 358

Re: LOGGING for }StatsBy Control Cubes

Unless IBM has changed something recently then blank means YES for logging purposes.
by tomok
Fri Jul 17, 2020 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 821

Re: Assessing instance/Cube Efficiency

By doing a count of 1 on each pass I estimated that adding up all the measures there are about 45 million populated cells. Though it says the number of Stored calculated cells is 4.5 million and the number of populated numeric cells is 3 million. So I don't know why when I run the TI it counts 45 m...
by tomok
Thu Jul 16, 2020 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assessing instance/Cube Efficiency
Replies: 7
Views: 821

Re: Assessing instance/Cube Efficiency

So I created a view at leaf level and I am doing a cellput to a cube which includes the measure dimension to count the number of cells by measure. So the data tab is simply x=x+1; Cellput(x, 'CountCube', vMeasures, 'Count'); The process is really 'sticky' and at this rate might take all day. Sounds...
by tomok
Tue Jul 14, 2020 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube data into SQL table columns
Replies: 7
Views: 747

Re: Cube data into SQL table columns

The view used as the data source in your TI process needs to be configured to only have the C level measure in it. No need to have all the individual measures in it since you are going to retrieve them with the CELLGET.
by tomok
Tue Jul 14, 2020 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube data into SQL table columns
Replies: 7
Views: 747

Re: Cube data into SQL table columns

If you don't want to change anything in TM1 you can also modify your SQL to accomplish the same thing. In your SQL you have an IF EXISTS that searches for the existence of the record and, if it does not exist, adds it with no values for the measures. Then below that you do an UPDATE that updates the...