Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Devarajan
Starting Member
13 Posts |
 Posted - 2004-07-05 : 00:53:32
|
| CREATE CUBE Sales (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)i typed this query in query analyzer it's not working where can i type this query to create cube using the queriesG.DevarajanS/o K.Gopalakrishnan |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-07-05 : 22:42:59
|
| There is an MDX sample app installed with Analysis Services. I have never used it for DDL MDX though not sure if it will work, but that is what I would try first. -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
Devarajan
Starting Member
13 Posts |
Posted - 2004-07-05 : 23:42:45
|
Hello i tried that also but it is not working It gives only lot of errors couldn't open cellset Actually i foundthat in books onlinequote:
Originally posted by chadmat
There is an MDX sample app installed with Analysis Services. I have never used it for DDL MDX though not sure if it will work, but that is what I would try first. -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime.
G.DevarajanS/o K.Gopalakrishnan |
|
|
|
|
|
|
|
|
CREATE CUBE where to type this query