Search results for query: *

Hi there, for my dimension "account" there are in my data source a couple of accounts which have different account numbers but exactly the same name (please don't ask what's the point in having distinct numbers with the same description, I don't know - but still, I've to deal with it). I...

yes, I am, I've already checked that. I've even assigned everyone to the OLAP administrators user group to make sure. What I don't understand is that whenever I reboot the system, there is no problem to connect to SQL server. However, when I close analysis services and restart it later on, I get...

I've reinstalled SQL Server and AS, and the same problem exists without service pack, with SP 3a and SP4. Although there must be something wrong with the installation or setup, because whenever I close AS and start it again afterwards, it is not possible to connect to the server. Error: 'no...

Hi there, one more question: I have installed SQL Server 2000 and AS (SP 4) on a new computer, and now I can't access the properties pane in the cube editor any more - which I could with the old installation. Both, the basic and the advanced pane are visible, but only in this light gray, so I...

Hi there, I would like to combine 2 tables out of my data source (currently I'm experimenting with the Foodmart-example, sales_fact_1997 and sales_fact_1998 tables) into one cube. I could make the join in Access with union all for example, but I was thinking, that there must some way in...

Hi there, I've recently started working with SQL Server Analysis Services, which so far I've learned from a very useful introduction on http://www.databasejournal.com/features/mssql/article.php/1429671. I followed all the instructions in the article and had no problems in creating a database...