TM1 Forum

No, I haven't changed any thing. Until Friday evening it was working fine. But from the Monday morning it was not working. I have 5 TM1 modules. only one module which was meant to work on web(templates associated with this module used to work on both clients until Friday evening, but today the templ...

All of sudden users are unable to access the cube data via perspectives, but able to access the same via web. Only admin id is able to access the data via perspectives, rest of the users are not able to access the cube data via excel templates. - Old excel templates are not working in excel but work...

I am sorry, there was a typo. We have Cognos BI 8 and we are migrating to 10.

However, apart from TM1 web, is there any dedicated dashboard tool for Cognos Express?

Dear All, Our company wants to go for dashboards for various mangers. I am not sure which tool to pick from IBM and which tool is apt for our current setup. We have Cognos Express 10.1 installed in our company with 50 users. With in the Cognos Express, we are using Manager, Xcelerator & Web. And...

upali wrote:Use triple quotes

Code: Select all

Query = Expand('Insert INTO Table1(SNO,ENAME,State) VALUES(%vSN% | ',' '''|vEN |''' ',' '''| vSt |''' ')');

oops.... not working.

I am unable to execute SQL Query using TI process. I would like to insert a row in simple table. Database: MS SQL Server (Quoted_Identifier is set OFF in MS SQL Server, in order to entertain double quotes) Table Details: Name: Table1 Element1: SNO (Int) Element2: ENAME (VChar(10)) Element3: State (v...

From the last week onwards, most of the users are experiencing error - 'Can't execute in break mode', while opening any of the existing excel template in TM1. -Those templates are not having any VBA code or macros. How to overcome this error. I have been thru Excel forums regarding this issue, what ...

I have two cubes with different cardinality/granularity. 1) OH_Budget Load OH_Version OH_Company OH_Business Unit OH_Category OH_Currency OH_Period OH_TB Measure 2) OH_Trial Balance OH_Version OH_Company OH_Business Unit OH_Category OH_Nature OH_Account OH_Currency OH_Period OH_TB Measure Note: OH_N...

Is there any way to check how long (let say hours or days) a particular active user is using TM1?

Thanks in advance.

Maybe my wording wasn't clear and properly too short. But, and unless I misunderstood what is needed, Cell Security is what I think is the easier approach in this case and it (or how to set up Cell Security) is documented in the standard documentation. I have created cell security cube for the requ...

Dear All, #1 In our organisation, currently we are locking the data by using one element (especially period dimension's element). If composite Element locking facility is possible/available in TM1, I appreciate if some one could help me. Let say if there are 3 versions for a given period (eg: Actual...

When I create view(suppress zero is enabled) in Cube2 to see the derived values, I was unable to see any values. But when I use DBRW function to retrieve the values from Cube2, I could see the values. Did you forget to write feeder statements for your rules? Sounds like a classic feeder issue. Eith...

I have a lookup cube (let Say Cube2) where calculating mix by looking up values from Cube 1. Cube2 is empty and it has values derived from some calculation based on the values from cube1. When I create view(suppress zero is enabled) in Cube2 to see the derived values, I was unable to see any values....

I am obliged if any one could guide me the steps in using a PL/SQL in TI process, if possible.

Thanks in advance.

I am installing Cognos Express 9.5 30 days trail version on the windows 7 with the following specs Operating system: Windows 7 Home Premium 64 bit .Net framework 4 client profile and extended Java 6 (64 bit) IE 9 Manager got installed without any problems. When I am trying to install Xcelerator, I a...

As we have ViewZeroOut() function to zero the numeric values in a cube, Is there any specific function to clear the string values in a cube?

Thanks in advance.

In our organisation DWH, Cognos BI and TM1 are not integrated, they are running on three different server systems. .csv file generated by TM1 process should be sent to the DWH system for further process. Since TM1 cannot place the files in network drives which are not part of the TM1 Content Server...

John Hammond wrote:tm1 service needs to run under windows id with rights to do the copy

DWTEST123 is windows id in which I am executing the command. I am obliged if could provide me the specific tm1 service.

In our organisation DWH, Cognos BI and TM1 are not integrated, they are running on three different server systems. .csv file generated by TM1 process should be sent to the DWH system for further process. Since TM1 cannot place the files in network drives which are not part of the TM1 Content Server,...

Is there any way or functions available for error handling in TM1's TI process?

If errcode = 3604 then
...
else
.....
endif;

Thanks in advance.