TM1 Forum

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

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.

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

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

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

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

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

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.

Do you have the 64-bit ODBC driver for Excel installed on the TM1 server?

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.

Unless IBM has changed something recently then blank means YES for logging purposes.

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

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

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.

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

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

Have you ever done this before, meaning have a logging directory housed on a different server? Or is it just not working this time?

An interesting idea. I just wish your examples were not in Chinese.

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

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