TM1 Forum

Hopefully an easy one!

I have a review cube that counts the number of cells, the number of cells with values, the number of cells reviewed etc. from another cube

It's fairly big so I'm keen to use SKIPCHECK. To count the number of cells I have a simple:
['Total Cell Count'] = N: 1;

However, with SKIPCHECK on this needs to be fed as it is rule driven. How can I always feed this? Using [] => ['Total Cell Count'] doesn't work because there aren't any values, and I can't think of any other approaches!

Any help is much appreciated, thanks!

Well, if you'll recall from reading the rules documentation, when referencing in a value from another cube, the feeder statement for that value actually goes in the cube where the value is coming from so you would have to put your feeder in the cube that has the Review data. Since the number of cells with values would just be a count of all the cells populated then you can feed that measure to the Total Cell Count and likewise for the measure that has the flag or whatever you're using to indicate when something has been reviewed. As to the plain old cell count the only option I know would be to create a new measure in the Review cube and have a TI populate every cell with a 1 and then use that to feed.

Since you apparently didn't bother to read the request for assistance guidelines that's about all the help i can offer with the scant information provided.

tomok, thank you for taking the time to reply.

I did read the request for assistant guidelines and I thought I'd done everything required, I'm sorry if I've missed something in my question that has irritated you? Could you give me a better idea of what other information you require?

I should have been more clear in my first post. The only part I have an issue with is the ['Total Cell Count'], all others are fine, I just gave them for context. If the only way of having all cells counted is through a TI this isn't really an acceptable solution for me (as the structure is liable to change frequently) so I will just have to remove SKIPCHECK and accept the performance implications.

Does anyone have any other solutions in this situation?

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.

Rustyk1 wrote:I did read the request for assistant guidelines and I thought I'd done everything required, I'm sorry if I've missed something in my question that has irritated you? Could you give me a better idea of what other information you require?

5) For Rules and TurboIntegrator processes, posting the actual code and the real names of and structures of your cubes, dimensions and elements will be a thousand times more useful than an attempted description of them. You don't need to post real data, but the real code is needed. Pseudo code is obviously not "the real code". When you post something like "Suppose I have cube A and Cube B, and my rule is ['value'] = N:DB('CubeA', 'dim1, dim2'" etc, then three things happen. One, you reduce the chance that a syntax or typing error will be spotted, which means wasting time bouncing posts back and forth to try to get to the root of the problem. Two, you are usually describing what you think is happening, which may not be what is happening. Three, some more experienced members won't even look at the question because they've had too much time wasted by the first two issues in the past. You can upload entire .pro, .cho or .rux files as attachments if necessary, or just copy and paste the relevant part into your post using the Code tag at the top of the post editing window.

You also haven't defined what Total Cell Count means anyway. Does it mean what it says, a count of the number of cells in a cube? If that's the case then it is just the product of the number of elements in each dimension. Total Cell Count = CountofElementsInDim1 X CountofElementsInDim2 .....X CountofElementsInDimx. In this case the rule would be Total Cell Count = DIMSIZ(Dim1) X DIMSIZ(Dim2) X ....DIMSIZ(Dimx).