can Create Cube without wizard/editor?

[jepe666]

can create a cube without wizard/editor?
can using script to create it?

 

[MDXer]

you can execute XMLA scripts to create, or alter a cube.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[jepe666]

Thanks for quick reply MDXer,
can u share to me, for the example?
I have tried to using MDX with code :

CREATE CUBE [Cube_name]
(
DIMENSION Time TYPE TIME,
HIERARCHY [Fiscal],
LEVEL [Fiscal Year] TYPE YEAR,
LEVEL [Fiscal Qtr] TYPE QUARTER,
LEVEL [Fiscal Month] TYPE MONTH OPTIONS (SORTBYKEY, UNIQUE_KEY),
HIERARCHY [Calendar],
LEVEL [Calendar Year] TYPE YEAR,
LEVEL [Calendar Month] TYPE MONTH,
DIMENSION Products,
LEVEL [All Products] TYPE ALL,
LEVEL Category,
LEVEL [Sub Category],
LEVEL [Product Name],
DIMENSION Geography,
LEVEL [Whole World] TYPE ALL,
LEVEL Region,
LEVEL Country,
LEVEL City,
MEASURE [Sales]
FUNCTION SUM
FORMAT 'Currency',
MEASURE [Units Sold]
FUNCTION SUM
TYPE DBTYPE_UI4
)

But i got error : Query (1, 8) Parser: The syntax for 'CUBE' is incorrect.

 

[MDXer]

I would expect an error trying to execute a script like that. XMAL scripts for cubes are very complex. to see what one looks like build a cube in bids and deploy it then script the cube out.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[jepe666]

Can I use passing parameter in cube(SSAS2005)?
Can I using script code in cube?