Share
ReportBefore rebuilding the Datamart - what is the best way to determine how many records will be processed during the rebuild
Categories:
You’re offline. This is a read only version of the page.
364
Before rebuilding the Datamart - what is the best way to determine how many records will be processed during the rebuild
Hi,
To add to Greg's comment, if you don't want to retrieve that many historical records into MR DataMart, try limit the quantities in your GP companies.
Only flag GP companies you're really going to report against in MR.. don't include them all, it's going to kill your DM. If you have many years of historical data, try archive your data. Since MR by design does not allow to select how many years you want to collect for DM (which is silly and a real design flaw). your only option is to remove yourself as much data from the GL30000 table as you can and only keep 3-5 years max.
ProfAd DataArchiver is a powerful ISV tool that adds to GP and allows to archive historical data from many modules in GP and still access them seamlessly from GP as if they would be in the same company, but in reality they are offloaded to an archive company (i.e. separate physical SQL database) and will no longer be used by MR's DM.
If you don't' want to spend any money on add-ons, you could simply create a full copy of your current live company(ies) and restore them into ARCHIVE (HISTORICAL) databases and strip off from your live company the old data by using the built-in GP clean-up process. The whole process provides the same result in the end as DataArchiver from ProfAd, just a little more work involved in the whole exercise, and the inability of querying the data from a single company, unless you write your own SQL views to join DB's.
You can run a select count statement on the GL20000 and GL30000 table to get an idea of how many transactions there. That's where the bulk of the records will come from. MR is also pulling in fiscal periods, budgets, and accounts. But most of the records will be transactions. That's the last thing that it adds.
You could run these against each of the company databases:
select count (*) from GL20000
select count (*) from GL30000
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (