I have read the following post from Clement which is a great Post but I get to :

) click Publish
5) publish location = /samples/analysis
6) web publish url = http://localhost:8080/pentaho/RepositoryFilePublisher
7) publish password = the one you put in the xml file
8) depending on pentaho_demo version you use : v1.60.GA.863 server userid = joe ; v1.21.GA server userid = pentaho_user
9) server password = password
10) ok

and I am getting "Publish failed: verify your login and publish password and make sure BI Server is running"


Note that we are trying to connect using mysql demo sample DB and the server is running as the star-pentaho.bat file has been launched and I can access the web portal:
http://localhost:8080/pentaho/Login

This connection test is happening from CubeDesigner -0.7.2.0

Application installed on local machine:

CubeDesigner-0.7.2.0_Win32
pentaho_demo_mysql5-1.6.0.GA.863
pentaho_solutions-1.6.0.GA.863
PentahoReportDesigner-1.2.0.219-RC2

We tried to use joe/password or pentaho_user/pawword to connect and modify the publisher_config.xml file in C:\...\pentaho_solutions-1.6.0.GA.863\pentaho-solutions\system to add the publish password.

What do I need to do to get the application to be able to publish my OLAP cube



Hi,

This is a Cube Designer
QuickStart guide for
-Cube Designer v0.7.2.0
-Windows XP SP2 / Windows Vista Ultimate

Purpose : running a sample with Cube Designer.

Note : this is not a final guide, I will update it as soon as I think it needs to be.

Introduction

This guide use Pentaho-demo as Pentaho server for Cube Designer.

A. Install the last Java JDK

e.g. jdk-6u2-windows-i586-p.exe

B. Make the JAVA_HOME to point to the jdk directory.

B.I.Verify if it already does

Start
Run
Cmd
Ok


Code:
echo %JAVA_HOME%
c:\Program Files\java\jdk1.6.0_02\

B.II.Set the JAVA_HOME if it does not

Right click Workstation(XP)/Computer(Vista)
Properties
Advanced System Properties
Environment variables
Click New in System variables
Type JAVA_HOME in the field "Variable name"
Type c:\Program Files\java\jdk1.6.0_02\ (your path to java jdk) in the field "Variable value"
Ok
Restart Session

C. Get/ Install / Configure Pentaho-demo

0) download the last pentaho-demo e.g pentaho_demo-1.2.1.625-GA.zip
or with my "package" Pentaho-Demo1.2.1.Ga_with_cubedesigner0.7.2_and_jdk1.5.0_1 1.Zip
1) unzip pentaho-demo (package will do in \Program Files\pentaho-demo_ directory).
2) edit start-pentaho.bat to adapt it with your environment. Sample :


Code:
@echo on
setlocal
set PENTAHO_PATH=I:\clement\autres\pentaho-demo
set PATH=%JAVA_HOME%\bin
cd %PENTAHO_PATH%\data
i:
start start_hypersonic.bat
cd ..\jboss\bin
start run < lines.txt



D.Install Java Development Kit 1.5


1) download it, e.g. jdk-1_5_0_06-windows-i586-p or with my package : Pentaho-Demo1.2.1.Ga_with_cubedesigner0.7.2_and_jdk1.5.0_1 1.Zip

E. Get / Install / Configure Cube Designer


E.I.Download the last Cube Designer


e.g. CubeDesigner-0.7.2.0_Win32.zip or with my package Pentaho-Demo1.2.1.Ga_with_cubedesigner0.7.2_and_jdk1.5.0_1 1.Zip

E.II.Unzip cube designer v0.7.2.0

Package will do in a \Program Files\CubeDesigner\ directory.

E.III.Create a shortcut for CubeDesigner.exe which will run with java jre1.5.

->included in package under \Program Files\CubeDesigner\. Jump to next part if you are using my package.

Go in your shortcuts favorite place
Right click
New
Shortcut
Target :


Code:
C:\pentaho\CubeDesigner\CubeDesigner.exe -vm "C:\Program Files\Java\jre1.5.0_11\bin\java.exe" -clean -ws win32

Name : CubeDesigner

E.IV.Configure database connections

Search for jdbc.properties in the pentaho-demo folder
e.g. ...\pentaho-demo\pentaho-solutions\system\simple-jndi\jdbc.properties
copy its content in the clipboard
Run and close immediatly CubeDesigner for jdbc.properties file to be created empty.
search for jdbc.properties in the cube designer folder
e.g. ...\CubeDesigner\resources\system\simple-jndi\jdbc.properties
paste the clipboard content in this file. Sample :


