TM1 Forum

Thanks Jim but I wanna know if you need to do SecurityRefresh or Cellput on security cube would take care by itself, because I see my security is updated even if I dont do security refresh when I am using cellput on security cube.

Hi, As I have read on other link of forums that if you have Cellputs on security cube you need to do a security refresh whereas if u use Element SecurityPut u dont need to. I am updating diemsnion security with Cellputs and even if I dont run Securityrefresh I see the access granted to the users. I ...

Hi,
I am using TM1 9.5.2 with Excel 2003.
It is simple active form report where I am using a MDX (DRILLDOWNMEMBER) for my row.
My export works fine consolidated node. But as soon as I drill to lowest level I am not able to export. It throws Operation failed error.

Thanks,
Abhishek

Hi, Its getting very tricky with Websheets. When I try to export the websheets with a Consolidated element in my row it works perfectly fine. But when I expand the consolidated elements and try running export to excel it gives "Operation failed " error. I have a active form in my report. I...

tomok is write...you need to have atleast one dimension element of remaining dimensions.
If we have this sort of issue we generally have some element added into dimension which will have no meaning in dimension and then create a view by having that element in the SUbset for that dimension.....

Thanks Tom....
But can you guide little on how do we create a filter based out of Validity Cube.
Are you intending to say using rule.
Or via Security.
If we are doing it wid Rule will not there be performance issue...
Pls guide....

Thanks Steve But one thing is if I go with three independent dimensions and all three dimensions are inter dependent which means security will be a problem. Cell level Security is not the option as it will have huge impact on Performance. Business needs flexibility for entering the data and they sho...

Hi, I have a TM1 system which now imports the data from ERP. Some of the key dimensions get updated as it gets updated in ERP. Now one of my key dimensions is splilt into 3 parts in the ERP. For E.g: Old ERP Dim1=123456789 New ERP Dim1=123 Dim2=456 DIm3=789. What should be best design approach in my...

Hi Everyone,

Has anybody drilled through to Oracle Web Reports from Tm1 Cube.
Kindly advice some tips of how do we achieve linking from TM1 cube to Oracle Web Reports.

Thanks,
Abhi

Hi All, Can u plz share ur experience of Numbers of Users that a TM1 Server can Support so that I can have idea about what is the maximum limit for the users. What I want to exactly know is whether there is some example where number of Users using TM1 exceeds 5000. And what are the things we need to...

Thanks a Lot Alan Can u clear some of my doubts: 1)Are there any limits on how much I write a Rule?? I have idea it effects performance but if We use feeders for the rules that would not be problem. And what I have read is there can be Feeder for every rule. What do u mean by how many feeders those ...

Hi All,

I t would be of great help if you all can guide me to the best practices to take care while designing the TM1 Model.
Also what are the performance constraints if you can tell.
If there is such document please upload.

Thanks in advance,
Abhishek

Even I am not able to open the Contributor with following error on my Local machine
I am able to open it from server.

Hi, I am not able to open the TM1 contributor on my Local Machine. It says Cannot connect to remote server even I have all my servers working and Contributor working fine on the server. I have opened all the ports required and even then I get this error. Is there anything i m missing. Can somebody p...

Hi All,
Can anyone explain how can we implement the trigeer based exceution of TI process.
If there is any documnet or use case plz share it.
Any help would be very useful.

Thanks,
Abhishek

Dear Folks, I have Cognos 8.4 and TM1 9.5 installed on the same 32 bit server. I have configured ADS for authentication in Cognos 8.4. When I have completed all the steps for Integrating Security of 9.5 TM1 with Cognos 8.4 and added the user login from ADS in Clients/Groups of my TM1 server.It is im...

Hi All, Can anybody help me with the integration Cognos TM1 with Cognos 8.4 BI. I have read the document provided by IBM but when I say Edit in New Portal it doesnot show the Servers which are currently running. Hence not able to connect to TM1 servers using Cognos Portal. Any help will be greatly a...

Hi All,
I am using TM1 Contributor and when my user submits his node in which cube does this data flows.
i.e I want to know the submit information of the users is maintained in which of the control cube???
Any help will be highly appreciated!!!


Thanks,
Abhishek

hi jim,
can u guide how can we use sql to montior the TI process
Any help would be useful.

Thanks,
Abhishek

Hello Experts,
Can anycody tell me how recent can be the data in the TM1.
I mean to say can i schedule the chores to run in 1 min or will it impact my performance of Server.

Thanks,
Abhishek