Input Entry Long Wait Time

[tgaluskapatterson]

Using TM1 10.2 with Excel 2010.

I am building a new salary cube in TM1 10.2. I enter my information for Name, Class, Title, Status, Start Month, Review Month and GL Account. Everything works just great. Then when I enter PY Starting Salary and hit tab or enter my screen takes between 60-90 seconds to respond. I do have some complex rules and feeders attached to this cube. If you need more detail on these let me know. When I enter information into PY Starting Salary and hit tab non of the other rules are updated making me think its not a rules issue. Once I click recalculate all the the rules I have do populate. If this is not enough information please let me know. I am simply trying to determine why there would be such a long waiting time after populating the PY Starting Salary? I can provide more information around the dimensions and rules calcualtions if need be. Thanks!

[tomok]

Feeders are triggered by data being entered into a cell that is feeding something else, not a recalculation of a view. Your delay is likely those feeders being executed when the input transaction occurs. The other values in your view are not changing because just entering data into a view does not trigger a recalculation.

[tgaluskapatterson]

Perfect! This really helps me narrow down my issue.

I have copied my feeders from the rules editor below. PAY NON COM and PAY COM are consolidate elements in my account dimension that have about 15-20 elements each in them. I am feeding the consecutive years in the salary input view so they can populate which shouldnt be a big deal. Also feeding the salary summary view which is in the same cube this is just used for reporting purposes. No values will feed into the summary view until Account, Class, and Statue are populated along with the PY Starting Salary. If the PY Starting Salary is populated with blank account, class, and status it still takes about 60 seconds to respond. Will feeders still fire if I don't populate Account, Status, and Class? The feeders seem relatively efficient to me although the feeder automatically generated I can't say is effcient for sure. Any suggestions? My best idea is that the salary input dimension down the left side of the Salary Input view is being feed to the Salary summary view by line so maybe 500 lines or so. Maybe I should try to summarize all lines to one when I feeder over to the Salary Summary view? Thanks again for the help you comment really helped me understand how TM1 processes entry lines!!

FEEDERS;
#Feeder Salary to Salary Input View
['Active','Period Input','Account Input','Class Input','Status Input','PY Starting Salary']=>['Active','Period Input','Account Input','Class Input','Status Input','Year 1 Starting Salary'];
['Active','Period Input','Account Input','Class Input','Status Input','Year 1 Starting Salary']=>['Active','Period Input','Account Input','Class Input','Status Input','Year 1 Ending Salary'];
['Active','Period Input','Account Input','Class Input','Status Input','Year 1 Ending Salary']=>['Active','Period Input','Account Input','Class Input','Status Input','Year 2 Ending Salary'];
['Active','Period Input','Account Input','Class Input','Status Input','Year 2 Ending Salary']=>['Active','Period Input','Account Input','Class Input','Status Input','Year 3 Ending Salary'];
['Active','Period Input','Account Input','Class Input','Status Input','Year 3 Ending Salary']=>['Active','Period Input','Account Input','Class Input','Status Input','Year 4 Ending Salary'];

#Feed Salary to Salary Summary View
['Active','Period Input','Account Input','Status Input','Class Input','Year 1 Starting Salary']=>
['Active',Period:'FY 2015','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2015','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2016','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2016','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2017','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2017','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2018','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active','Period Input','Account Input','Status Input','Class Input','Year 1 Starting Salary']=>
['Active',Period:'FY 2015','PAY COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2015','PAY COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2016','PAY COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2016','PAY COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2017','PAY COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2017','PAY COM','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2018','PAY COM','All Status','All Classes','Base Entry Salary (LC)'];
['Active','Period Input','Account Input','Status Input','Class Input','Year 1 Starting Salary']=>
['Active',Period:'FY 2015','53800-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2015','53800-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2016','53800-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2016','53800-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2017','53800-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2017','53800-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2018','53800-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active','Period Input','Account Input','Status Input','Class Input','Year 1 Starting Salary']=>
['Active',Period:'FY 2015','59000-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2015','59000-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2016','59000-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2016','59000-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2017','59000-0000','All Status','All Classes','Base Entry Salary (LC)'];
['Active',Period:'FY 2017','59000-0000','All Status','All Classes','Base Entry Salary (LC)']=>
['Active',Period:'FY 2018','59000-0000','All Status','All Classes','Base Entry Salary (LC)'];

#Region Automatically generated feeders
#Autogenerated AUTOFEEDERS
['Measure':{'Year 4 Monthly Depreciation', 'Include In Salary Pool', 'Year 3 Monthly Depreciation', 'Year 4 Fiscal Depreciation', 'Debt To Equity', 'Year 1 Monthly Depreciation', 'Quick Ratio', 'Year 2 Fiscal Depreciation', 'Pool Growth', 'PY Starting Salary', 'Operating Self Sufficiency', 'Year 1 Starting Salary', 'Year 1 Ending Salary', 'FY3', 'Year 4 Ending Salary', 'Year 3 Rate Change', 'Amount (LC)', 'Flag', 'Working Capital', 'Year 3 Starting Salary', 'Sales Input', 'Last Updated', 'Starting Pool', 'Year 4 Rate Change', 'Amount Input', 'FY2', 'Estimated Cost', 'Year 1 Rate Change', 'Percentage Of Sales', 'Year 2 Rate Change', 'FY1', 'Year 3 Expense', 'Current Ratio', 'Year 1 Expense', 'Year 2 Starting Salary', 'Year 3 Fiscal Depreciation', 'Year 2 Ending Salary', 'Total Depreciation', 'Included In Sales', 'Year 4 Expense', 'Headcount', 'Included In COGS', 'Year 3 Ending Salary', 'Unit', 'Year 4 Starting Salary', 'Ending Pool', 'Amount (USD)', 'Conversion Rate', 'Percentage', 'Equity Ratio', 'FY0', 'PY Increase Rate', 'Year 1 Fiscal Depreciation', 'Year 2 Monthly Depreciation', 'Year 2 Expense', 'System Flag'}, 'Status':'All Status', 'Line':{'All Projects', 'Manual Employees Additions'}, 'Class':'All Classes', 'Currency':'All Currency'] => DB('Financials', !Account, !ApprovalHierarchy, !Period, !Version,
!Measure);
#EndRegion

[tomok]

#Feed Salary to Salary Summary View
['Active','Period Input','Account Input','Status Input','Class Input','Year 1 Starting Salary']=>['Active',Period:'FY 2015','PAY NON COM','All Status','All Classes','Base Entry Salary (LC)'];

This statement right here is saying, in pseudo-code, for every value entered into Period Input, Account Input, Status Input, Class Input, Year 1 Starting Salary, feed EVERY SINGLE CHILD ELEMENT in FY 2015, PAY NON COM, All Status, All Classes, Base Entry Salary. It's no wonder it's taking forever for the feeders to execute, you are feeding almost the entire cube with every single entry. Just a little overkill.

[Wim Gielis]

tgaluskapatterson,

Freeders go from an n-type cell to another n-type cell, whether in the same cube or a different one.
Do you understand the impact of having C-type cells on the left side of the feeder, and even multitudes more important, having C-type cells on the right side of the feeder?

[tgaluskapatterson]

Thanks tomok! I will work on writing a conditional feeder to only populate the combinations enter in the input section. Again I appreciate it.