Understanding ViewExtract TI commands

[jonathan.d]

Hi All,

Need a bit of clarification on the 'ViewExtract' TI commands.
ie.

VIEWEXTRACTSKIPCALCSSET=>if set to true, the extract would skip consolidated cells but include zeros, entered numbers and rule calculated cells at the N level?
VIEWEXTRACTSKIPRULEVALUESSET=>if set to true, the extract would skip rule calculated cells but include zeros, entered numbers and consolidated numbers?
VIEWEXTRACTSKIPZEROESSET=>if set to true, the extract would skip cells with value zero but include entered numbers, rule calculated numbers and consolidated numbers?

Am I right?

[Alan Kirk]

Need a bit of clarification on the 'ViewExtract' TI commands.
ie.
VIEWEXTRACTSKIPCALCSSET=>if set to true, the extract would skip consolidated cells but include zeros, entered numbers and rule calculated cells at the N level?

Yes, assuming that this is the only one of these functions that you call. (Although technically you pass a binary 1 value rather than setting it to True. Potato, potaato...)

VIEWEXTRACTSKIPRULEVALUESSET=>if set to true, the extract would skip rule calculated cells but include zeros, entered numbers and consolidated numbers?

Yes, also assuming that you haven't called any of the other functions. (I'm assuming that you're referring to standard consolidations here, not rule-based ones.)

VIEWEXTRACTSKIPZEROESSET=>if set to true, the extract would skip cells with value zero but include entered numbers, rule calculated numbers and consolidated numbers?

Yes, again assuming that you haven't called any of the other functions.

You can call more than one of the functions in your process to exclude any combination of the above.

[lotsaram]

Your interpretation and what Alan has told you are correct.

Just be aware that in some versions there have been some issues/bugs regarding rule calculated values and the interaction of VIEWEXTRACTSKIPRULEVALUESSET=0 and VIEWEXTRACTSKIPZEROESSET=1 where properly fed cells are still skipped in the view extract.

[John Hobson]

and also that some none fed calculated cells will not be exported even when you set VIEWEXTRACTSKIPRULEVALUESSET to false, which is a bit bobbins as feeders are supposed to be a way of enhancing performance, not making sure the product works as expected.

[jonathan.d]

Thanks for that guys.

The reason I asked about ViewExtracts is to find a way to speed up snapshots.

As of now, all I have is a ViewExtractSkipRuleValueSet=0.

I was thinking of a way to speed it up assuming the above view extract command would include zeros, and hence slow things down.

So I thought of replacing ViewExtractSkipRuleValueSet=0 with a ViewExtractSkipZeroSet=1?

In the sense ViewExtractSkipZeroSet would include everything but zeros.

However, it still takes the same time.

What am I missing?

[lotsaram]

Hi Jonathan,

I think with your last post you have confused a lot of people. I'm not sure if you are also confused yourself or f you have just used the wrong terminology.

The "ViewExtract" functions are used to assign parameter values to a "processing view" which is used either as a data source for a TI process or as a data source for a manual cube export. This has absolutely nothing to do with a "snapshot" which is an action performed manually by a user to slice out a cube view from the cube browser to Excel as values only.

TM1 is confusing in that there is no distinction made between a "user view" and a "processing view". If you want to affect a user view then the functions you need to use are ViewColumnSuppressZeroesSet and ViewRowSuppressZeroesSet.

[jonathan.d]

Hi,

Sorry about that.

Yes, I was a bit confused about how the ViewExtract TI command works.
By saying snapshot, I was referring to my snapshot process which copied values from one version to another.
I was trying to find a way to speed it up.

I had used the command ViewExtractSkipRuleSet(cube,viewname, 0) - which says give me entered values, zero values, consolidations and rule calculated values.
I thought by using the command ViewExtracZeroSet(cube, viewname, 1) only - would skip all cells with zero, and give me everything else.

However, it took the same time which made me realize that to skip anything it has to visit the cell. So, hence it would take the same amount of time.

Sorry, I should had this as my first post.

[LoadzaGrunt]

I had used the command ViewExtractSkipRuleSet(cube,viewname, 0) - which says give me entered values, zero values, consolidations and rule calculated values.
I thought by using the command ViewExtracZeroSet(cube, viewname, 1) only - would skip all cells with zero, and give me everything else.

I always use all three commands at once. There overhead is neglible but you gain a lot in terms of the code making more sense- you won't need to make assumptions about what the other settings are.

[bskalli]

I always use all three commands at once. But how can i generate Subsets with Elements<>0 ?