Hi all.
I'm tryin' to get data from a cube via TI-process.
I'm getting right data and everything fine except dimension elements which have c-level overriding rule like
['Rent.Distribution':'5'] = DB('Plan.Rent.input', !CurrencyVersions, !Locations.Rent, 'usd', !Date, 'Total', '3');
or
['Rent.Distribution':'3'] = ['Rent.Distribution':'2'] - ['Rent.Distribution':'1', 'BusinessUnits.Plan.Rent':'1'];
When i started to trace ti-process, i understood, that ti doesn't even try to process those elements.
I have picture describing all above:
http://dl.dropbox.com/u/7650174/ti.png
there 'cost of 1 sq. m.' doesn't processed by TI.
Could anyone please tell me how to get those values?
c-level overriding rule and TI process
-
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: c-level overriding rule and TI process
Hi there,
I can't view the attachment but, in your TI process, have you set ViewExtractSkipRuleValuesSet=0 and ViewExtractSkipCalcsSet=0 ?
I can't view the attachment but, in your TI process, have you set ViewExtractSkipRuleValuesSet=0 and ViewExtractSkipCalcsSet=0 ?
-
- Posts: 4
- Joined: Tue Feb 21, 2012 9:17 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007 2010
Re: c-level overriding rule and TI process
Yep, i've set this settings in prolog, but nothing has changed.
-
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: c-level overriding rule and TI process
Can you confirm that those elements are in your Datasource? What have you got set for the ViewExtractSkipZeroesSet function?
-
- Posts: 4
- Joined: Tue Feb 21, 2012 9:17 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007 2010
Re: c-level overriding rule and TI process
Those three SET parameters were fine.
And i've found reason for described behavoiur: absence of feeders for such kind of rules.
TI process has started to work with feeders
And i've found reason for described behavoiur: absence of feeders for such kind of rules.
TI process has started to work with feeders