Hi Oliver and all, About DataPilot, I am puzzled. There are several questions which I want to ask for your help. TIA
Firstly, Data - DataPilot - Start - External Source/Interface on Select source dialog is deinactive. so, what can I do to make External Source/Interface do on Select source dialog deinactive? Should I install third part drivers or sth. else? Marek Brezina had asked the similiar question and subject is "[users] OLAP and external data", and CPH had answered his question as follows: On Monday 08 March 2004 08:16, wrote: > Hello, > I tried to look for this in archives and didnt find (or very old > themes), so my question is. > How can I connect DataPilot to OLAP server (or cube)? > Is this feature already implemented? On Wednesday 04 February 2004 19:14, Niklas Nebel wrote: > G. Roderick Singleton wrote: > > It will be up to the user to determine whether or not he can apply this > > technology vi OOo. In other words, OOo is NOT a OLAP tool but may be > > able to be configured to support some of what is needed. > > The "External source/interface" option in the DataPilot source dialog > allows to access external implementations of the > com.sun.star.sheet.DataPilotSource service (described in the Developer's > Guide) which provides the results shown in a DataPilot table. This is > meant to allow connecting to OLAP servers, but I haven't yet seen any > real implementation of it. After that, I still don't understand how to do to make it active. Secondly,Data - DataPilot - Start - Data source registered in OpenOffice.org - OK to open "Select Source" dialog. Would you like telling me the difference between sql and sql[native]? Thirdly,Data - DataPilot - Start - Data source registered in OpenOffice.org - OKto open "Select Source" dialog - biblio as Data source - OK - select "Type" as Page/Column/Row fields - double_click the "Type" item to open Data Field dialog, then clickoptions button to open Data Field Options, have a look at this dialogso, what can I do to make Hierarchy do on Data Field Options dialog deinactive? What's the best is to give us an example, thank you. Thank you everyone in advance! Regards! Li Meiying (Amy2008 in community) 2009-04-30
