TM1 Forum

I can’t remember the exact version when it was introduced but for quite a while now there have been standard system dimensions that list all of the subsets for each dim and views for each cube. The dimension name would be }subsets_<yourdimname> and it just contains all of the subset names as element...

At 1 of my previous clients the DSN we used was set to use windows authentication (somehow not quite sure how) so with that 1 we just provided the DSN name without user or password and it took it from the system account that was running the service. Sounds like the set up you have could be similar?

If you create an element security cube for any dimension then the default assumption is that every group has no access to an element unless you specify otherwise. If you have a multi group environment we normally get around this by having 1 or 2 base groups in addition to the more detailed groups. E...

Like the others have said actual code would be could but assuming the pseudo code you have provided is correct then I expect your data source is the problem. As I understand it: 1/ You clear out holds on the cell (so that the proportional spread doesn't fail) 2/ You proportionalspread a data cell 3/...

I've edited the above post a few times already as I keep thinking of extra steps to test. If I pass 1.2344567778 * 1000000 from the parent process it gets truncated in the child's asciioutput. So its as if the runprocess seems to back trace any numeric value to its starting point and assess whether ...

It's an interesting one and I thought that gtonkin was on the right path so I did a test myself with below processes: Parent: cProcChild = 'Child'; nNow = Now; AsciiOutput ( 'c:\Parent.txt', NumberToString ( nNow ) ); nNowMega = nNow * 1000000; RunProcess ( cProcChild, 'pnNow', nNow , 'pnNowMega', n...

For the strings you are passing I wonder if there are any special characters? The sizes don’t seem likely to be a problem but maybe the content is doing something spurious.

At the moment the MDX primer is a great starting point. Once you’ve got your head around that and the basics I find you have an idea of what you are looking for googling tends to take you to the standard Microsoft MDX docs which can then be a pointer in the right direction - for example I guessed th...

First thing to consider when using IIF is what type of result we will get from the THEN and ELSE. I'm sure you've looked at the MDX Primer for this (as I did a while ago when having a similar requirement) and found the example relating to the IIF being used to decide whether to filter by the top 5 o...

Yes. Private subsets are stored in the data directory in folders for the username. Generally when migrating you want to take the opportunity to clean up some clutter from the data directory anyway. Copy all the users folders out to a separate location and Copy that to your cloud server. After you ha...

Assuming it is only the dimension cbm_hybrid_program_project that you care about being ordered; you can keep the source view as you have it but with that dimension instead just having a single element in its assigned subset which is the total of all relevant elements. Make sure consolidations are in...

Only active form reports having the issue. Must of inserted the lines incorrectly as that did not work. Delete all rows apart from the first in the active form (the one that actually contains the tm1rptrow formula. A few rows below that type a word into a cell, something visible. Update the file on...

Insert a few extra rows under the active form area and add a border to the cells a few rows down then reupload the sheet and it will be fine.

That’s just a case of selecting a given cell from an existing cube view and right click - Add to Sheet. Or similar wording to that effect.

and the value in tm1 web view looks in blue color. Is the user using a sandbox ? no he is not using any sand box.test_process1.PNG The blue colour means that the user is using a sandbox.This could either be a manually created and selected sandbox - or very likely the user has the Personal Workspace...

As an admin go into the }processsecurity cube and find that TI process - then put READ in the cell that corresponds with a security group that the user belongs to.
You can also right click on processes and go to security that way for the same purpose.

I handle this by having the master process create a text file in a folder and pass the name of that file to the sub process (doing this for ever sub process it runs.) The last line of the sub process deletes the file. At the end of the master process it loops the folder counting the files that exist...

Also one omre question in perspectives i am able to edit the action button properties by right clicking the button and properties .But in PAX once I add the button ,I am not able to edit to change any settings. I checked in design mode and also right clicking not giving the same option For buttons ...

It sounds like you have used the server parameter in the web config file. If you remove it (leave it blank) then the drop down box will appear. You will need to restart the web service after changing the config file.

You can get them from the }externals folder in your data directory.