May 30, 2012 at 6:55 am
I have never worked with MS Analysis Services Database.. but I have been asked to pull some data out of the cube. Now I have gone into Visual Studio, and connected to the cube... I have even been able to create something called 'Named Query', the problem is how do I then get the data out? When I run the query, in the design window (at least I think that is what I am in), it will not let me copy and paste the results out (now given the number of rows that is not a supprise).
There is not a 'Named Query' section in MS Management Studio.. when you open up the database. I think I need a select statement in MS Management Studio, to do a Select Insert.. so I can get the data to a place where I can export it out.. 20mil rows.
May 30, 2012 at 9:07 am
First, there is a separate forum for Analysis Services. You are more likely to get an answer to your question there.
The cube browser in BIDS (Visual Studio) is a rudimentary UI to verify the results of processing the cube. You should be using another tool (such as SSMS) to run actual queries on the cube. I'm able to copy results from SSMS.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
May 30, 2012 at 1:21 pm
Thanks.. I did open up a thread there..
May 30, 2012 at 1:33 pm
Name Queries are usually defined against the OLTP source that the OLAP cube is built on. The named query will use T-SQL, but the cube will use MDX. If you are running the T-SQL query on your cube, you won't get any results. (In fact, I would expect you to get error messages.)
Please direct all future response to the thread in the Analysis Services forum. http://www.sqlservercentral.com/Forums/Topic1308562-17-1.aspx
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply