You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

shane

Trainee

  • "shane" started this thread

Posts: 1

Date of registration: Jul 17th 2009

  • Send private message

1

Friday, July 17th 2009, 4:40pm

Worksheet Server installation issue

Hi

I am very excited about having worksheet server as part of the community edition. I have been using PALO for about 8 months now. I have just installed the commnity edition. All went well, but I have bsoltely no idea how to use the worksheet server now. I can log onto the worksheet server page but there is no designer option. There is also no addin in Excell which would allow me to lad up reports. Am I missing soemething here? How do I now create reports? Please help

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Saturday, July 18th 2009, 10:16am

You are missing more quality in the software... ;)

With the WSS there is no more need for Excel designer but the "web-design" process does not work for you and me.

At least I was able to open a new worksheet. But when I try to do something with formulas. Try =LÄNGE(A1) or some other nothing happens.

And after that no more worksheet - even after a reboot.

When it works it looks very good and the specs are promising but for now I have deleted the whole thing the second time (the 1.7.09 and the 14.7.09 versions).

  • "rajaiskandarshah" is male

Posts: 70

Date of registration: Jun 23rd 2009

Location: Kuala Terengganu, Malaysia

  • Send private message

3

Monday, July 20th 2009, 6:12am

Been trying out the Palo BI Suite 3.0 Beta Linux Community Version

So far:
1. I can create workbook from the Resources tab
2. I can put text and numbers (after adding MS corefonts)
3. I can save and open back
4. I can put simple functions =A1+B2-C3 or =SUM(B2:B3)
5. I can unlock cell so that users can key in numbers and have the function calculate the result
6. Merge cells does not work after closing the workbook and opening it back
7. Number formatting sometimes do not work after closing the workbook and opening it back
8. I can share the workbook by dragging it into the Report Repository tab
9. On Firefox 2.0 it does not work

  • "rajaiskandarshah" is male

Posts: 70

Date of registration: Jun 23rd 2009

Location: Kuala Terengganu, Malaysia

  • Send private message

4

Thursday, July 23rd 2009, 7:49am

here is a guide on installing palo bi suite 3.0 community linux edition on ubuntu 9.04 netbook remix

should also be similar for ubuntu 9.04 desktop edition and ubuntu 9.04 server edition and redhat enterprise linux 5

http://software.krimnet.com/guide/guide-…tbook-remix.htm

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

5

Thursday, July 23rd 2009, 10:03am

a very nice writeup!

it might be better to change the address from 127.0.0.1 to the real IP-address of the server:
then you can reach the server from other PCs in your network

I was not brave enough to install the thing on my working Ubuntu.
I figured that the configuration of the already installed Apache web server (I need this!) gets changed in the install script.

Can you confirm this?

It could be that the whole thing installs a parallel Linux on your Ubuntu (or other distro). But I fear it messes with my running system ...

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

6

Thursday, July 23rd 2009, 11:48am

Hi axi,
your assumption is correct - the BI Suite is installed within a so-called "cage", containing all necessary libraries, and doesn't interfere with an installed Apache, for example. As you can see in rajaiskandarshah's Write-up - very nice work, by the way! - the installation script also checks if port 80 is already used and uses an alternative port in that case (you can change it later in httpd.conf, if necessary).

  • "rajaiskandarshah" is male

Posts: 70

Date of registration: Jun 23rd 2009

Location: Kuala Terengganu, Malaysia

  • Send private message

7

Thursday, July 23rd 2009, 12:18pm

Tested on my ubuntu 9.04 netbook remix and my colleagues ubuntu 9.04 desktop edition - which are on dynamic ip. This is to allow us to go back home and design the worksheet before transferring it to the live server

Before this we kept crashing the worksheet server with too many simultaneous designers). So by having people work individually before transfering to the live server, it is a little like WSS2 where people worked through MS Excel before saving, uploading and compiling on the server.

On the desktop, without apache it was not working. Only when we had apache running and re-install palo did it work. During the installation, it will also prompt whether to amend httpd conf. After that WSS works on port 85, Palo OLAP on port 7777, Apache works as normal on localhost.

You are right about palo having like a virtual machine environment . There are links to the operating system core - do not delete the pbis folder. we did this before and crashed rhel5. Recovered rhel5 by inserting installation cd1 and selecting upgrade which recovered the system back.

Since, it is on beta, I would recommend that the development and design work is done on a development machine before it is transferred to live. The Palo OLAP is OK though, no problems. Just the WSS which are giving us problems to think about.

Rate this thread