TM1 Forum

Thank you for the help. I am pretty sure that worked. I get all #VALUE? errors now but I think that is my connectivity being unstable. Thank you for the help. I appreciate it #VALUE? errors can be caused by a number of things but one we have seen catching a lot of people out is that if you have ano...

That's an interesting one. I am 99% sure the setting used to just disable the users ability to see multiple tabs, so that they wouldn't have been able to click back and forth between two. But it still opened multiple tabs in the background (as long as the "replace" option in the action but...

Are the users able to manually open 2 tabs at the same time? If not it could be the hidetabbar option is set in either the config file or the }clientsettings cube.

I haven't spent a lot of time with TM1 Web in recent years but the old approach for hiding rows was to create an Excel table off the Active Form and then use the table as the source for the chart. From memory it worked well. I wonder if this would also work with an Exploration View in order to handl...

Hi Ashleigh,

There are 2 functions that can do this for you:

SubsetCreateByMdx - can be used to create a new MDX subset.

OR

SubsetMdxSet - to add an MDX expression to an already existing subset.

Thanks,
Declan

How often do you need it to update? The easiest and cheapest (free) solution would be to just export from TM1 to CSV on a schedule (with Chores) and then use the CSV Importer for Google Sheets which can also be scheduled. I should add you will need to get the CSV to somewhere with a URL before the i...

Normally the name reference is because you don't have the Excel add-in activated. The COM Add-in runs the ribbon etc. But to get TM1 formulas to work you also need the Excel Add-in called "IBM Cognos Office Reporting TM1 Addin" - you can activate it with the CognosOfficeTM1.xll file if it'...

There seems to be a problem with the HierarchyTimeLastUpdated function, which does not return a correct value for hours. Here is the test I performed: If(DimIx('}Clients', Tm1User) = 0); cTM1User = 'Chore'; Else; cTM1User = Tm1User; EndIf; cStartTime = Now; cProcessName = GetProcessName; cIdExecuti...

Hi, Thanks for the clear explanation. However, published .XLSM files are not being shown in the workspace. (they are public). I *think* that blue arrow symbol you have is for when it has been published with "add file as a reference" selected. If you try it without ticking that, they shoul...

Is the Jahre dimension in the title element of the cube that you are using this subset in? If so you can use CurrentMember to filter the Jahre dimension. And then you can use StrToMember combined with the intrinsic properties to find it in the Tag dimension also. {Filter( {TM1FILTERBYLEVEL({ DESCEND...

Are you using TM1 Applications (Contributor)? At a guess, it appears the views could be created when users perform certain actions e.g. submitting, taking ownership etc. But I doubt the views persisting is by design. So if that is the case, I would try and narrow it down to which actions cause a vie...

Apologies, I meant xlsm. xlsm files are not shown in the application folder in paw. And I do not think this workaround will work, sinse pax has the same issue. When you publish from within PAX you need to make sure to tick "make public" etc but any XLSM file should definitely show up in P...

They need to be saved as XLSM to include buttons nowadays... I think it is supposed to prompt you to save as XLSM first when you try and publish.

Yeah I was trying to avoid doing a loop. Why do you want to avoid doing a loop? I would say that for this sort of thing a loop be it on a dimension, subset, or "lookup dimension" (as per Burnstripe's comment) is *almost* essential - and very likely the most efficient way of doing it. Ther...

In PAW when you select a sandbox, you are selecting it for a widget rather than the whole session. You can have it also apply to other widgets by using the Synchronization settings. But I don't think Process Buttons in PAW have synchronization options that are capable of syncing sandboxes. If the ab...

You need to do some form of loop on the data tab where you loop through the weeks dimension. The most basic form of this would be to simply loop the entire dimension e.g. iCount = 1; iMax = DimSiz ( cDimWeek ); While ( iCount <= iMax ); sWeek = DimNm ( cDimWeek, iCount ); If ( DType ( cDimWeek, sWee...

You can have both element and component sort as “byinput”. You then have to use something like a shadow dimension to do all of your manual sorting in and then have a TI process do complete rebuilds on your main dimension with the shadow dimension as a source, the code then very carefully inserts new...

Sorry, I think I have different opinion on this. That was my first impression as well originally but after auditing, IBM says if you have ReadWrite user license, you need to let that user be able to write something back to TM1. You can't simply group your ReadOnly users under ReadWrite license umbr...

A standard performance management user is your bog standard read/write contributor/planner. As far as IBM are concerned if you pay for someone to have write privileges but only grant them read access - that is fine as it’s lower access. You could buy an explore/read only licence that’s cheaper so IB...

My recommendation is usually CAM authentication for full SSO compatibility with all interfaces and it gets hooked up to AD. But just 1 or 2 CAM groups per TM1 instance that give basic access. Then once the users are authenticated in TM1 we have internal mode 1 groups that assign the actual user acce...