You can use basic or anonymous authentication, but it requires you to configure SSAS for HTTP access, along with providing a windows user for the customer. For anon authentication, windows...

There are also "Progress Begin", "Progress Current", and "Progress End" events thrown by the SSAS instance. These are the events captured by BIDS/SSDT-BI when reporting processing progress events when you...

If you process a cube through SSIS you can also observe the amount of time to process a cube by the log. If using SSIS 2012 you can check...

Grant, I agree regarding performance--no doubt about it.

In my case, in the two cases where the DWH fact table had no FKs, the fact tables existed for the...

Was this billing application implemented on the payer end, provider end, employer end, third party administrator end, or some other end?

I would use the most recent effective date from the source system, but also try to talk to the source system DBAs to make sure there is not an Audit...

In the world of BI it is very common in dimensional design to know both the physical primary key of a target dimension table and the logical equivalent business key....

Easiest SSC question in AGES. Thx SJ.

SSRS is usually the first to be scaled out, THEN SSIS, THEN SSAS. Use the Analysis Services Performance and Operations guide to make your final decision.

EDITED MY POOR GRAMMAR AND TYPOS!

SQL Server 2008 Anaysis Services Unleashed is written by the original folks from Panorama, the company purchased by MS that created the SSAS engine. However,...

If this is an OLTP system, absolutely use FKs. However, there are some highly respected data warehouse pundits out there that believe foreign keys, in an OLAP fact table and...

If you are on SQL 2005, then use that document; otherwise, quite a few enhancements have been made to the SSAS Engine since then. There is now a consolidated Analysis...

Oh yes.....special thanks to Greg Galloway, SSAS Maestro, for validating my submissions.

I'll try to have some submissions on SSAS Multidimensional and Tabular security along with Multidimensional Actions/Drillthrough in a few weeks.....maybe mix in a few data mining doozies in there too....

My pleasure folks. I am trying to increase the number of BI questions on QotD even if I may getting laid off in 90 days--HAHA--in which case you may...