Hi guys, As you might have guessed from the title, I'm really new to analysis services. I've spent the last 5 hours (crazy!) just trying to figure out what is the difference between the analysis services avail. through SSMS and business intelligence development studio avail. through visual studio? Thanks ...
How can you impersonate a windows user in a connection to an analysis server - using ADOMD.NET? Webserver is next to Analysis server, but they are not in a domain. The webservice running on the webserver needs to access the analysis server as a specific windows account. Is there something I can put in the connection string, or do I ne...
Hi, is there a way I can sort pivot-table field list (measure names, attributes) by it's caption instead of default by name defined in the cube? Eventually, can I recreate the field list by hand? ...
I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column. Something like: SELECT TOP 1 column_1 FROM table_1 WHERE «The user's selected dimentions will work as a filter» ORDER BY column_2 DESC ...
I have recently created a DataPump for connecting 2 SQL Servers together but it isn't working. Is there any way to test that the pump is working properly as I wish to eliminate from the list of possible things that may not be working? ...
Hello I have a TFS 2010 beta 2 installation on a server 2008 r2, with a full instalation of sql server 2008 developer with SP1. I want to enable the reporting capabilities of TFS, but i can't get to connect TFS with analysis services. The app Tier - Reporting - Edit Dialog keeps me saying that the analysis server cannot be reached. I h...
I've been trying to get a dropdown filter to work in Report Builder 2.0. One example of the functionality I would like is to be able to rollup money spent by state. The filter could effectively limit which states were brought back in the report. I've tried various things... the worst of which brought back an error and the report didn'...
I’m interested in knowing some different approaches for retrieving data from Analysis Services, to use in either objects in code, or for end-user reporting. I’ve used two different approaches in the past, one was using ADOMD to pull results and put these into a dataset, the other was using SQL OPENQUERY to a linked SSAS server to get r...
Hi, I read somewhere: Analysis services should run under network account Ensure SQL Browser uses a domain account Why is that? ...
Hi I have access to SQL Server at work and I've heard some interesting things that can be done with SQL Server Analysis Services. How do I know whether analysis services is running? Is it installed by default on the server? Would it be installed locally on my machine? Forgive what probably seems like a pretty dumb question, but I couldn'...
I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database" Obviously the first user has the correct permi...
I have a cube developed using SQL Server Analysis Services (2005). Its hooked up to an excel front end. At the moment users have their own logon to the reporting server and access the reports that way. However, it would be nice of they could access the reports over the web. Are there options for this? I could upgrade to 2008 if there w...
Hello, When I go to browse a cube I created in SSAS, I am getting this error: TITLE: Microsoft Visual Studio Unable to get the window handle for the 'ActionsAwarePivotTable' control. Windowless ActiveX controls are not supported. Anybody know why and how I can fix this? Thanks. ...
Hello, This is very odd; I setup a simple mining structure, and when I go to process it, I get this error. Doesn't point to the file the error is in, lists line and column as zero. What would this be related to? The ddl100_100:HoldoutMaxPercent element at line 184, column 38 (namespace http://schemas.microsoft.com/analysisservices/20...
The situation: I am generating reports using Report Builder 2.0 and a Report Model that I have created. The question: How does one sort a parameter list alphabetically? Simple question, but I can't find the answer for the life of me. Kudos to whoever can provide an answer. ...
I'm using Analysis Services and when designing dimensions I'm never sure how far to go to build natural hierarchies. What I mean is I've added in all the genuine attribute relationships. So most hierarchies are natural anyway but the most commonly requested hierarchy is 3 or more levels with a middle level as a slowly changing attribut...
I've created a cube in SSAS 2008, and have it deployed to my local server. I can connect to the cube via Excel 2007, and the pivot table and pivot chart work perfectly. When I try to drillthrough on a cell to see the detail rows, I get the following error: "The query did not run, or the database table could not be opened. Check the dat...
I'm developing a desicion tree algorithm (CHAID) to be integrated as a plugin in SQL Server 2008 Analysis Services. It is almost done. The only thing that's missing in my implementation is the capability of testing the algorithm accuracy using any of the Mining Accuracy Chart. When I try to use these features, in my Visual Studio Busine...
For the following query: with member testVal as 0.1234 member testNormal as testVal member testPrepend as testVal, format_string="%##.00" member testMidpend as testVal, format_string="##%.00" member testAppend as testVal, format_string="##.00%" select { testNormal, testPrepend, testMidpend, testAppend} on axis (0) from [SomeRandomPlace...
I'm setting up a new cube in Analysis Services, and used the Business Intelligence wizard to work out the currency conversion issues. Now this all works perfectly, money is converted at the leaf level and summed up for display in the user's choice of reporting currency. My problem now is the calculation of liability. For liability, I ne...