Re: olap for client

#.
One more thing,

Did you installed service pack 2 for SQL Server?
Excel 2007 is required sp2 to use some feature.



Nedim wrote:
I tried that (I'm using Excel 2007) and unless I need to download some additional drivers for Excel 2007, I dont know what I'm doing wrong - he gets the sql server address, username and password (which work when i use connect to sql server, but not when connecting to as) and then reports no server, and on that server I regularly browse my cube within visual studio

"Jeje" wrote:

to connect excel to your OLAP Server:
1. make sure you have installed the OLAP drivers (the drivers for AS2000 are installed with Excel 2003, for SSAS 2005 download and install the client driver from the feature page)
2. open excel and add a pivottable (excel 2003) and connect this pivottable to an external datasource and select the OLAP tab instead of the database tab
3. create a new connection to your OLAP server and enjoy!

in Excel 2007 the interface is different but the process is near the same
1. go in the data tab
2. click "from other sources" and select "From analysis services"
3. follow the wizard to connect excel to your cube

you can search on the web to find Excel plugins, applications or controls which can be connected to a cube.


"Nedim" <Nedim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BF9C21F5-2CCC-4300-9092-15A2AAF87B41@xxxxxxxxxxxxxxxx
sorry for newbie question, i'm a beginner in olap.
after reading a manual, i created a data warehouse db, succesfully created a
cube in analysis services, and i can impress everyone with cube browser in
the ide (a visual studio view of cube in the project - the one where i just
drag dimensions, measures, and maybe filters.

is there any way i can expose this kind of control to the user, via a some
.net control or something like excel, so users can make their own reports -
drag dimensions and measuers they need, and possibly filters.
i tried connecting excel to olap server and it didnt work (i can connect to
sql server database from excel with ip address and db name, but the same
doesnt work with analysis services)
thanx in advance :)

nedim
.

Relevant Pages

  • Re: SSIS and unicode data types
    ... my varchar columns are at most 50 characters. ... destination column in the SQL database destination is only varcharor ... How do I get an Excel column of datatype ... It left SQL Server as a VARCHAR and went into Excel, ...
    (microsoft.public.sqlserver.dts)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Excel 2007 connection
    ... The Feature pack also contains the SQL Server Client ... You should install it. ... so I installed them both as I do for Excel 2003. ...
    (microsoft.public.sqlserver.olap)
  • Re: Trasfer data to SQL Server
    ... Do you know how you would execute the DTS package from excel? ... Currently Using SQL Server 2000, ... This will place a SQL Server icon onto the DTS ...
    (microsoft.public.excel.programming)
  • Re: Newbie: Update From Excel
    ... Add an Excel Connection. ... Point it to your SQL Server ... Now create a transform data task coming from the Excel Spreadsheet to the ...
    (microsoft.public.sqlserver.dts)