TM1 Forum

Hello All I am in the process of updating TM1 10.1 to 10.2.2 fix pack 6. As a part of this exercise, I also need to enable the TLS protocol for end-to-end encryption of all server and client communications Not sure how to go about it.. Google search didn't reveal much Any pointers will be highly app...

Hello All, I tried searching for this error but could not find on Excel 2013 environment. When I launch perspective, I get the following error : "Compile error in hidden module : Main" Im using the current environment Windows 7 - 64 bit release V1.2 TM1 server - 64 bit Microsoft office 201...

Thanks Trevor

This helps. One more question : What does the "State" element of Node_Info dimension indicate... In my case it is "0" for one user and "2" for another

Will appreciate your help

Regards
GGB

Dear All Im trying to find out if any control cube exists that stores "TM1 Approval Hierarchy Application" node status. Any pointers will be helpful. I am also looking to create a report on the existing owner of the node, data change date. If the control cube is not available then can you ...

Thanks David

This helps!!

Regards
Gbehel

Hi Rodger I was trying to see if using TM1 as source to Dynamic cube, will we be able to use the virtual cube capability of Dynamic cube and thus handling large volume of data with ease TM1 is very well capable of handling large data volumes but the large data becomes difficult to handle in perspect...

Hello All,

One question : can we use TM1(one or multiple cubes) as source to Dynamic cube?

Any advise/document will be appreciated.

Regards
Gbehel

Thanks dkleist

This really helps

Regards
Gbehel

Hello All, My question is related to Cognos Planing contributor. A Contributor application is published on Cognos web. There are 2 set of contributors. Internal and external vendors. Internal vendors are part of the network and they can login as company employees, open contributor web and submit num...

Thanks Guys,

This helps

Hi All, if i want to become a product architect (of Tm1 and Cognos Planning), then What do i need to more. Im fairly experienced on Cognos EP and have a working experience on TM1 but Im no where closed to being called a product Architect Any advise on what should I know as a framework to be a produc...

Hello All, Was wondering which would be the best form of data source for faster data loadng to TM1 cube using TI process : Available Data Set : Table columns : Product, Channel, Region, Division, Jan01, Feb01, Mar01 till Dec15 Column Jan01 to Jan15 are data columns and may contain NULL or a default ...

1. did you run RefreshMdxHierarchy('') or RefreshMdxHierarchy('dimname')? You have to run the command per affected dimension. In theory, either syntax should work fine with the first one refreshing all dimensions. I personally have never used it like that, but it should work. I think Michel's sugge...

Hello all, Used the following sequence : 1- Published a TM1 cube to 10.2 BI. 2- On knowing that named levels were missing, I entered the values for named hierarchies in }hiererchyproperties control cube 3- Ran the RefreshMdxHierarchy(''); TI process. After these steps, I launched the BI Report studi...

Thanks Roger,

These are excellent suggestions. Shall try these alternatives

Regards
Gbehel

Thanks Rodger, Based on suggestions from Martin and Paulsimon (and as you said), i have already set the *_AVG_QTD/*_AVG_YTD as consolidations and data is loaded and working fine. However, I was curious to know on how the feeders would turn out to be in case a rule is written instead of consolidation...

Hello Martin and Paulsimon, The approach suggested by you worked and data is looking fine. Thanks for your help However, im still curious to know how will the feeder for below calculation look like ? ['JAN12_AVG_QTD' ] = N: (['DEC11_MTD']+['JAN12_MTD'])/2; ['FEB12_AVG_QTD' ] = N: (['DEC11_MTD']+['JA...

Thanks Martin,

Appreciate your help on this

Regards
Gbehel

thanks Paulsimon,

this is a great idea to avoid rule based cube and avoid writing feeders..

I really appreciate your help on this

Regards
Gbehel

Thanks Martin...

Im unable to open the link viewtopic.php?f=3&t=9931

can you post it again

Regards
Gbehel