Code:
SampleData/type=javax.sql.DataSource
SampleData/driver=org.hsqldb.jdbcDriver
SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
SampleData/user=pentaho_user
SampleData/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=org.hsqldb.jdbcDriver
Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Quartz/type=javax.sql.DataSource
Quartz/driver=org.hsqldb.jdbcDriver
Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
Quartz/user=pentaho_user
Quartz/password=password
Shark/type=javax.sql.DataSource
Shark/driver=org.hsqldb.jdbcDriver
Shark/url=jdbc:hsqldb:hsql://localhost/shark
Shark/user=sa
Shark/password=

E.V.Search for publisher_config.xml in the pentaho-demo folder

e.g. ...\pentaho-demo\pentaho-solutions\system\pûblisher-config.xml

E.VI.Edit publisher_config.xml to add a password in it.

Sample :


Code:
<?xml version="1.0" ?>
- <!-- This file must be configured before client tools
will be able to publish onto the server. Publishing
involves accepting a file (action sequence, xml document,
anything) and placing it into the solution. This
action should only be allowed if the tool is configured
with a server/deployment specific password. The
RepositoryFilePublisher is now coded to expect an MD5
hash of the password entered here before it will allow
publish into the server.

This is a critical security measure designed to prevent
malicious actions from being published into your server.
Please take care to make the password sufficiently
difficult to guess. Also take care that the contents of
this file are not generally available
--> f(clean);
- <publisher-config>
<publisher-password>admin</publisher-password>
</publisher-config>

E.VII.Get the Cube Designer User Guide

http://downloads.sourceforge.net/mon...8&big_mirror=0

F.Run Cube Designer

F.I. Before 1st screen

1) run start-pentaho.bat
2) open a browser to http://localhost:8080/ to check it's running.
3) run the shortcut to CubeDesigner.exe with jre1.5
4) open Pentaho_Cube_Designer_User_Guide_0_7_0.pdf

F.II.1st screen "Start Here"
1) File / New
2) Cube Name=CubeName NO SPACE IN THE NAME
3) Cube Description=Cube Description
4) Select SampleData
5) Click Next

F.III.2nd screen "Map Tables"
1) select Tables in the right list
2) select public in the left list
3) select the tables like in the PDF :
orderfact,
customer_w_ter,
time.
4) make the same links than in the doc, tick the same boxes + the ones which are highlighted in the doc :
-links :
--orderfact.customernumber with customer_w_ter.customernumber
--orderfact.time_id with time.time_id
5) Click Next

F.IV.3rd screen "Create Measures"
1)select ORDERFACT in Fact Table
2)select TOTALPRICE
3)click ==>
4)click next

F.V.4th screen "Create Dimensions"
0) select customer_w_ter.CUSTOMERNAME
1) clic "Add New Dimension"
2) name=Customer
click "Ok"
3) configure the dimension
name=CustomerName
nameColumn=CUSTOMER_W_TER.CUSTOMERNAME
uniqueMembers=false
4) add the time dimension
time.year_id -> time.quarter_name -> time.month_name
5) configure the dimension NO SPACE IN THE PROPERTY NAME
6) click Next

F.VI.5th screen "Final Steps"
1) click View XML
2) replace the last datatype="String" with datatype="Numeric" :
i.e. replace


Code:
<Measure name="SUM of ORDERFACT.TOTALPRICE" column="TOTALPRICE" aggregator="sum" datatype="String" formatString="Standard"/>

with


Code:
<Measure name="SUM of ORDERFACT.TOTALPRICE" column="TOTALPRICE" aggregator="sum" datatype="Numeric" formatString="Standard"/>

3) close
4) click Publish
5) publish location = /samples/analysis
6) web publish url = http://localhost:8080/pentaho/RepositoryFilePublisher
7) publish password = the one you put in the xml file
8) depending on pentaho_demo version you use : v1.60.GA.863 server userid = joe ; v1.21.GA server userid = pentaho_user
9) server password = password
10) ok
11) Finish
12) Save location=c:\mycubes\ for example
13) save and close

G.Verify the sample created
0) restart pentaho server with pentaho-stop.bat or by closing server windows 1) go to http://localhost:8080
2) click Navigate
3) click Solutions
4) click Sample Analysis (last line) / Exemples d'analyse
5) click CubeName
nb : If you see a space in the cube name, it won't work.

If anyone has any problem to follow this guide, please tell me so that I update it.

Hoping this helps,