Hi,
sorry for such simple question: I've just generated my first cube in
MS-SQL server 2000 cube editor and need to copy it to Excel. But I
cannot find the way how to do it. Simple CTRL+A,C,V doesn't work.

Can you advise, please?
Martin

mrazek (AT) compik (DOT) fd.cvut.cz (Martin Mrazek) wrote in message news:<dcd39e84.0404070953.36f71882 (AT) posting (DOT) google.com>...
What about setting up your local machine to have an ODBC driver that
attaches to the SQL server, then going to excel and importing from the
odbc driver?


If you have Access, I know you can connect to the ODBC, (or directly
to the SQL server) then you might be able to save to excel from there.
The Access part is a maybe though.

Usually you do not download the cubes for local use, but query the MS
SQL based OLAP cubes on the server by using Excel, or some other
front-end tool.

In the case of using Excel, you need to set up a pivot-table report
using an external OLAP data source. Pivot-table services (it's
supplied with your SQL server disks) needs to be installed on the
local PC, and you need at least Excel 2000 or preferably Excel
XP/2003. It is quite simple to set up basic reports as pivot-tables
and you there is no need for any ODBC connection, as MSAS does not
communicate via ODBC.

In case you want to download the cube for local usage go into your
pivot-table report in Excel, and open the Pivottable bar on
"pivottable". There you will find an option "off-line OLAP", to create
a local copy of some, or all of the server based OLAP database. I
suggest you read the Excel help file for more info.

One disadvantage with local cubes is that MDX calulations you have
created on the server disapear, and will not be available on the local
cube, so the local cube only has simple aggregations and hierarchies.


RE
Bjørn T





karpw (AT) epix (DOT) net (Dr. MIS) wrote in message news:<d230fb86.0404091724.201ee7c1 (AT) posting (DOT) google.com>...

I can you please expand on this statement ? Normally when you create local
cube from the server cube in Excel, all the calculations are transfered into
the local cube. In what scenario would they disappear ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================