Thanks, happycat. I couldn't find anything online explicitly saying if it possible so your confirming that you were able to set it up helps a lot. I understand the concern...

Jayanth_Kurup (8/12/2015)

---

Native comes out of the box so there is no additional cost associated.

Native is simple to use and setup

Native can be embeded in Webpages using Report viewer control

Sharepoint provides...

Yes, just using SharePoint's interface.

The interviewer might be referring to SSRS deployment modes: SharePoint Integrated vs. Native (stand-alone with IIS). If you have an SP architecture setup, using the integrated deployment method can leverage...

tresiqus (12/9/2014)

---

So I'm sitting here trying to read through the source of an .asp page because it occasionally kicks out an iis 500 error. And I've been assigned to...

Does the 70-458 exam cover the SSIS section? I got the MCSA the regular way (70-461, 462 and 463 exams) a few months back and was surprised at the number...

Well it's my first DW project and I'm doing everything solo (from requirements gathering, data modeling, ETL, reporting, self-service BI with sharepoint, etc.) so I'm more interested in getting something...

Thanks, Thomas. Trying the foreign key approach right now as it looks simpler to implement with ETL.

Thanks for the replies. As a follow-up, how about bridge tables? Normally if you would model multi-valued dimensions with a bridge table, you will have a group key and a...

Fixed the problem by comparing 1500+ lines of before and after web.config file and found out one line below existed on the old web.config file and the installation program adds...

What kind of service account are you using? Can you connect to the OLAP instance using SSMS? If it's not on a local machine, did you check your firewall settings...

What impersonation option are you using? This guide might help:

http://msdn.microsoft.com/en-us/library/ms187597(v=sql.110).aspx

I'd imagine experience matters more but a certification wouldn't hurt but that's just my opinion.

The bad news is IT jobs in general pay lower compared to the US (look up TDWI, Global Knowledge salary reports). The good news is SQL Server is more popular...

Thanks, David for your thoughts and explaining reasons why you use them. I do see the advantage of having them for partitioning purposes although you can theoretically partition by using...