Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Create a local cube with ascmd utility

 
   Database Help (Home) -> OLAP RSS
Next:  Collation Issue  
Author Message
olroxa

External


Since: Sep 02, 2008
Posts: 5



(Msg. 1) Posted: Thu Dec 11, 2008 3:31 am
Post subject: Create a local cube with ascmd utility
Archived from groups: microsoft>public>sqlserver>olap (more info?)

Hello,
I need create a local cube with ascmd utility, but i don't get it.
My statement ascmd is:

ascmd -S Localhost -d Alpine_Ski_House_ResortMgmt -i CrearCuboLocalRevenue.xml

where CrearCuboLocalRevenue.xml is:
CREATE GLOBAL CUBE statement. FILENAME|C:\Revenue.cub|DDL|
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2"
xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>a8fc765c-c646-4c2a-aa2d-3beb02ccfcbf</DatabaseID>
<CubeID>502e4526-fd57-4026-898f-89f3e0113c41</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

Somebody knows where this the problem ?

Thank you very much..

 >> Stay informed about: Create a local cube with ascmd utility 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Local Cube error - I use SQL Server 2005 Enterprise Edition with SP2 (32bit) In BIDS I create a Pivot Table report and export it to Excel 2003. In Excel 2003 I then try to create a local cube but at step 4 the process fails when trying to save the cub file to disc with....

Local cube file ? - I have created a data cube with VS2005 and deployed it to SQL Server 2005. How do I created a local cube file (.cub)?

CREATE CUBE Expert wanted - Hello, thank you for reading this. I try to create a local cube with an access db as source. Everything is fine so far. I have PARENT_CHILD, PROPERTIES, even Custom Rollups are working. But I can not set the LEVEL_NAMES with LEVEL_NAME_TEMPLATE: &quot...

error with CREATE GLOBAL CUBE - When trying to create a local cube with the following statement CREATE GLOBAL CUBE [finan] Storage '\\a\b\c\d\e\f\g.cub' FROM [finance] ( MEASURE [Finance].[Amount agg], DIMENSION [A1].[A2], DIMENSION [B1].[B2], ..

Create cube file - fails with lots of data - I want to create a local cube file (.cub) from an Analysis Services cube and have been using the MDX below. It works when there is only 2 weeks of data in the cube (and the cube file is 33mb in size). When I have 2 years of data in the cube, it fails....
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]