Home / server / Questions

Questions[olap](server)

Martin Hope
David Rogers
Asked: 2021-02-02 16:49:53 +0800 CST
  • 0

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 MSMDPump.dll via SSMS:

enter image description here

This when I tried to connect via excel:

enter image description here

When I examined the Event Log on this server I would see "Audit Failures":

enter image description here

windows sql analysis olap
Martin Hope
amol
Asked: 2011-07-24 23:39:18 +0800 CST
  • 0

(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 "windows 2008 with sql" ec2 instance. IIS 6.1)-

  • Got the sample AdventureWorks cube up and running. I can locally fire MDX queries and it works.
  • Followed this link to get HTTP access to Analysis Services. (The only deviation is that in my case I see only rows 1,2,5 from figure 11)
  • Can successfully connect to http://localhost/olap/msmdpump.dll from SQL Server management studio and fire XMLA EXECUTE commands with basic MDX queries.

Problem

  • I am unable to to access this from a host other than localhost. I can access http://servername just fine (default IIS page) but http://servername/olap/msmdpump.dll gives me a 500 from any host other than the server itself. (I get the expected soap envelope with soap fault from a browser on localhost)

Thanks in advance for any suggestions/solution you may have.

windows-server-2008 sql-server sql-server-2008 iis olap
Martin Hope
Paul
Asked: 2010-04-16 09:32:25 +0800 CST
  • 5

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 is absolutely no way a true enterprise data warehouse could be represented in a star schema, or snowflake either.

I want to create a database that will server for reporting services and maybe (if that isn't enough) install analisys services and extract reports and data from cubes.

My question was : Is it really necesarry to redesign my current database and follow the star/snowflake schemas with fact and dimension tables ?

Thank you

sql-server sql-server-2008 olap