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

DataPilot - Excel X Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
William Longo
Newbie
Newbie


Joined: 06 Feb 2008
Posts: 3

PostPosted: Wed Feb 06, 2008 11:03 am    Post subject: DataPilot - Excel X Calc Reply with quote

Hi, I have a problem.
I need to convert the OLAP application that I have in Microsoft Excel TO Open Office CALC.

I don't have idea how I make it in Calc, but I saw the option in datapilot "external source/interface". I think it is for connect in Olap database but this option i disabled.

I need know how I enable it. Anybody have idea?

thanks,
Will
Back to top
View user's profile Send private message
ms777
Super User
Super User


Joined: 07 Feb 2004
Posts: 1355

PostPosted: Wed Feb 06, 2008 1:31 pm    Post subject: Reply with quote

Hi,

this post may be better in the Base forum.

Probably you will have to register your OLAP as a OpenOffice DataSource

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


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Feb 06, 2008 2:31 pm    Post subject: Reply with quote

ms777,
The first dialog you get from Data>Pilot>Start... offers 3 options:
1. from range selection
2. from data source
3. External source/interface (tool tip:OLAP)
Help wrote:

External source/interface
Opens the External Source dialog where you can select the OLAP data source for the DataPilot table.

Option 2 is related to the datasources imported by means of Base.
I've never read anything about OOo and OLAP or OLAP as data source. In fact, I don't know what OLAP is. As far as I understand the wikipedia, it could be something on top of other data sources.
Back to top
View user's profile Send private message
William Longo
Newbie
Newbie


Joined: 06 Feb 2008
Posts: 3

PostPosted: Thu Feb 07, 2008 2:11 am    Post subject: Reply with quote

Hi.
How can i register the my Olap as a OpenOffice DataSource?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Feb 07, 2008 2:35 am    Post subject: Reply with quote

William Longo wrote:
Hi.
How can i register the my Olap as a OpenOffice DataSource?


Nobody knows, I'm afraid. So I forwarded the question to the developers' mailing list.
Back to top
View user's profile Send private message
William Longo
Newbie
Newbie


Joined: 06 Feb 2008
Posts: 3

PostPosted: Thu Feb 07, 2008 2:46 am    Post subject: Reply with quote

I found how I register a database connection, but no how register OLAP connection.
I have a database Olap and need connect it for make my application olap using Calc.


I have a application cube olap in Excel and I need upgrade to Calc.

any idea?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Feb 07, 2008 4:21 pm    Post subject: Reply with quote

Niklas Nebel wrote:
> That third option is enabled if you have an implementation of the UNO
> service com.sun.star.sheet.DataPilotSource, for example from an
> extension. It's then up to that extension to provide the results. It
> could use an OLAP server, but I'm not aware of an extension that
> actually does so.
>
> Niklas
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