Impact of enabling a specific combination of view manipulation functions

Post Reply
User avatar
gtonkin
MVP
Posts: 1265
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Impact of enabling a specific combination of view manipulation functions

Post by gtonkin »

Read this for some information on using ViewExtractSkipCalcsSet and ViewExtractSkipZeroesSet when working with strings. Results may skip all consolidated cells, even if the measure is a string, if functions are not used/implemented correctly withing TI.

Relates to:
  • ViewExtractSkipCalcsSet
  • ViewExtractSkipConsolidatedStringsSet
  • ViewExtractSkipRuleValuesSet
  • ViewExtractSkipZeroesSet
Gist is that ViewExtractSkipZeroesSet=0 will skip all consolidated cells, even if the measure is a string, whereas ViewExtractSkipZeroesSet=1 won't unless you use the ViewExtractSkipConsolidatedStringsSet function.
BR, George.

Learn something new: MDX Views
Post Reply