April 16, 2012 at 5:02 pm
I have an .xlsx file consisting of four worksheet tabs. Each worksheet contains a different pivot table. All four pivot tables are based on the same SQL Server 2008 R2 view. All four pivot tables work as they should. However, I now need a "server-based" solution instead of giving the various users their own copies of my .xlsx file. How can I do this? I've researched SSRS, but I don't think their Matrix will work for me due to the report filters I have in the pivot tables. I researched SSAS, but can an SSAS cube be based on a simple relational SQL Server view? I'm so confused at this point.
April 17, 2012 at 12:59 am
You can build SSAS on top of SQL Server views. You need however to create facts and dimensions in SSAS.
But Excel can pivot very nicely on top of a SSAS cube.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2012 at 10:14 am
This is good news! How about if I want to user to pivot using something web based? Can I put an SSAS cube on SSRS using the Report Server?
April 17, 2012 at 1:33 pm
imani_technology (4/17/2012)
This is good news! How about if I want to user to pivot using something web based? Can I put an SSAS cube on SSRS using the Report Server?
SSRS is used to build static reports.
You'd want to put the SSAS cube on it's own SSAS server and let end users connect to this cube using Excel.
In Excel, go to the data tab, click on From Other Sources and you'll see SSAS in the list.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 18, 2012 at 11:18 am
Here's the problem: my boss wants the pivot tables to be web-based, not Excel. He wants users to essentially be able to access pivot tables identical to the ones I have created in Excel without the users actually using Excel.
Help?
April 18, 2012 at 1:18 pm
Use Excel Services in SharePoint. Exactly the same as Excel, but users don't need to have Excel/Office installed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply