TM1 Forum

Dear all, I created a TM1 report using perspectives, the following steps were followed, 1. Connected to the TM1 server in Perspectives 2. Used In-Spreadsheet Browser(ISB) to create a view of the cube and used 'slice' option. 3. Then saved the slice as an excel using 'Print Report' option in perspect...

Hi all, I want to publish the data from a cube to Orcale database and i am using Planning Sample model given by IBM. I am using TI process to accomplish it. The problem i face here is, the data is not getting published in the tables. Below are the steps i follow, 1. DataSource as TM1 Cube View 2. De...

Hi Mvaspal, A week back i was able to access TM1 Web without any issue. This happened over the weekend. Also the User has Read and Execute access for ASP.NET. If only the access to that particular issues is the matter of concern , then i can connect with the support team to get in done. I want to kn...

Hi all,

I am getting the following error when i try to access TM1 Web URL even though the access to the machine.config file is there for the user. Moreover i am logging using the Administrator's credentials .

Thanks in advance.

Hi, If you can create two more elements in the Person Dimension like Total_Number_Employee_Count(Already exists i guess) and Total_Number_Employee_Hold and in Rules ['Total_Number_Employee_Hold'] = N: ['Total_Number_Emploee']; ['Total_Number_Employee_Count'] = N: IF(['Total_Number_Employee'] <>0,1,0...

When i set CalculationThresholdForStorage = 1 in tm1s.cfg, the same values are used for calculation of both the components(Proft & overhead) but the random values are not generated everytime the cube is recalculated. It may be beacuse it keeps the same value till the data cache is cleared(happen...

OS : Microsoft Windows Server 2003 Enterprise x64 Edition Service Pack 2

Thanks guys. I will go ahead with the installation after installing both x86 and x64 version of Visual C++ package.

@George Regateiro Can you share the checklist for the setup that you have tested with. That would be of huge help to find any error in our step in case.

Hi, I am facing an issue in installing TM1 10.1.0 . As per the TM1 installation guide, one of the pre-requisite for 10.1.0 is given as 'Microsoft Visual C++ 2005 SP1-Redistributable Package'. Though i have installed all other pre-requisite components including 'Microsoft Visual C++ 2005 SP1-Redistri...

If i have to do this using TI should i go for populating the cube with the help of scripts and then make use of the data ? but i have a concern in doing so, i want the different set of random values to get generated whenever the cube is recalculated. If i do it by TI, i would have to run the process...

I thank you all for providing me more insight into TM1. Actually i have 1000 elements in the Cases dimension. My expectation was to create to get 1000 random values(one for each element) and use in a particular Monte Carlo simulation. http://www.vertex42.com/ExcelArticles/mc/SalesForecast.html With ...

Here are the Screenshots , you can see i have assigned the element 'RandV' Random function and the other elements say is the product of 'RandV' and 1 Eventhough i am multiplying by 1 , all the values are not same. This is where i face the issue. I hope the issue is defined clearly. Thanks in advance.

Hi all, I want to perform a calcualtion based on the Random numbers generated using Rand function.. The following is the requirement, I have a Cube which contains 2 dimensions, (i) Cases - contains 100 elements case1...case100 (ii) Values - contains Random Values, B,C,D & E as its elements The R...

The change in the Clients/Groups security made the picklist available for the users. Unless i give the users the Admin rights in the Clients/Groups security for the application, i am not able to access the Picklist using any of the clients login.

When the users are provided with the Admin rights to the elements they are able to view the picklist. Also i have tried assigning the picklist for another element in the same dimension, say i have tried it on 'remarks ' element. I mentioned in one of my comments that the same issue i am facing in ot...

I have checked that as well.. The group to which user belongs to has "Write" access to PickList and Format items of the "}ElementAttributes_1 CLP Requirement cube.

I am stuck in the same issue and its really frustrating.

I have tried all the three types of Picklist. irrespective of the type of picklists, the result is same.
Even i have tried defining the picklist in the Picklist_cube. Kindly find the attached image file whre i have defined the Picklist.

For all the clients I have given read access to those dimensions which i have defined as picklists. But it s still not going the right way

Any help or suggestions on this issue ???

Whatever i type its accepting, even though the elements for which Picklist are defined as String elements. Its even taking the numeric values.