We have a problem in our TM1 system...a Reporting Cube, whose response time is too long i.e close to 4 minutes.
This "Report Cube" has 9 dimensions. This cube though sounds only for reporting purpose, it is used for forecasting also.
There are many business rules along with some Translation of currency rules to convert "Local Currency" to "USD" which fetch from Foreign Exchange cube (XE Cube) and long response time is due to these currency translation rules.
This is because, when i comment these rules & feeders, the cube response time is 90 sec.
The "Currency" dimension has two elements "USD" and "Local Currency".
Rules are:
Code: Select all
SKIPCHECK;
['USD']=N:IF (ATTRS( 'Versions', !Versions, 'Translation Currency' ) @= 'USD',
['Local Currency']
\ DB('XE Rate',!Versions,'Avg Rate',
IF( ATTRS('Divisions', !Divisions, 'Functional Currency')@='', 'USD', ATTRS('Divisions', !Divisions, 'Functional Currency') ),
!Period-Month),
CONTINUE
);
['USD']=N:IF (ATTRS( 'Versions', !Versions, 'Translation Currency' ) @= 'USD',
DB('Report Cube', !Versions, 'Local Currency', !Lines of Business,
!Period-Month | ' YTD',
!Business Units,!Depts,!Divisions,!Accounts,!Measures)
\ DB('XE Rate',!Versions,'Ending Rate',
IF( ATTRS('Divisions', !Divisions, 'Functional Currency')@='', 'USD', ATTRS('Divisions', !Divisions, 'Functional Currency') ),
!Period-Month)
- DB('Report Cube', !Versions, 'USD', !Lines of Business,
IF (SUBST(!Period-Month,1,3)@='Jan', 'Opening Balance ' | ATTRS( 'Period-Month', !Period-Month, 'Year'), ATTRS( 'Period-Month', !Period-Month, 'Prior') | ' YTD'),
!Business Units,!Depts,!Divisions,!Accounts,!Measures),
CONTINUE
);
Feeders;
['Local Currency'] =>DB(IF(ATTRS('Versions',!Versions,'Translation Currency')@='USD','Report Cube',''),
!Versions,'USD',!Lines of Business,!Period-Month,!Business Units,!Depts,!Divisions,!Accounts,!Measures);
['Local Currency']=>DB( IF(ATTRS( 'Versions', !Versions, 'Translation Currency' ) @<> 'USD', '', 'Report Cube'),
!Versions, 'USD', !Lines of Business,'Dec-' | ATTRS( 'Period-Month', !Period-Month, 'Year') | ' YTD',
!Business Units,!Depts,!Divisions,!Accounts,!Measures);
Any best methods people have to share regarding rule (and feeder) tuning? How should the feeders be written to reduce overfeeding?
Please advise.