TM1 Forum

You can use the DIMSIZ function to get the number of elements in your Region dimension, assign that number to a variable and then do a loop:

Or loop through all products in the Prolog tab and set the status to empty or "Inactive" with AttrPutS function. Then in the Data tab set status "Active" with AttrPutS. Or create a view on the }ElementAttributes_Products dimension with just that one attribute and do a ViewZeroOu...

According to your pictures the subset used in the public view is indeed private. This is an invalid combination which is why other users are not seeing your private subset when opening the view.

Hello, I would like to hear experiences with Large TM1 servers with more than or close to 1 TB of memory. Are there anyone who experienced TM1 servers with more than or equal to 1 TB of memory? What are the major challenges and how do you overcome those? Thanks in advance for all replies. Regards, ...

Hi, I am trying to find more information related to multi-threading in Planning analytics. Did not find any great examples to implement this in TM1. I want to load the data from source (csv file with 500,000 records) to a staging cube in TM1 using multi-threading feature to improve performance. Any...

I think the key is the syntax checker is not smart enough to follow conditional logic. It just looks at the code and barks if it thinks something is wrong. Since the first mention of V3 in your code is to set it to VN, which is a numerical, it thinks V3 is a numerical variable. Your next mention of ...

Hello, its strange that the ASCIIOUTPUT does not create the output .cma file at all The code is very simple .... ASCIIOUTPUT('/folder1/folder2/test1.cma', '1', '2', '3'); Its a linux server and running TM1 10.2.2 (I want to extract a view and that's not working either ...so I tried a simple code as...

For starters, subsets exist on the server and there is no functionality in TM1 to create or modify subsets via an active form so this is not happening. It sounds like you are talking about using MDX in a TM1RPTROW formula, instead of a subset. If so, that formula only exists in the first row of the ...

I bet not many of us have used the second argument (Insertion point) in a function like DimensionElementInsert :D For me, I can count those situations on 1 hand. I know about that one but the problem for me isn't the position of the newly inserted elements, it's the ability to re-order the existing...

Another thing about the XDI. You can very easily control the ordering of the elements. Doing this via TI is extremely difficult. Our users like to have the current year at the top of the time dimension by default. With an XDI I can move that year to the top and save and it's done. I know I can creat...

I used to get so many questions why so and so couldn't see what that I decided to build a series of cubes that would show me by client who has access, not just by group. I named the cubes }ClientAccess_Cubes, }ClientAccess_Dimensions, }ClientAccess_Elements_Regions, etc. The cube has three dimension...

Hi , We had this time period dimension as a static dimension and add the year and months once a year. Now I am trying to automate using a TI to build this . For few dimensions we remove the hierarchies to the lowest level and then readd them .Since elements might switch positons. For time ,Am i goo...

I wasn't aware you could list more than one element in the same dimension on the right-hand side in a feeder and have it work. I have always created a C element for those situations and fed that.

My advice to you is not to mix HTTP and HTTPS. I have a good bit of web experience (not PA) and I have had nothing but problems when trying to mix the two so I never do it anymore. Is there a specific reason why you don't have TM1Web and Sharepoint both rendered via HTTPS? That is pretty much the de...

Thanks alot Adam, Really appreciate it. Working now, I'd swear blind that I'd tried that but probably not got exactly the right combination of brackets and quotes and pluses and brackets. Really odd that the original form works in mode 1 but not in 5. Cheers, I think it's because a user ID in CAM l...

bunchukokoy wrote: ↑Mon Oct 12, 2020 3:43 pm We generate zip files in this directory --> C:\Program Files\ibm\cognos\tm1_64\webapps\Sales\Reports (alpha is name of the server)

Do the users have READ access to this directory on the new server? If not, the links will tell you that the file does not exist.

MarenC wrote: ↑Mon Oct 05, 2020 1:01 pm Hi Tomok,

you had one too many parenthesis in that but otherwise worked perfectly, thanks!

Maren

I accept no responsibility for syntax errors.

Hi, I have 2 mdx based subsets, one to find a variance between the current and next period and another which asks if an employee has an end date. I now want to combine the 2 to see where the variance is possibly due to an end date. I can combine the mdx statements into one with an and condition, wh...

Can you assist me what or where i should start looking for permission? How about all the folders where the programs called from your batch file are stored. Does the TM1 service account have access to these? What about any files that are written. Does the service account have permissions to create f...

When batch files run when you initiate them and they don't run under TM1 it is due to permission issues about 99% of the time.