Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Course Of The Month
7 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
PowerPivot file setup
Posted on 2013-12-10
I have a lot of data I want to work with in PowerPivot 2013.
I'm not sure what approach would be the best to initially pull the data.
I have 3 databases on 2 servers.
Table company server Join Final join
Sales Header A A 1A Sales Header
Credit Header A A 1A Sales Header
Sales Header B A 2A Sales Header
Credit Header B A 2A Sales Header
Sales Header C B 3A Sales Header
Credit Header C B 3A Sales Header
Sales DETAIL A A 1B Sales Detail
Credit DETAIL A A 1B Sales Detail
Sales DETAIL B A 2B Sales Detail
Credit DETAIL B A 2B Sales Detail
Sales DETAIL C B 3B Sales Detail
Credit DETAIL C B 3B Sales Detail
I need 20-25 fields out of each table where there are 75-100 fields.
The Sales & Credit files need to be combined first to get all sales.
Then those combined for each company.
Should I build views 1st to combine the data in each company on each server?
Or a suggestion?
This is all new and I'm kind of jumping in with both feet, so please excuse if this seems like a simple question to you.
I'm not sure what approach would be the best to initially pull the data.
I have 3 databases on 2 servers.
Table company server Join Final join
Sales Header A A 1A Sales Header
Credit Header A A 1A Sales Header
Sales Header B A 2A Sales Header
Credit Header B A 2A Sales Header
Sales Header C B 3A Sales Header
Credit Header C B 3A Sales Header
Sales DETAIL A A 1B Sales Detail
Credit DETAIL A A 1B Sales Detail
Sales DETAIL B A 2B Sales Detail
Credit DETAIL B A 2B Sales Detail
Sales DETAIL C B 3B Sales Detail
Credit DETAIL C B 3B Sales Detail
I need 20-25 fields out of each table where there are 75-100 fields.
The Sales & Credit files need to be combined first to get all sales.
Then those combined for each company.
Should I build views 1st to combine the data in each company on each server?
Or a suggestion?
This is all new and I'm kind of jumping in with both feet, so please excuse if this seems like a simple question to you.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active 4 days ago
Yes, I recommend creating a view in each database that has exactly what you want--especially if each view uses multiple tables. Make all three views contain the same column headings in the same order. Then you can use Power Pivot to combine the 3 views into 1 pivot table. I would also add a "tag" column to each view so you know where the data originated.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month7 days, 8 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.