TM1 Forum

If you mean a report in Perspectives, use DBRA worksheet function. =DBRA("ServerName:DimensionName";"DimensionElementName";"AttributeName") As DBRA works like DBRW, which means displays the value, but also enables user to change it from Perspectives level I sometimes us...

You can try to define each union part as a separate subset. Then you can create another main subset that does union on those subsets, something like: UNION({UNION({[Dimension].[Subset1]}, {[Dimension].[Subset2]})}, {[Dimension].[Subset3]}) The above is not tested, just a hint where to go (there migh...

I just wanted to let you know that problem does not exist anymore. I first changed security on applications, cubes and processes to manual (not rule defined) as I decided to do it anyway this way. Problem still existed. Then today I got my server restarted and my problem disappeared. I think there i...

Thanks for a fast response :) I'm guessing you already know that you need to refresh security every time you change rules. Yes, I tried to write everything and forgot about this one. It all happens after I first refresh security as an admin and then nothing else changes (just the F5 gets being hit)....

Hello, I found something I do not like, maybe some of you experienced it before and maybe even you have some explanation/workaround for this? When I log in as a non-admin user i can see cubes and dimensions (left part of the picture), but when I press F5 in the SE (refresh), I do not see them (right...

How about this one:

If I understand you correctly, running this via TI should do the trick: It will apply automatic sorting of elements among this dimension (by hierarchy first and by name among hierarchy second).

By accident I just came to a finding that might be good to be aware of, especially in the context that there have been some posts wondering about difference between using CubeClearData and ViewZeroOut( here , here , here and here ). My finding is that CubeClearData does not only clear the data in th...

(I'd like to know if jstrygner optimized the dimension order in the test he did, if not it would be interesting to see the impact of additional dimensions on memory per cell in optimized vs. non optimized cubes.) Hi, I was not on the forum for a while. Responding to your question, I did NOT optimiz...

The results of the WildCardFileSearch function may vary depending on the operating system in use. Files in a Windows directory are sorted in alphabetical order while files in a UNIX® directory are sorted in random order. Because the order of sorting varies between the operating systems, the identic...

I thought then that the rule must be: "All N level children of a string consolidation must be fed for that string consolidation to be fed" so I fed each N level child explicitly without using the shorthand notation. This did not result in a feed to the string consolidation! To be honest, ...

I built the example and you are correct that only one child needs to be fed, but that child also needs to be calculated in the Target cube. This applies to both string and numeric consolidations. John, is it possible you tested it on 9.0 version (that is shown under your name) only? I did a retest ...

Is there a way to feed the ['Mes3'] ? In the sense of flag all cells in ['Mes3'] ? maps, if it helps, just see on the picture what I meant. I used here tomok's additional element approach, one filled cell is enough to feed the whole Mes3 column if you hit the top consolidation element in Product di...

From your example you can see, that there will always be a non-zero value in Mes3 leaf elements. That is why you could just feed the consolidation cell (to get all the leaves fed): ['Mes1', 'cons']=>['Mes3', 'cons']; But this one will not work properly when all of the Mes1 leaf cells are zero (or no...

when I write the same SQL language in the TurboIntegrator using the ODBCOutput, it gives me an output of "1" (which i'm not sure what it means). Select count (*) from vj_abc_finance_cost; First thing, I have no idea, how does it return this "1". AFAIK ODBCOutput is not a functio...

Hi, just checked what qml suggested on two environments: 9.5.1 HF17 and 9.4.1 FP3 (don't know which HF). In both cases feeding the string cell on leaf level does not make the string on consolidation level visible when zeroes suppressed :(. There is a method to achieve what you need without feeding a...

Is it possible you have Feeder instead of Feeders causing the problem?

i did see that topic before i posted but i am still unsure how does the expression actually works. Found some time to try to achieve what (I think) you need. The solution that worked for me is very similar to the case lotsaram gave you a link to, just requires a small trick with attributes you don'...

The results are what I would expect, unless you have the AllowSeparateNandCRules=T set in your .cfg file. Do you?

John Hammond wrote:You don't need to feed consolidations when they are calculated whether they are Numeric or String consolidations.

Strings for the calculation purpose, no, but e.g. for the "appear in a zero suppressed view" purpose you need to feed strings and I thought this is the case.