TM1 Forum

Hi, I have a dimension say car which has elements with parent ,child relation with different levels. car-> Toyota->SE,LE,XE Hundai->Model1->XSE now I need to copy all these elements to another dimension say 4 wheelers with a parent child relation in car I will create a subset of all N level in car ...

My Perspectives forces a save first (PA2.0.1) Architect gives same error. Can only recommend that you save your process then run - without saving, the objects are probably not registered opening up a slew of possible issues. That's why I never encountered that issue because I never tried to run an ...

That is what I exactly said :) When Creating Temp Subsets, the DimName argument should be placed in 4th place, Like in your third example: SubsetCreatebyMDX( sSubName, sMDX, bTemporary, sDimName ); I interpreted your answer as saying that sDimName had to be the 4th argument. That is, I thought you ...

Actually I just tested this. I am running Perspectives from my own desktop, and if I Create a New Process and try to run it, Excel Crashes If I do the same thing from Architect, then I get the error:

...Still works, but the DimName has to be the 4th Argument Thanks for testing and confirming TM123 - appreciated. I am still cautious of using undocumented features as they could potentially stop working with any future upgrade. They also make it a bit confusing when handing over to another resourc...

DimName argument is also the approach that I have used for some time to prevent empty set errors. Still works, but the DimName has to be the 4th Argument Not quite true. The bTemporary flag is optional. If creating a temporary subset then the flag must be the 3rd argument and the optional dimension...

gtonkin wrote: ↑Mon Jan 15, 2018 7:18 pm Have not tested this in 10.2.2FP4 as 3rd parameter is now for temporary object-will have to test if 4th works as third did previously.

Edit: thanks for the reminder TM123

Still works, but the DimName has to be the 4th Argument

I use a different approach:

SubsetCreatebyMDX(sSubsetName,sMDX,sDimName);

So if you provide The name of dimension as a third parameter, then TM1 will not throw an error if MDX returns empty subset

My memory may be a little rusty here, but aren't you able to add clients from the Cients/Groups screen when you're connected via CAM? The BI user selection window pops up, search for the users in the desired AD and add them to the TM1 Clients. Now all that's left is to set any group assignments (li...

but the problem is that Active Directory User does not show until the Users signs in in TM1 That is correct and it is one of the limitations of what you are proposing. That (and a ton of other reasons) is why I HATE using CAM. Just add the users manually and use IntegratedSecurityMode = 3. Only AD ...

My requirement is to allow a super user (through a user interface/websheet) to delegate users to do something on some other user behalf(basically replicate the access of another user when a user is absent). We user Security Mode=5, and in TM1 I have more flexibility when it comes to automate the Use...

Hi guys, When you use Security Mode=5, is it a good idea to have all groups coming from Cognos BI/Active DIrectory? I need to be able to have some native TM1 Groups and use them for Data Security. I need to have a group for each branch ( I have Branch Dimension) and assign Active Directory Users (wh...

You are applying your filter in the ElementAttributes cube (Your Base MDX is {[}ElementAttributes_Location].[Country Code]} ). I don't think this makes sense Can you provide the MDX expression with Hardcoded Version and Unit, and then we can help you modify it so it uses the Version and Unit selecte...

You only need to use PM to setup the hierarchy, security and which forms are used for data entry etc. It shouldn't screw anything up as it won't deploy any rules or anything like that. Thank you Jim, but do I need to deploy my websheets in TM1 Application Web? So you think this is a better approach...

You can use the }ElementATtributes_dimName cube in your filter. Can you check if MDX below will give you want you want?

{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [<dim>] )}, 0)}, [}ElementAttributes_<dim>] .([}ElementAttributes_<dim>].[<NumericAttribName>])=1)}

Why don't you do this with an MDX: You can try the code below sMDX = '{TM1FILTERBYLEVEL({DESCENDANTS(TM1SUBSETTOSET([' | vDimName | '],"' | vSubset1 | '"))}, 0)}' ; IF (SubsetExists ( vDimName , vSubset2 ) <> 0 ); SubsetDestroy ( vDimName , vSubset2 ) ; ENDIF; SubsetCreateByMdx ( vSubset2 ...

If I decide to use the Out of the Box Approval Hierarchy, do I have to use Performance Modeler/and TM1 Application Web? In my case, I do have an existing TM1 Model, I am using TM1Web Websheets with Action Buttons to allow users to calculate data and move data around, and I need to implement an Workf...

Is this behavior in TM1Web or Perspectives?

Also, are they ruled cells, excel formulas, or TM1 Consolidations?

Thank you, good suggestion

I actually gave up on that Rule so I write a process to populate the }DimensionSecurity cube, so far has not given any issues but for such a simple Rule, I had to complicate little bit my model just because the Rule was not doing what it is supposed to do.

The problem is that if I delete the Rules and also I delete the }DimensionSecurity cube from my model, then non-admin users cannot open any of the cube views, so I need to populate the }DimensionSecurity somehow. I know I can write a TI process to populate that cube, but I don't understand why the ...