Is it possible to have an OpenOffice base OLAP cube on Spreadsheet?

Asked By Michael E Owensby 20 points N/A Posted on - 04/21/2013

Hi Techs!

I have this issue which is bugging me.

Is it possible to have an OpenOffice base OLAP cube on their OpenOffice spreadsheet?

I would like to have a spreadsheet where I can carry out some online data analysis and reporting; yes, it is more like a 3D spreadsheet.

I appreciate your help.

• Status: Open
• Question Views: 1002
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Internet Development

Best Answer by Elmer Cook

Go To Solution

Answered By Brown Dubin 5 points N/A #173331

Is it possible to have an OpenOffice base OLAP cube on Spreadsheet?

Hello,

That is quite a very uncommon implementation in openoffice but i have a simple and easiest way you can do this. You have to activate datapilot datasource and then openoffice will do the rest automatically for you, datapilot is a great tool that can be used to analyze data in openoffice.

You can also visit the openoffice developer guide manual for more coding.

About Brown Dubin

Questions
1

Answers
20

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 04/26/2013
• Question Category: Internet Development

Best Answer

Best Answer

Answered By Elmer Cook 0 points N/A #173332

Is it possible to have an OpenOffice base OLAP cube on Spreadsheet?

 

Michael

It is possible for you to have this 3d or 2d in your open office spreadsheet. I would provide you a manual on how to do this and for you to have a better understanding on how to create it, what kind of techniques and graphs will you be using. Just read carefully cause every small detail is very important.

 

Click this link for 1st solution

 

Click this 2nd link for additional info

About Elmer Cook

Questions
0

Answers
100

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 11/24/2013
• Question Category: Internet Development