Thanks for the reply. Seems most of the examples are all SQL, not MDX.

Greg E

SQL 2000 or SQL 2005?

In 2005, open up the Reporting Services Configuration.

Make sure all the settings are configured.

In 2005, changes to services should always be done through these utilities.

Greg...

We're on x64 bit SQL 2005. We went from a Dual Proc server to a Single Quad Core server and time to build our cube was very similar - but...

And I believe that credentials get cached in Excel. Which would make Reporting Services a better option. We do a lot against the cube - saves us a lot of...

You may want to take a look at Reporting Services.

Greg E

I don't know of any real detailed description of this. When we were looking at what our options were with Reporting Services, the consultant outlined a custom forms based similar...

I would recommend build a new cube from scratch for several reasons.

When we tried migrating, there were quite a few things that we had to fix as they did not...

sad, but true. 'All in the box' for one price is 'all on one server, one proc'

But depending on how you plan on using RS, you may be able to...

It sounds like they installed RS but did not Configure it. This is an option during install of SQL Server, and necessary if installing the web site on one server...

Kerberos is used to authenticate using the windows credentials. It is used to hop between servers. We have the web application on a separate server from SSAS, and SQL on...

I agree that security should start back at the Cube. Secure Data at the source whenever possible. It's your first chance to implement security.

Be aware that granting access to Everyone...

I'm almost looking forward to the day they cancel me. For 3 months running, they've messed up my bill. Every month, they assure me that they've fixed the problem. Maybe...

Mark -

Similar to what Michael is explaining, we build a Fact table for certain things we wish to measure. When we invoice a Sales order, we capture several key pieces...

Louis -

The main reason I use Kerberos is to make the hops between our web servers and the sql and analysis services. NTLM cannot make the hop.

Greg E

Louis -

Usually a Domain Administrator Account would not be trusted for delegation. This would be a very bad account to use. The SQL / SSAS machine also has to be...