If the mapping will never change you can put an attribute on dimension B saying which element it maps to from A (this is really a mapping dive anyway) and/or you can have consolidations of element A in dim b but without really understanding the relationship of what these dims are it’s hard to say wh...

Apologies to ask a basic question but it is actually something Willi has asked twice in this thread and unless I am missing it I can't see an answer... is the issue that a row containing all zeroes is still showing? Or are you expecting a column containing all zeroes to be hidden? If its the latter,...

Wim Gielis, thank you for the hint about TI. I understand the purpose, but not sure how it works. Is the functionality the same as if it was a CellSecurity cube without "}", and security from it should be ruled to the other cubes (I don't see any rules that refer to it), or it actually automaticall...

The below code first filters to get all the elements in dim1 that match your criteria of exceeding a value of 1 in the cube. It then uses the generate to do a while loop of those elements and for each of those; dim2 is filtered to where the attribute matches the dim1 element name. Note that due to t...

Do you mean create 2 numeric measures in tm1 and format these as dates? I did mean that - you would format them using the element attributes. If so I am not holding the start and end dates in TM1 I am just using the start and end date to drive some logic in the TI process. So these dates only exist...

Incidentally I got round the problem of validating the dates by validating them on the websheet, so I have a new parameter, pValidDate and if a cell on the websheet shows invalid the process errros saying the dates are invalid! You could just have them input to a numeric cell that is formatted as a...

Hi Jim, When you go to add users and the CAM screen comes up there should be a tick box in the top left that says "Show users in the list", if you tick that then you should be able to find the CAM users. Its annoying that this isn't ticked by default since you have already told it that you are wanti...

I have never had a problem with swapping the alias in as long as you do it carefully. You start with an element called “sprouts” and give it an alias called “turkey”... for TM1 to allow this in the first place you know that there can’t have been any other elements named either Sprouts or Turkey so t...

One more option is that the work in excel could be a red herring.
I believe if a user pressed an action button when they don’t have access to run the TI; you don’t see any messages in the log... would be nice to see a “Bob can’t run TI x” but at the moment I don’t believe we get that.

Create a cube (as Paul suggested) with an extra dimension for "client" - this cube can contain all the same other dimensions as the cube in your screenshot and then is simply update by rules that say if the client measure in source cube for "Cliente" is equal to the client element in your dimension ...

Sounds like you are referencing your active form view in the DBRW. If you reference the active form view for an element that isn’t part of the view (not in the subset) then it can’t pull the resulting value from the cache as it’s not there. Change the referenced view to a hard coded cube name to pro...

Might be wrong but think the OP wants zero suppression in a way that shows an element in a common dimension when there are values in either cube A and/or cube B. If that is the case I would normally depending on a number of factors either: A/ rule values from one cube to the other and then zero supp...