How do I know where the data is and what tables are linked to each other. For instance if I want a deparmental budget for each department and I want to do it isn SSRS or tableau how do I migrate the date to a reporting database?
There are many ways to migrate data to reporting database, important thing is to know from where and what data you need to migrate. Install GP SDK it has documents to get idea of tables.
GL00200 is a Budget MSTR table
GL00201 is a Budget Summary table
got what?
You need to know how to use SSMS. For the tables you can install the GP SDK. You will find this in the install media.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148