TM1 Forum

Can we use app_maintenance utility in TM1 Linux environment also. Is this only for Windows Version ?

In TM1 10.2 is there any option to call TI Process/Chores from Autoys for Unix or Windows Environments.

Hi Jim, Thank you. We have Tm1 9.5.2 and Cognos 10 BI installed on the same server. Do you think still we need to add more RAM on this Server ? What We noticed is, previously when the Cube size 1.5 GB, the reports are fine. But once we loaded more months data, the cube size is increased to 3.5 GB(in...

Hi,

How much free memory is required for 5 GB TM1 cube size. The available free ram in our Server(where TM1 is isntalled) is 6 GB. Is this enough for benchmark performance of the Cube/Cognos Reports. How can we correctly size the hardware requirement of server (particular RAM) ? .

Hi, Rebuilding the Cognos Report after dimension re-order in TM1 cube is not feasible solution. We have around 20-30 reports. What are the best optimization steps for Cube. ? Can we follow optimization suggested by Cube Optimizer in TM1 Architect. ? Eventhough cube service size reduces by 25% after ...

Hi, We have created TM1 cube(TM1 9.5.2) with 16 dimensions and cube service size is around 5 GB. 20 BI Cognos reports(IBM Cognos 10) built on and each report is taking around 30 seconds. In order to improve the performance, we have done re-order of dimensions In TM1 and there is decrease in cube ser...

Hi all,

We know that By default, TM1 does not display the aliases.
Currently we are building 20 to 30 dimension which are having aliases. After creating the cube, we need to set the use aliases button in each dimension manually.

Is there any we can set use aliases on option for all dimensions.

Hi, We are gettting the below error on accessing TM1 Cube based Cognos Reports. TM1 Server is sarted and services are running. But once we execute the Cube based Cognos Reports, the service is stopping and Cognos reports are throwing below errror. XQE-EXE-0004 QFWBridge has returned an error: TM1-ER...

Hi, Enabling use dynamic query mode while publishing the package improved performance a lot. The report is execution brought down to 2 min from 7 min. There is no improvement after modify the below paramters in C10/configuration/qfs_config.xml file under the TM1OlapODPXQE provider. <parameter name=&...

Hi, Enviroment: IBM Cognos 10 TM1 9.5.2 We have developed few Reports in RS with data source as TM1 Cube. Cube is built of 9 dimensions and 5 facts. some of the dimension is having less elements <10. Each Report (excel as default format) is having 5 separate pages with respective dimension as key. A...

Hi,

Thanks for your reply. Its fine if we are applying few rules in TM1 and same can be applied in Report Studio to resolve this issue. Is there any alternative way we can resolve this, since we are going to apply rules on 10-20 facts which need to be used Report Studio.

Hi, We are using TM1 Cube as data source and developing reports in Cognos Report Studio. We have few facts in TM1 Cube which are based on rules. and requirement is that when user select multiple reporting dates , then these facts need to be rolled up and display accordingly. But when we roll-up, ins...

These views are created for users to browse the data. Is there any way we can restrict specific measures for each view.?

Hi, We are trying to create a View with specific Dimension elements and Facts. Fact Dimension is having 3 measures, but we want to create a view with one measure Sales. Below is the Prolog Statement to Create the View, The View is Created Successfullyl but its displaying all the measures. The functi...

Hi, We are trying to call set of TI Process through master TI Process by passing DataSource,userid and Password as parameters. with below prolog statment in master ti and calling the child TI Process. master TI Prolog statment: ========================= ExecuteProcess(processName,'PDataSource',DataS...

Hi, We are trying to execute TI Process with tm1runti command utiltity of 9.5.1 Hot Fix 14, with following respective parameters. its throwing below error SystemServerNotFound. Anyone having the idea about this. tm1runti -process PROC_CTV -adminhost mylab –server mytm1server –username ***** –pwd ***...

Hi, We are trying to execute TI process from anoother TI process with the below 3 parameters DataSourcename, Userid and Password for DB. I am trying to override the default values given in the first tab Tourbe Integrator(DataSource Tab, Data Source Name, UerName, PasssWord). When i provide different...

where can i set the local variables DatasourceUserName and DatasourcePassword dynamically for ODBC Datasource. These local variables are temporary and will be deleted after every process run (Local variables exist only in the context of the process in which they are used, and are not available outsi...

Hi, We have similar issue, need to migrate set of .pro files to qa/uat/prod. In TI Process , we are using ODBC Data source, providing usrid/pwd for dev enviornment. but when we migrate to different environment ,the usrid/pwd may be different, so everytime we need to modify this manually. Is there an...

Yes, I verified IIS is running and installed TM1Web also.

Regards
ub