OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

connecting to analysis services

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
The_Wolfpack
Power User
Power User


Joined: 27 Mar 2007
Posts: 53

PostPosted: Thu Sep 04, 2008 11:33 pm    Post subject: connecting to analysis services Reply with quote

Hi,

does anyone know a way to connect openoffice to an analysis service?
I want to connect calc to my analysis server so the users are able to make pivot tables with the data in the analysis service.

thanks in advance
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Fri Sep 05, 2008 5:27 am    Post subject: Re: connecting to analysis services Reply with quote

The_Wolfpack wrote:
Hi,

does anyone know a way to connect openoffice to an analysis service?
I want to connect calc to my analysis server so the users are able to make pivot tables with the data in the analysis service.

thanks in advance


What is an analysis service?

Do you mean that you want to be able to download data so that the user can analyise it?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Sep 05, 2008 5:40 am    Post subject: Reply with quote

If "analysis service" can be translated to "database accessible via odbc" then you can setup the service as odbc-source, connect a Base document to that source, register the database and create pivot tables (data pilots) from the registered datasource.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org


Last edited by Villeroy on Fri Sep 05, 2008 5:41 am; edited 1 time in total
Back to top
View user's profile Send private message
The_Wolfpack
Power User
Power User


Joined: 27 Mar 2007
Posts: 53

PostPosted: Fri Sep 05, 2008 5:41 am    Post subject: Reply with quote

No, analysis service is a microsoft BI thing.
I don't really know what it does, but in excel 2007 you have the possibility to connect to that service and then you are able to select a cube.
If you've selected a cube you see all the measures and you're able ta make pivot tables with them.

Now I would want to to the same in OpenOffice.

thanks
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Sep 05, 2008 5:42 am    Post subject: Reply with quote

Quote:
microsoft BI thing.

Proprietary solutions require proprietary software.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
The_Wolfpack
Power User
Power User


Joined: 27 Mar 2007
Posts: 53

PostPosted: Mon Sep 08, 2008 12:44 am    Post subject: Reply with quote

And no work around?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Sep 08, 2008 3:34 am    Post subject: Reply with quote

Chances are small that anybody here has anidea what a "BI thing" or "analysis service" by Microsoft is. You do not even provide a link. If that service can be seen as some kind of database (source of tabular data) and Microsoft offers som standardized interfaces via ODBC (to be setup in the Windows system panel) then you could at least read the data through that odbc driver, represent it in Base and use it in Calc and Writer.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
The_Wolfpack
Power User
Power User


Joined: 27 Mar 2007
Posts: 53

PostPosted: Tue Sep 09, 2008 11:44 pm    Post subject: Reply with quote

I'm sorry,

analysis service is a business inteligence tool for sql server.
It is used for datawarehousing and reporting.
simply put it presents the user with cubes (facts and dimensions) and measures.
This allows users to make custom reports in the form of pivot tables.

Now i can connect to the datawarehouse, but this is something a user shouldn't do.

And I think you're right, I can't find anything on this subject. so I guess it really is not possible

greetings
and thanks again for your answers
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Sep 09, 2008 11:53 pm    Post subject: Reply with quote

At least MS SQL server provides odbc drivers. So you can create pivot tables from the raw database data in Calc. But I doubt that you can access the output of the analysis tool (I would not expect that from Microsoft). Well, common export formats such as plain text (*.csv) or dBase (*.dbf) may be an option.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
kle_py
Newbie
Newbie


Joined: 11 Sep 2008
Posts: 1
Location: Paraguay

PostPosted: Thu Sep 11, 2008 6:24 am    Post subject: Reply with quote

If this would be possible with OOO it would be very interesting for me too !
In http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en You can find Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider which enables connection to Analysis cube from Excel (2003 version at least), however keeps "invisible" in OOO.
Since we are using in our company a BI project based on this tecnology, would be nice to have an alternative front-end at least.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group