Questions tagged [olap]

I've seen tutorials articles and posts on how to build datawarehouses with star and snowflakes schemas, denormalization of OLTP databases fact and dimension tables and so on. Also seen comments like: Star schemas are for datamarts, at best. There…

(I am not a professional windows server admin and its my first time dabbling with analysis services.) I am trying to get the Analysis Services up and running such that I can fire MDX queries via XMLA. Here is what I have done so far (on a standard…

I had this same issue when trying to connect to SSAS via a MSMDPump file, as stated in this article. String reference not set to an instance of a String. Parameter name: s (mscorlib) I got the following error message when trying to connect to my…