Page 1 of 1

Transfer rule value to other cube using TI

Posted: Mon Aug 28, 2017 9:59 am
by emma
Hi.. i want to transfer value from one cube to another cube using TI
but there is some value from source cube that came from rule calculated... How i transfer that value using TI ?
I already tried to uncheck skip rules calculated... but it didn't work... is there another way ? thank you

Re: Transfer rule value to other cube using TI

Posted: Mon Aug 28, 2017 11:41 am
by jim wood
That should work. Without more details it's difficult to give an exact answer but it does sound like the values are not fed,

Jim.

Re: Transfer rule value to other cube using TI

Posted: Wed Sep 13, 2017 8:01 am
by Drg
show your TI code!

Re: Transfer rule value to other cube using TI

Posted: Fri Sep 22, 2017 9:57 am
by st2000
I had a (maybe) similar issue, and could solve it. My view (TI's sourceview) shows interactively also C-elements, but the TI does only log out N-element's values.

Before, I tweaked the view using the data source selectors GUI, and there I checked on to skip the consolidations. In the TI-view generated later and made to source by these commands...:

Code: Select all

DatasourceNameForServer=sCube2Spread;
DataSourceType='View';
DatasourceCubeview=sViewName;
...I expected to catch via TI/data tab the same amount of cells like the same view in the cube viewer does. But I never got the C-elements as displayed in the viewer grid.
It was only a desperate try&error-idea to add:

Code: Select all

ViewExtractSkipCalcsSet (sCube2Spread, sViewName,0);
which switches off the skipping (as per doc this is intended to use for writing out .cma-files). Now it works as desired and initially expected. It seems that this switch was in effect all the time. And not kept at 0 always when the view was created new per TI execution. Unfortunately I didn't found a TI variable to derive the current status of a view about skipping C/rule-values/zeros.

If this happens to you, under the hood, concerning rule-values this might help:

Code: Select all

ViewExtractSkipRuleValuesSet (Cube, ViewName, Flag);
Set the Flag=0 and try again. If the cause was a suppression of rule values, your TI should be able the catch them again. Hope it helps.