tag:blogger.com,1999:blog-268736241887032504.post4220353072133703333..comments2011-05-30T18:28:59.497-07:00Jivtesh Singhhttp://www.blogger.com/profile/09314498953058276237noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-268736241887032504.post-33995125831173559332011-05-30T18:28:59.497-07:002011-05-30T18:28:59.497-07:00Hi,<br /><br />MSGP version10, frx6.7 sp11<br />What if i have a lot of AA frx entities and would like to rebuild indexes for only 1 company, how will I know the entity number of such company?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-268736241887032504.post-35927997812860544012010-04-27T05:44:49.202-07:002010-04-27T05:44:49.202-07:00Chad,<br /><br />Thanks for your input!Jivtesh Singhhttp://www.blogger.com/profile/09314498953058276237noreply@blogger.comtag:blogger.com,1999:blog-268736241887032504.post-44880519166366357902009-11-02T08:58:31.956-08:002009-11-02T08:58:31.956-08:00Jivtesh - I&#39;m using Dynamics AX and I opened a ticket with Microsoft Tech support several months ago and stumbled upon this solution for the slow login after turning on &#39;Rebuild Chart of Accounts&#39;. Start by verifying the &#39;Rebuild GL Index on Report Server&#39; is OFF in Report Builder, then re-run the FRx installation SQL scripts. Then re-run the dimension wizard, clear out any existing G32 files, and make sure your Update Statistics SQL procedure doesn&#39;t include any FRx tables or views (frl_). I also too the time to not include any temp tables or tables marked for deletion. That allows us to keep the &#39;Rebuild Chart of Accounts&#39; enabled which keeps our Accountants happy.Chadnoreply@blogger.com