Closed

Mondrian Schema JPivot JSPs with MDX

I have a MS SQL datawarehouse and wish to use the Mondrian open source OLAP server with JPIVOT for analysis.

I have one fact table containing 8 measures.

Actual Sales MTD

Forecast MTD

Variance (Actual/Forecast MTD)

Actual Sales Last Year Same Month

Actual Sales YTD

Forecast YTD

Variance (Actual/Forecast YTD)

Actual Sales Last Year YTD

The fact table contains 3 different record types, F for Forecast, S for Sales, O for Orders (not used in this)

I have 4 related dimension tables.

From dimension table Dim_CustomerGroups we can get the “Customer group Name??

From dimension table Dim_ProductGroups we can get the “Product group Name??

From dimension table Dim_Customers we can get the “District name?? (Region)

From dimension table Dim_SalesOrganisation we can get “Salesperson name??

I need 5 JSP files (1 index) containing JPIVOT tags with MDX queries. One JSP for each drill down.

All/Division/REP/Product

All/Division/Product Group/Item

All/Division/Customer Group/Customer/Item

All/Division/Region/Rep

## Deliverables

1. I need a .war file which can be installed automatically into Tomcat 5.5.

a) this needs the required .jar files (open source ones included)

JPIVOT, MONDRIAN, JTDS 1-2 (ms sql driver)

b) others clearly identified.

2. The web application will consist of

a) An index page with links to each JPIVOT page

b) 4 JSP pages with JPIVOT tags and MDX queries to match OLAP needs defined above.

3. Documentation

a) detailed explanation of the [url removed, login to view] schema definition file

b) detailed explanation of the JDBC connections

c) any other documentation deemed appropriate

## Platform

Tomcat 5.5 webserver running on windows platform

Microsoft SQL server 2000 DB

Skills: Apple Safari, Engineering, Google Chrome, Java, MySQL, PHP, Software Architecture, Software Testing, SQL, Web Hosting, Website Management, Website Testing

See more: with explanation, jdbc in jsp, get sales rep, need a salesperson, variance, schema, open source analysis, olap, java jdbc, i need a salesperson, i need a sales rep, java jar application, schema sql, java webserver, xml webserver, sql table analysis, java windows jar, php jdbc, sql table sales month year, windows jar

About the Employer:
( 0 reviews ) United States

Project ID: #3753152

2 freelancers are bidding on average $723 for this job

mariusmunteanu

See private message.

$1020 USD in 14 days
(6 Reviews)
4.0
inzvw

See private message.

$425 USD in 14 days
(2 Reviews)
1.3