TM1 Forum

Please see this:

http://pic.dhe.ibm.com/infocenter/ctm1/ ... stool.html

I hope this is what you were looking for.

Next to this we have also set up the VMM and VMT settings in the }CubeProperties to allocate 10 MB memory for views to each cube and set the timing threshold to 2 seconds. Just to be sure, we interpret this as "when a view takes longer than 2 seconds to load it will be stored in memory for nex...

@abcuser Apart from several inputs that others have chimed in, I am going to suggest an alternative. Hopefully it works out for you. Foremost of all, you can display text in a crosstab! Yes, it is possible. Several years back I had done it. Refer to this IBM KB in achieving it - http://www-01.ibm.co...

.... Viewsubsetassign(Vtgtcube,Vtgt,'Hierarchy', 'Transformer2'); ######Transformer 2 has consolidated element 'NJ Metro' .... Data: IF(CELLISUPDATEABLE (Vtgtcube,'NJ Metro', V2,V3,V4)=1); CellPutProportionalSpread(NValue,Vtgtcube,'NJ Metro',V2, V3,V4); ENDIF; You mentioned that "NJ Metro"...

In my opinion, the highest level need to shows only the values that nodes are green. Actually, in an Approval application, the approved node(parent node) should shows only the data who has reviewed, shouldn't? From the situations I have seen so far, it is helpful to have the data at root node irres...

As far as I am aware, this is the way to go about it. You may already be aware, however see this link for IBM tech note on EP contributor node states: http://www-01.ibm.com/support/docview.wss?uid=swg21360941 0 = Not Started, 1 = Incomplete, 2 = Work in Progress, 3 = Ready, 4 = Locked Last I checked...

Which studio are you seeing this behavior?

One thing that jumps out is, whether there is any security on the Accounts dim. It could be the reason.

Here's the sequence of events: * Export process runs for 62s (during this entire time, it is writing to a file using AsciiOutput) * SaveDataAll kicks off, runs for 0.14s and finishes it * Export process continues to run for an additional 125s and finishes its job Save Data locks the service Are you ...

All the entries in Access Manager will appear in Cognos Connection. In past, I had written SDK code to extract all the users, groups out .csv files and then import them using TI.

I am sure it is puzzling to everyone, since there are lot of views with no replies.

Anyway, we altered the chore schedules and now SaveDataAll does not interfere with the export process. Table is getting populated with desired number of rows now!

We have a situation repeating for last few days, where in a TI process that exports data from a cube into SQL table, is unable to load any rows - when executed as a chore. However, when run independently it is able to load the table with desired number of rows! Looking at the log files, something th...

This thread has given insight into the working of Aliases, which I was not aware of! Thanks all.

Thank you Gabor for your reply. Since I haven't heard from others, I believe working with either of the approaches should be just fine. I tested your scenario. It looks like I get blank with either of those approaches i.e. Created an alias attribute on a dim, but did not populate it. Using AttrS or ...

In an application that I am inheriting, I see in almost every TI use of CellGetS ('}ElementAttributes_Dim_Name', element1, element2) While we have always been using AttrS ('Dim_Name', element1, element2) ... where element2 is the attribute name we are interested in. The processes in question are use...

The way I had done in past, was to extract all the users and the groups to their respective .csv files using Cognos SDK. Then import them into TM1 using TI and map clients to groups.

em_past wrote:Hi all,

Do You know if there is a some way to publish a package in FM from .NET or Java?

HTH - http://www-01.ibm.com/support/docview.w ... wg21335762

Checked with IBM - per development team it is the design intent for these objects: }Chores , }Cubes , }Dimensions , }Processes , }TimeIntervals I'm using 9.5 and have *almost* the same issue with them. The service doesn't pick the subsets up on a restart, but the .sub objects are still showing in th...

Gabor wrote:I used to have several subsets on the }groups dim (static), I still have no issues with them under 10.1.1 FP1. I cannot remember any issue with it in the past.

We have subsets on }Groups as well as }Clients. We have no issues with them. It is for }Cubes and }Dimensions, that we see the problem.

Dear all ... thank you for suggesting alternatives. Given what we are seeing, I will now have to add some extra steps (replicate these dims or create subsets during server startup) to get our security processes working.

Thank you.

Does TM1 allow named subsets on control dimensions }Cubes and }Dimensions? We are on 10.1.1 and using Architect. I created a named subset on each of }Cubes and }Dimensions. Subset.png But these named subsets go away when TM1 service is restarted, which we do every morning. To me it almost looks like...