TM1 Forum

Hi All, I figured out which CSS file to modify, and after modifying it is working fine. Down arrow in snapshot is representing 'dim_subset_default1.gif' image file, which is located at ..\webapps\tm1web\images\websheet. I am not sure, if it is same in everyone's system. standaloner.css file in ..\we...

Hi All, Letters with descenders are g j p q y are not shown completely in TM1 Web. Tried changing fonts, resizing excel cell, but no luck. This is happening for elements which are coming from SUBNM function in TM1 Web. Below is snapshot for reference, g is not shown completely. Chopped-Off Char Modi...

Hi BucJeff,

Did you installed any separate connectors, to create ODBC connection for SAP HANA?
If you can help me in understanding how you created ODBC to connect with HANA directly.

For SQL Server ODBC works fine, but when it comes to HANA, it may not be straight forward.

Regards,
Deepak Jain

Hi Lickkky,

It can be handled in multiple ways.
If you give insight on what exactly is happening in current solution, we can share some information.

For example, when you are referring to page, is it TM1 Web? If it is TM1 Web Page, Does user click on any button to save changes?

Regards,
Deepak Jain

Hi All,

We need to access SAP HANA Views or tables in Cognos TM1.
Can someone help me in getting information on what is the best way to connect to SAP HANA from TM1.

Regards,
Deepak Jain

What Ardian said should work for sure.

Hi Dude,

It's about dimension 1 and dimension 2 having similar elements, dimension 2 should be dependent on dimension 1 is what I understood from details. Hope I got it correctly.

I would have tried with MDX statement which can be part of TM1RPTROW.

Regards,
Deepak Jain

Hi Mincharug, Alan suggestions are helpful. I would have given a try with below approach. If you have same file format, and all of those are placed in same folder, below are things I would have tried Assuming a situation with csv file format 1. Create a csv file which will have a file names which yo...

Thanks Kamil for sharing info

Thanks Tomok

Hi Ian,

You can check TM1S.CFG file, and see if Persistent Feeders is turned on?
If it is so, please stop service, then turn off and start your instance, it could give you some info.

Regards,
Deepak Singhvi

HI BariAbdul,

Thanks for sending ref link.
I went through that post, and yes we can do things in BI and then burst it, as mentioned in my post.
I was looking to understand that, is there any way to automatically get snapshot of an application i.e. accessed via TM1 Web.

Regards,
Deepak Singhvi

Hi Kamil,

Approach which I discussed among our team is to get list of users in csv file i.e. (CAM ID and Username), and then load them into "}Clients" dimension using TI process.
If you have any alternate ideas, please share.

Regards,
Deepak Jain

Hi All, We have an application in TM1 Web, which contains data in list format, bar graph etc. (Single Report) Users manually go and export in excel as snapshot. We are looking to automate that scenario. Approach we are trying is to build same reports in BI and burst them and send using scheduler. I ...

Hi Kamil,

Product version is 10.2.20300.86 (assuming 10.2.2 FP3).

Regards,
Deepak Jain

Hey friend, It never crashed for us in test environment when either one or two users login and that too at different time. It will crash when many users hit the server at same time. Further observation: To be more specific, 20 records of debug are generated in server log for one user login. It happe...

Hi All,

Those records of debug are generated when any user connects for first time, not sure is it because of integrated security mode: 5.
Anyways will connect with IBM folks and check on it.

Regards,
Deepak Jain

Hi All, We have setup IntegratedSecurityMode = 5, but when we connect Tm1server.log captures below details. If many users hit TM1 Server, it crashes. 2480 [4] DEBUG 2016-03-09 16:39:26.621 TM1.APIDetail.Return.Index RetIndex: index = 6 2480 [4] DEBUG 2016-03-09 16:39:26.621 TM1.APIDetail.Return.Inde...

Hi All, Why control cubes can't be driven by rules? For e.g. }CubeSecurity. Ref link below says under topic "Maintaining security metadata in TM1 security objects" that those should be process by TI process, instead of rules. http://www.ibm.com/developerworks/library/ba-pp-security-fpm-pag...

Hi Suman, One more thing, you can check is, in logs file, how much time is consumed for feeder computation. You can check in stats cube, to get details of how many cells are fed for that respective. You can enable Persistent Feeders, in case you don't want server to recalc feeders (But it has it's o...