TM1 Forum

The cube is created automatically if you use Performance Modeler, when you don't you can just create it with a TI process and it will work absolutely fine. However based on your instructions it looks like you are trying to set it so you can work with map charts, I *think* in PAW 62 you no longer act...

TIs process the data tab for 1 cell at a time. Assume the first record it runs for is the Job Level measure; at this point it moves job level over to the target division. It also transfers the status at the same time and sets the source status to 0. Assume the second record it runs for is Job Type, ...

Thanks everyone for your answers, it gives me a lot of idea. My next question would be; is there an "easy" way to convert MDX view to Native view? I know we can use tm1py to convert native view to MDX but I was wondering if the opposite is possible ? There are things that you can do in an...

I have seen this when a views folder contains .xbv views (MDX created e.g. through ViewCreateByMDX or PAW views etc.) If you manually delete the views folder while the server is still running there is a disconnect where TM1 gets confused by thinking that the folder already exists, so it tries to sav...

In terms of users being able to share views between PAW and PAX. If the user has an "Analyst" role in PAW and edit access to a PAW folder, they can save a view within the PAW folder structure. That view can then be opened by any user who has access to the same folder in both PAW and PAX. T...

['Actual', 'Jan 21 YTD', 'Turns (Gross)'] = C: ['Actual', 'Total Departments', 'Jan 21 YTD Rolling 12-Month' , 'Cost of Goods Sold'] \ ['Actual','Total Departments','Jan 21 YTD', 'Inventory-FIFO (Gross)']; I think if you go back to the above that worked for 1 month and try and expand that out a bit...

Good Morning Maren, I added the code and changed !PERIOD to !PERIOD MAIN but, after saving the code, it returned syntax and missing colon responses (see attachments.) In line 45, on the right-hand side of the equation, I can change !PERIOD MAIN to 'Period Main':'Control Total' which seems to be acc...

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.