TM1 Forum

We made a huge mistake and upgraded to FP6 and now we are dealing with this bug. The server crashed 3 times this afternoon and after troubleshooting i found out it was relating to a TI Process that users an "empty" view as datasource for which the Skip COnsolidation option was disabled. No...

This has been always an issue, even within a TI Process, there was no function to check if an element exists in a given subset, until the last Fix Pack ( 10.2.2 FP6 ), now there a new function to check for that

How many dimensions do you have in your Cube?

Hi , Can anyone guide me I am stuck with classic editor in TM1 10.2.2. IBM told me that it is no more valid and I have to struggle with basic editor only :-(. Since it does not support 64 bit architect. How one anyone work in basic editor and that too in latest version??? :shock: It can be enabled ...

If you are using websheets you can apply Excel data Validation, which will work on TM1Web also.

For String Measures, you can use PickLists

That would perhaps explain why you are seeing it in the FP4 whereas I haven't seen it more recently - possibly a different cause. I always make sure to not have any element wrapping occuring as I always use freezepanes on any sheet where scrolling could occur; and freezepanes plus wrapping causes t...

I was doing some more testing and I it looks like the issue happens when one of the columns in the active form is wrapped and the text breaks in multiple rows. So the height growth of the “Websheet” does not accommodate the “line break” for the wrapped cells. If none of my cells is wrapped, then I c...

I've no hit this issue, but I would never put a button of an active form, especially if your looking at a dimension with a large amount of members. Thank you Jim but it also truncates the content of Active Forms itself. The row in the Bottom of Active Form is a requirement to show the Totals, and b...

Hi, I am having an issue with TM1Web, so I have a websheet that contains an active form and at the bottom of Active Form I have a few Static rows ( to show some Totals ) The problem is that when the Active Form exceeds a certain number of rows, eventhough the vertical scroll bar shows, TM1Web does n...

gtonkin wrote:Check out Garry's suggestion it takes no time at all to retrain your fingers and seems to work consistently! Thanks for reviving that one Garry (double-thumbs up)

Holy moly

Hi, I hope someone knows how to avoid this issue, it's just annoying and I hope IBM will do something about this one day:) Copying code from TI editor or Rules Editor ( Control+C ) to clipboard has this issue ( I always had this issue since version 9.4 at least ). The issue is that instead of storin...

Hi, Is there anyway in which we can put a different border for every 7th row and a different border for the first 6 rows? Every 7 rows have the same rptrow value! I've tried to use the conditional formatting in the format section but that doesnt seem to work. May be because i have another condition...

In TM1 I would write a Rule to do that. So in your Measures dimension assuming you have 3 ELements: Daily Amount, MTD Amount and YTD Amount In your Data DImension, you need to have 2 Attributed: Prior Date and Next date Then in Order to Calculate the MTD Amount you need to write a Rule like below: [...

AssignClientToGroup works only on Data Tab or Epilog Tab

You can't assign users to groups in TM1 if you're using IntegratedSecurityLogin = 5. That is not a correct statement. In security mode 5 it is possible to mix CAM and native TM1 groups. You might not be able to make assignments via the Server Explorer security grid GUI (which is rather useless anyw...

You should use the Excel HYPERLINK function in order to activate the Links

Also look into TM1Web URL API if you want your hyperlinks to open TM1Web Websheets or CubeViews

If I understant it correctly, your Payroll Dimension is your Measures dimension ( correct? ). Normally Measures dimension is the last dimension in the cube. But my other problem with that cube design, it looks like you can have only One Grade for One Department / Year combination. Maybe this is what...

Hello all, Thanks for the replies. The scenario is as follows: I would like to use TI to create an MDX-driven subset to gather orphan elements. I could do this in 1 dimension, or all dimensions of a certain cube, or all application dimensions, ... I would prefer to only do the SubsetCreateByMDX and...

I have done this with a Text Attribute Element_Type and in the TI that loads my measures dimension, I populate this attribute, but you can have a Rule to automatically maintain that attribute. Basically same this as lotsaram is proposing.

You can't assign users to groups in TM1 if you're using IntegratedSecurityLogin = 5.
The User to Group mapping should be done in Cognos BI or whatever namespace you use (i.e. third party LDAP )
After user connects to TM1, the TM1 }ClientGroups cube will be updated automatically for that specific user.