dbTalk Databases Forums  

Create and save a cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Create and save a cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
george.jo@free.fr
 
Posts: n/a

Default Create and save a cube - 05-17-2004 , 04:42 AM






hi,

I've creating a cube using DSO in C# , in Analysis Services it appears with all details.

but when i try to process it i have this error :
Erreur AXIS : System.Web.Services.Protocols.SoapException: Le serveur n'a pas p
u traiter la demande. ---> System.Runtime.InteropServices.COMException (0x800400
4F): Erreur interne
at DSO._MDStore.Process(ProcessTypes Options)

In AS when i try to modify this cube , it tells me that i've got a problem with the join clause... But the join clause is correct.

All i have to do in AS is to save the cube and after that i can process it in AS and in my programm in C# without problems....

Is there something to do in my creation with DSO , to "save" the cube? i'm already using the update method...

Thanks in advance
George

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Create and save a cube - 05-17-2004 , 08:50 AM






There is probably some property that is being mis-set.
Here is what I recommend. Get a copy of the Metadata Scripter from the SQL
Server 2000 Resource Kit.
It generates a VB application that sets the proper DSO properties up.
1) Run your application and then the Metadata Scripter to generate program
(A)
2) Run Analysis Manager to do what your program does and then run the
Metadata Scripter to generate program (B)
Do a windiff on programs (A) and (B).
You probably see that you are setting something up wrong, or have some
syntax problem, etc.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"george" <george.jo (AT) free (DOT) fr> wrote

Quote:
hi,

I've creating a cube using DSO in C# , in Analysis Services it appears
with all details.

but when i try to process it i have this error :
Erreur AXIS : System.Web.Services.Protocols.SoapException: Le serveur n'a
pas p
u traiter la demande. ---> System.Runtime.InteropServices.COMException
(0x800400
4F): Erreur interne
at DSO._MDStore.Process(ProcessTypes Options)

In AS when i try to modify this cube , it tells me that i've got a problem
with the join clause... But the join clause is correct.

All i have to do in AS is to save the cube and after that i can process it
in AS and in my programm in C# without problems....

Is there something to do in my creation with DSO , to "save" the cube? i'm
already using the update method...

Thanks in advance
George

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.