Transfer rule value to other cube using TI

Post Reply
emma
Posts: 14
Joined: Thu Jan 26, 2017 9:57 am
OLAP Product: 11.2.0.3.0
Version: 10.2.20400.80
Excel Version: 2007

Transfer rule value to other cube using TI

Post 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
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Transfer rule value to other cube using TI

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Transfer rule value to other cube using TI

Post by Drg »

show your TI code!
st2000
Posts: 62
Joined: Mon Aug 15, 2016 8:48 am
OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
Version: 10.2.0 FP3
Excel Version: Excel 2013
Location: Hamburg, DE, EU
Contact:

Re: Transfer rule value to other cube using TI

Post 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.
-----------------------------------
Best regards,
Stefan
Post Reply