Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
COURSE of the MONTH
11 days, 11 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
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
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
New style of hardware planning for Microsoft Exchange server.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month11 days, 11 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.