| View previous topic :: View next topic |
| Author |
Message |
William Longo
Newbie
Joined: 06 Feb 2008
Posts: 3
|
 Posted: Wed Feb 06, 2008 11:03 am Post subject: DataPilot - Excel X Calc |
 |
|
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 |
|
 |
ms777
Super User
Joined: 07 Feb 2004
Posts: 1355
|
| Posted: Wed Feb 06, 2008 1:31 pm Post subject: |
|
|
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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Feb 06, 2008 2:31 pm Post subject: |
|
|
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 |
|
|
William Longo
Newbie
Joined: 06 Feb 2008
Posts: 3
|
| Posted: Thu Feb 07, 2008 2:11 am Post subject: |
|
|
Hi.
How can i register the my Olap as a OpenOffice DataSource? |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Feb 07, 2008 2:35 am Post subject: |
|
|
| 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 |
|
|
William Longo
Newbie
Joined: 06 Feb 2008
Posts: 3
|
| Posted: Thu Feb 07, 2008 2:46 am Post subject: |
|
|
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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Feb 07, 2008 4:21 pm Post subject: |
|
|
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 |
|
|
|
