TM1 rule tuning performance

[ChineseMan]

log

7928 [] INFO 2014-05-12 04:31:30.406 TM1.Server Processing feeders for cube "HQPS_Sales_Alloc_Control"
7928 [] INFO 2014-05-12 04:31:30.438 TM1.Server Processing feeders for cube "HQPS_Sales_DataStaging_Squeeze"
7928 [] INFO 2014-05-12 04:31:30.438 TM1.Server Processing feeders for cube "HQPS_Sales_RPT_CURR"
6244 [] INFO 2014-05-12 04:31:30.438 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_Variance'.

Instance will take 2 hours to Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube ,
What's root reason cause that?

And could anyone tell me his experience on rule tuning performance.

Best Regards.

[tomok]

Instance will take 2 hours to Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube ,

That's not correct. Are you basing that on the fact that the next line in the log file (which you conveniently did not show) has a date and time stamp 2 hours after the adding cube dependency line? What about the three "processing feeders"? Where are the log file lines that state when they were completed? That's what is taking the time, not adding a cube dependency.

And could anyone tell me his experience on rule tuning performance.

No, sorry. You are asking about the most complex and difficult issue with regards to TM1. I could literally talk for weeks about this issue. There is no way I would ever attempt to post anything in this forum on a topic so broad. Better you should take some training, read the docs, and read all the posts in this forum about feeders. That will give you a head start. Then you can come back and ask some specific questions.

[mvaspal]

Hi
As tomok wrote this is a feeder question and has nothing to do with cube dependencies. I presume the next entry in the file is something like:
Done processing feeders for cube "HQPS_Sales_RPT_CURR". If this is the case you should look at the feeders of the "HQPS_Sales_RPT_CURR" cube.

[ChineseMan]

Instance will take 2 hours to Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube ,

That's not correct. Are you basing that on the fact that the next line in the log file (which you conveniently did not show) has a date and time stamp 2 hours after the adding cube dependency line? What about the three "processing feeders"? Where are the log file lines that state when they were completed? That's what is taking the time, not adding a cube dependency.

And could anyone tell me his experience on rule tuning performance.

No, sorry. You are asking about the most complex and difficult issue with regards to TM1. I could literally talk for weeks about this issue. There is no way I would ever attempt to post anything in this forum on a topic so broad. Better you should take some training, read the docs, and read all the posts in this forum about feeders. That will give you a head start. Then you can come back and ask some specific questions.

Yes,you are right.I posted recently log.as log shows,computing feeders for 'HQPS_Sales_RPT_CURR took about 2 hours.What's kind of feeder issue would cause this issue?
9244 [e] INFO 2014-05-08 11:24:14.277 TM1.Server TM1CubeImpl::ProcessFeeders: Done computing feeders for base cube 'HQPS_Sales_RPT_CURR'.
9244 [e] INFO 2014-05-08 11:33:50.922 TM1.Server TM1CubeImpl::ProcessFeeders: Computing feeders for base cube 'HQPS_Sales_RPT_CURR'.
9244 [e] INFO 2014-05-08 11:33:50.922 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_Period'.
9244 [e] INFO 2014-05-08 11:33:50.922 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_Variance'.
9244 [e] INFO 2014-05-08 11:33:50.922 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_SALES_ACCTS'.
9244 [e] INFO 2014-05-08 11:33:51.031 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_PRD_Hybrid'.
9244 [e] INFO 2014-05-08 11:33:52.607 TM1.Cube.Dependency Adding cube dependency: Cube 'HQPS_Sales_RPT_CURR' depends on cube '}ElementAttributes_HQPS_Year'.
9244 [e] INFO 2014-05-08 12:20:14.662 TM1.Server TM1CubeImpl::ProcessFeeders: Done computing feeders for base cube 'HQPS_Sales_RPT_CURR'.

[ChineseMan]

Hi
As tomok wrote this is a feeder question and has nothing to do with cube dependencies. I presume the next entry in the file is something like:
Done processing feeders for cube "HQPS_Sales_RPT_CURR". If this is the case you should look at the feeders of the "HQPS_Sales_RPT_CURR" cube.

You are exactly right.
In your professional view,what's the problem with the feeders?

[lotsaram]

In your professional view,what's the problem with the feeders?

Unless you have 10s or 100s of GB of data in the cube a rule file taking 2 hours to process feeders is more than likely very poorly written. As far as "professional opinion" goes, that's all you're going to get without following the request for assistance guidelines and providing relevant information like the dimensionality of the cubes and a sample of the actual rule.

[ChineseMan]

In your professional view,what's the problem with the feeders?

Unless you have 10s or 100s of GB of data in the cube a rule file taking 2 hours to process feeders is more than likely very poorly written. As far as "professional opinion" goes, that's all you're going to get without following the request for assistance guidelines and providing relevant information like the dimensionality of the cubes and a sample of the actual rule.

Thanks a lot,lotsaram.
Actually there are some bad feeders in rule file.I notice that one team-member removed those bad feeders and server is going to back to be normal.