Search found 2825 matches
- 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: 997
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 ...
- 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: 1156
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.
- Tue Sep 15, 2020 7:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Understanding Persistent Feeders
- Replies: 1
- Views: 928
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).
- 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: 6336
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 ...
- Thu Sep 10, 2020 5:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 9532
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 dimens...
- Thu Sep 03, 2020 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active form hell
- Replies: 29
- Views: 9532
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 suppre...
- Fri Aug 28, 2020 2:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Zero Suppression - very small #'s
- Replies: 3
- Views: 1579
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...
- Wed Aug 19, 2020 6:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC connection to EXCEL
- Replies: 4
- Views: 2436
- Fri Aug 14, 2020 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC connection to EXCEL
- Replies: 4
- Views: 2436
Re: ODBC connection to EXCEL
Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?
- Wed Aug 12, 2020 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: LOGGING for }StatsBy Control Cubes
- Replies: 7
- Views: 2440
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.
- Tue Aug 11, 2020 9:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: LOGGING for }StatsBy Control Cubes
- Replies: 7
- Views: 2440
Re: LOGGING for }StatsBy Control Cubes
Unless IBM has changed something recently then blank means YES for logging purposes.
- Fri Jul 17, 2020 11:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Assessing instance/Cube Efficiency
- Replies: 7
- Views: 2930
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...
- Thu Jul 16, 2020 12:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Assessing instance/Cube Efficiency
- Replies: 7
- Views: 2930
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...
- 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: 5303
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.
- 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: 5303
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...
- Thu Jul 02, 2020 1:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query Length Limit for TI
- Replies: 10
- Views: 4721
Re: SQL Query Length Limit for TI
why you dont create a SQL View and just import the View? Better yet, use a stored procedure. Each individual INSERT INTO statement is going to have to be compiled before execution. Depending on how often you call the query this can really add up. Stored procedures don't have to be compiled each tim...
- Mon Jun 29, 2020 8:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: LogOutput fails where AsciiOutput runs fine
- Replies: 3
- Views: 1979
Re: LogOutput fails where AsciiOutput runs fine
Have you ever done this before, meaning have a logging directory housed on a different server? Or is it just not working this time?
- Wed Jun 24, 2020 12:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The code hide row through conditional formatting in the Websheet.
- Replies: 2
- Views: 1705
Re: The code implementations hide rows through conditional formatting in the Websheet.
An interesting idea. I just wish your examples were not in Chinese.
- Thu Jun 18, 2020 12:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing Quick view depending on cell drop down
- Replies: 24
- Views: 8096
Re: Changing Quick view depending on cell drop down
No, but the elements are not changing dynamically when i select the dimension, i tried it That's probably because your TM1RPTROW formula in cell B17 is not set up properly to pull back all the elements in the dimension. I suggest making it MDX-based and have the MDX statement based on the dimension...
- Thu Jun 18, 2020 10:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Changing Quick view depending on cell drop down
- Replies: 24
- Views: 8096
Re: Changing Quick view depending on cell drop down
=DBRW($A$1,$A4,B$3) Everything is working fine, when i am changing the dimension it is fetching all the corresponding attributes from that dimension But .... the elements are constant it is not changing, is there any function like DIMNM() to fetch elements from that dimension ? Maybe because this a...