TM1 Forum

Thanks, specially to Paul. It was the right hint and your tool to derive number of elements an number of Member Unique Names (MUN) was a great help! I modified it a little bit: a) it gave errrors when a dimension had no elements b) it had problems with special signs (that should not be used, I know ...

Hi there, I've a question regarding RAM-Usage. My Application is running Planning Analytics 2.0, Windows Server 2016 Task Manager shows it's RAM usage ~25 GB }Stats by Server also shows total RAM of 25 GB, Garbage ~11 MB }Stats by Cubes shows total RAM for all Cubes ~ 5GB Dimensions size in Total is...

shall the new cube consist of the same dimensions or do the need to be renamed, too?
in the first case, go to the data directory, copy the Master.cub-File and rename it to Master_test.cub and start the server again
In the second case, you'll have to do it via a TI-Script.

I think the problem is, that once the user goes down a level, he does not work in the subset "CC200" (which consists only of Level1) any more, so the SUBNM looses the link to the Subsets Name - but actually, I've got no idea how to solve.

Hi there, I found the Cube }StatsByProcess in my TM1-Model (Planning Analytics 2.0, but I think, it's avalable since TM1 10.something) but I cannot find any documentation regarding this cube. Does anyone knows something about the different Values in the cube: Current State Completion Status Client N...

Hi there, we did the upgrade to Planning analytic 2.03. We use TM1 web. in the case of one inputsheet, it is not possible to make a data-input in TM1 Web in MS internet Explorer (Version 11). The same sheet opened in Google Chrome (Version 68.0.3440.106 (Offizieller Build) (64-Bit)) it is possible t...

Dear all,

thanks a lot for your help and comments. what finally worked:
ELISCOMP(DimName, ElementName, Subname)
this works in TM1Web, too,

Thanks especially John for this idea!

Regards

Mark

Thanks for the quick response and the good idea. I have to say, that in my case (TM1 10.1., Excel 2013) it does not work. Even if the element is not part of the subset, the subnm-formula delivers the name: SUBNM("Planning Sample:Departments","Production","Marketing") de...

Hi there,
is there a possibility to get the information (in Excel or in TM1Web, not via TI):

Element xyz is part of Subset abc?

Thanks in advance!

Mark

Hi there, the following Problem: in a cube, there is a large Dimension, containing Projects (~1.000.000 Elements). Now, I want to built a Report via activeform, where the user can select his Region and gets all his Projects. I'm trying to do this via mdx: {TM1FILTERBYPATTERN( {TM1SUBSETALL( [dimName...

Hi there, I need to drive an Export and have to copy the exportfile to a ftp-Server. therefore, I have a ftp-user and a ftp-Passwort. I tend to write both to my parametercube, where I store all parameters as paths, adresses etc. Is there a possibility not to write the Password in clear letters to th...

Hi there, I'd like to get a number of cubes (5 to 10) from one TM1 Server (10.2.2) to another. I 'd like to do it via TI and copy all needed files (Cubename.cub, Dims1...x.dim, }ElementAttributes_Dim.cub etc.) to a migrationfolder in a first step (this, the TI should do), check the files and than co...

Hi there, I'm driving a daily import of ASCII-Files. Sometime, the sourcesystem delivers files without any data, so the filesize =0. Unfortunately, if my import starts, I start with a zeroout, so all data in the cube are gone and as the sourcefile does not contain any data, the cube keeps empty unti...

Dear all,

I've got a Workbook with a start-sheet, where the user selects month, costcenter etc. and then several sheet with active forms.

Is there a possibility to rebuilt all sheets with one click? In Excel, I could do it with VBA, but in Web?

thanks for your ideas!

Mark

Thank you very much - although you're right: that's not what I wanted to hear

Regards

Mark

the rules and feeders in the cube do not refer to other cubes: Nor do other cube-rules get data from the cube nor does the cube's feeders refer to other cubes.

Hi there, I'm facing a model where a list of cubes is set to "DemandLoad" = "YES". Nevertheless, all these cubes are loaded when the server is restarted. How can I make the cubes keep out of the memory? Versions: TM1 10.1 Cubes include Rules PersistentFeeders=T Thanks in advance!...

Dear experts, is it possible to modify a private view, so that public subsets, that are assigned to the view, are unleashed? The following situation: I'm getting in contact with an old TM1-model. Over the years a huge number of public subsets and views are grown. I already got rid of lots of public ...

Dear all, The question: Is it possible, that "cubeunload" makes problems, if a TI is started from another TI? the following situation: I've a TI (I call it TI No 1) that imports Data from a csv-file. Every week, this TI has to run three times to get all Data for the quarter (one time per i...

tm1_bloke wrote:I have similar experiences that INSTR doesn't work in Excel Active Forms BUT when the same active form is uploaded in TM1 Web, it works there without any issues.

Hi there, you're right, it works in web! Thanks!

Mark