Cells calculated using rules not being transferred via TI.

[jbcraigs]

In our source cube we have certain cells which are being calculated through rules. Feeders are in place and values are visible as expected.

We are trying to use TI to transfer values from this cube to another cube but TI is not copying any calculated cubes from source into the target cube. All other non rule based values are being copied fine.

I know for view extraction there is a parameter you can set to true or false to skip/not skip rule based cells. Is their something similar that I need to use in my TI process??

Thanks.

[jim wood]

How are you establishing the view to copy? Are you creating the view within TI? If so you need to use ViewExtractSkipRuleValuesSet.

Straight from the help file.....

Syntax
ViewExtractSkipRuleValuesSet (Cube, ViewName, Flag);
Arguments
Cube: The parent cube of the view for which you are setting the option.
ViewName: The view for which you are setting the option.
Flag: A binary value that turns the option on or off. Specify 1 to exclude rule-calculated values from the extract. Specify 0 to include rule-calculated values.

Example
ViewExtractSkipRuleValuesSet ('99sales', '1st Quarter Actuals', 1);
This example turns on the Skip Rule Calculated Values option for the extract created from the 1st Quarter Actuals view. The extract will not include any rule-calculated values.

[jim wood]

This post: http://www.tm1forum.com/viewtopic.php?f ... 78&start=0 contains quite a bit about using views in TI,

Jim.

[jbcraigs]

Thanks Jim.

Issue was with the way I was creating the view itself.