Viewing 15 posts - 1,426 through 1,440 (of 1,457 total)
Thanks for the reply. Seems most of the examples are all SQL, not MDX.
December 10, 2007 at 6:16 am
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.
November 30, 2007 at 6:40 am
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...
November 27, 2007 at 6:16 am
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...
November 6, 2007 at 9:54 pm
You may want to take a look at Reporting Services.
November 5, 2007 at 7:22 am
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...
October 25, 2007 at 7:39 am
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...
October 23, 2007 at 6:18 am
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...
October 11, 2007 at 7:34 am
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...
October 11, 2007 at 6:56 am
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...
September 30, 2007 at 10:18 am
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...
September 20, 2007 at 8:41 am
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...
September 5, 2007 at 8:28 am
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...
August 8, 2007 at 6:55 am
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.
July 31, 2007 at 8:03 am
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...
July 30, 2007 at 9:47 am