How to create cube through code

Last Post 24 Mar 2006 12:24 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ritesh.singal
New Member
New Member

--
22 Mar 2006 10:24 PM
Hello!!!

I want to create cube through vb or java code.
I want to create new cube.
I am having MS-SQL as backend.
For eg. There is a company database, and having tables as Employee, Department etc.
I want to create new cube as EMP which has dimensions as dno, age, sex etc.
And Measures as Salary.
Currently there is no cube for this database.
So I have to create new cube as well as process it through vb or java code.
Is there any commands like CREATE CUBE, CREATE DIMENSIONS, CREATE MEASURES, PROCESS CUBE.

I have found CREATE LOCAL CUBE and CREATE GLOBAL CUBE but they work on existing cubes only.
I want to create new cube on server.

I want to know if it is possible or not?
If it is possible then HOW?

Thanks
SQLUSA
New Member
New Member

--
24 Mar 2006 12:24 AM
This is usually done by Analysis Services manager.

It is difficult to create it, process it and debug it remotely. Not impossible though.

Kalman Toth, Database, Data Warehouse and BI Architect
http://www.sqlusa.com/orderdoubleheader/
The Best SQL Server 2005 Training in the World
You are not authorized to post a reply.

Acceptable Use Policy