TM1 Forum

I remember an issue where the Cognos BI infrastructure could not cope with a rule-defined consolidated value for which none of the underlying leaf level values were, or evaluated to non-zero, regardless of whether it was fed or not. Could this be your problem? I had to recommend a workaround where a...

The key thing is that by specifying a start index they have given a way of iterating over all the occurrences of an element in a subset.

ConsolidatedAvg gives you the average of all leaf cells below the one you have chosen with the coordinates. It appears that you want the average of the sums across client. You should be able to get this simply by multiplying each result by the number of leaf clients feeding into it. You can get that...

To be sure you need ProcMon. This will tell you exactly which process is locking the file.

qml wrote:To me it looks like in your case 'Memory Used for Input Data' and 'Memory Used for Feeders' are both wrong

this is highly likely particularly given that

its_me wrote:Memory Used for Feeders 16777216

is an exact power of 2.

It may be worth checking whether any of the feeders are targeting consolidated cells. If so then you might benefit from reading this.

The MTQ=All parameter is interesting. Do we know if that means physical cores or hyper-virtual cores? The documentation here did not specify.

It's a good one for an RFE. But until that comes along ... We used to have our own additional logging and a convention that all processes would log their parameters as the first thing they did when they executed. I was working with a very organised chap at the time who set up all the infrastructure....

It depends how your processes are being called, but if you are interested in parameters for processes called from within other processes they will appear as function arguments to the ExecuteProcess function in the calling process.

If you wanted N multi-threaded processes to commit or rollback in coordination (if such functionality were possible) you would have to have them counting success/failure flags and only commit when all N (including themselves) have been counted. This is known in the trade as a " two phase commit...

You could also have the cell count measure calculated as 1. It would only aggregate the calculated 1s for the cells that had been fed.

If you run this when for some reason no elements are returned by the filter, then your SubsetCreateByMdx call will fail.

This, and its solution, is discussed in this thread.

FYI - As of 10.2 TM1 is capable of removing data from the cube rather than just storing zeroes. Even pre-10.2, zero values are not saved out to disk and would not affect the size of the .cub file. As far as I was aware, when UNDEFVALS was specified it was the undefval (4.94066e-324 - see here ) tha...

The other thing about the new caption capability is that you can use any text attribute. It doesn't have to be an alias. This means that you can have multiple items with the same caption. So if you have France->Paris and Texas->Paris you can call both the leaves Paris.

I doubt if this is your circumstance but just in case ...

If you have nulls on for the cube and you use ViewZeroOut in an import TI then it will write actual zeros to every cell in the view. These zeros will then get saved to the cube.

I can't argue with that.

IMHO, the TI java extensions are a big hack. Sure, you get to code in java ... Here speaks a man who has never had to write a TM1 object/version management system with rule parsing, dependency analysis and documentation, all in TI. This kind of stuff needs a programming language, not something with...

If you have "None" against a source field it will not create a variable. You need to have "Other".

It is quite possible that a number of these have been around for a while but that this is the release in which they are first documented. I certainly recognise ZeroWeightOptimization and CognosMDX.UseProviderCrossJoinThreshold from before.

CAVEAT - this info was certainly true in 9.5 but may be out of date. Could anyone who knows better please update it? When comparing pro files you should look at what kind of datasource it is and then strip out anything that is only relevant to other data-sources. The reason for this is that they ca...