Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Building OLAP cubes off of a MySQL database

Status
Not open for further replies.
JeremyCionca

JeremyCionca

MIS
Oct 16, 2000
4
0
0
US
Has anyone out there had any success in this area? We are currently using MSOLAP as our OLAP engine but it doesnt seem to want to play nice with MySQL. Under a MOLAP scenario, our MySQL server runs out of memory trying to process the cube. Under a ROLAP scenario, we get an error stating "The MySQL data source does not support data definition language (DDL) inside a transaction" and the cube fails. Any suggestions would be greatly appreciated.

Jeremy
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
135
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
115
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
84
spamjim
spamjim
Colin Burton
  • Locked
  • Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
61
Colin Burton
Colin Burton
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
126
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top