Solved

PowerPivot file setup

Posted on 2013-12-10
1
330 Views
Last Modified: 2013-12-27
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.
0
Comment
Question by:actsoft
[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
 
LVL 2

Accepted Solution

by:
mike247 earned 500 total points
ID: 39711733
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question