TM1 Forum

I am affraid ATTRS is TI and Rules function only.
Use DBRA in worksheet.

mce, you did not mention, so I want to make sure if you used FEEDSTRINGS command.

If I create subseti for Dim2, the dynamic subset would look like this. {FILTER( {TM1SubsetAll( [Dim2] )}, [Dim2].[AtrDim1Code] = [Dim1].[AtrCode])} So if select specific Group from dim1 only the list of the products from that group is listed. This works fine. Well, I was very surprised you wrote it...

lotsaram, I'm affraid have to disagree with some of your statements. Whether a leaf cell calculates the correct value has nothing to do with whether it is fed or not. If the cell value is directly queried then the rule will still be evaluated. (...) The purpose of feeders is not to assist leaf cells...

So at this moment I don't see what your test exactly is proofing. Michel, I think we interpreted Nicola's question different and that is why we gave totally different responses. My interpretation of the question was: - Let's assume we have a leaf cell that is calculated. - Let's assume this cell fe...

When you use rules to determine security you need to refresh the security.
Right click on server name, pick Security -> Refresh Security.
You can also use SecurityRefresh function in TI.

Do Calculated cell, when their value is zero, feeders other cells if they are feed? Nicola, I found your question very interesting and to answer it I decided... to check it :D I think attached picture shows, that fed cells that calculate to zero still feed other cells - the Q2 row shows that. HTH

The name of the ODBC connection - I agree that the best way is to put it in a cube (or attribute that in fact also is a cube). I once had an issue, when TM1 administrators were not supposed to see user id and password for the ODBC (if you'd store those in TM1, they would). It was a windows, so in th...

This ASCIIOutput is in Prolog/Epilog, or is on Metadata/Data and cubeview is the source for TI?

1. If you put: nbrTotalPutCommitments = nbrTotalPutCommitments + 1; before TEXTOUTPUT will this line return error (try to figure out if the variable is not numeric or the NUMBERTOSTRING itself has problems). 2. Is the value with decimal separator? Any chance some settings with decimal separator chan...

As mattgoff said, consolidation no.
Maybe an excel report that dynamically shows only elements to which user has access to and simple "=SUM(...)" function is satisfactory workaround.

Hi, Till now I thought that it is not possible to substitute one dimension in a cube with another that has the same elements, but a different dimension name (without recreating this cube). Today I found a way to do it and I would like to share (this is not going to be a nice drag and drop :)). Here ...

Yup, this one looks even better!

This is the power of brainstorm

You mean this part of the MDX Primer, considering that the original question was how to build a view which you then indicated could be done with MDX? No, I didn't intent to suggest you can construct a view via MDX. I just meant you can influence elements presented in particular subsets that already...

Hi, There was some similar topic here . I think it is not going to help you in your case, but I think it is worth to be aware of what was said there. But I hope this will help you :-) What I do in drill through processes (where the drill result is a view): - I use a static subset, because in such a ...

But if you have examples that you'd like to share I'm sure I wouldn't be the only one interested... Alan, either there is something I am missing here, or I don't know, why you asked it :) Nothing more than you can find in MDX_Primier. You build what you want (even compare values between cubes), esp...

Is there a quick and easy of creating views that are exception based? For example were you have demand but no capacity? Isn't subset with MDX such a method? Once you prepare and MDX that checks values in two or more columns, it is easy to change columns and conditions when you need to change your e...

All I can say I also tried to achieve it and the best thing I could think of was to add additional element to dimension and subset. In my case it was a dot '.' that was supposed to be treated as empty. Obvious enhancement would be to make TM1 accept empty values, but we don't have it for now (at lea...

Guys, thank you for your input. While the service was down we had a script that checked for any spaces and capitals and removed. My Views, and some of Applications I created now for further behavior observation have spaces in names and it does not seem to be the problem. Should I expect any issues w...

Hi, I wanted to clear my doubts I have. I first started replying to this , but then I thought it might be worth creating a new thread. What I found on this forum in some threads is that TM1 models run on UNIX environments are case sensitive, but I am afraid, there is something more. I think it is al...