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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can anyone send me a valid OLAP cube creation sql request ?
Hi, all. I became nearly mad seeing that Microsoft's cube creation sample don't work and returns a mistake ... What's wrong ? Where do cube creations take place ? In query analyser, no ? Or can I write a query in another Microsoft SQL Server 7.0 component ? Thank you for your concern. SNFK -
Trouble with an MDX statement ...
Thank you for your answer and questions. I run my MDX query in the query analyser of MS SQL Server 7.0 on a remote OLAP Server and there shouldn't be any problem normally. I got a single hypothesis about the reason of the mistake : My instance of SQL Server 7.0 client happens to be in french and... -
Trouble with an MDX statement ...
Hi all. I'm new to the OLAP forum and ashamed of my question but here it is : given the following statement : CREATE CUBE Sales ( DIMENSION Time TYPE TIME, HIERARCHY [Fiscal], LEVEL [Fiscal Year] TYPE YEAR, LEVEL [Fiscal Qtr] TYPE QUARTER, LEVEL [Fiscal Month] TYPE...
