Method to Programmatically Process Database on Website 
Author Message
 Method to Programmatically Process Database on Website
Is there a way to programmatically process the cubes?  

I'm writing a simple application that inserts new fact table records
into SQL Server.  I also want a control button that invokes Analysis
Service to process the database.  This is all to be done on an ASP
page.

Is this possible?



Tue, 09 Dec 2003 05:08:23 GMT
 Method to Programmatically Process Database on Website

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olap...
mdstorei_641f.asp

    Dim dsoServer As New DSO.Server
    Dim dsoDB As DSO.MDStore
    Dim dsoCube As DSO.MDStore

    ' Connect to the local Analysis server.
    dsoServer.Connect "LocalHost"

    ' Open the FoodMart 2000 database.
    Set dsoDB = dsoServer.MDStores("FoodMart 2000")

    ' Begin a transaction on the database.
    dsoDB.BeginTrans

    ' Create a reference to the Sales cube.
    Set dsoCube = dsoDB.MDStores("Sales")

    ' Process the cube, refreshing data.
    dsoCube.Process processRefreshData

    'Creae a reference to the Budget cube.
    Set dsoCube = dsoDB.MDStores("Budget")

    ' Process the cube completely.
    dsoCube.Process processFull

    ' Commit the transaction.
    dsoDB.CommitTrans


Quote:
> Is there a way to programmatically process the cubes?

> I'm writing a simple application that inserts new fact table records
> into SQL Server.  I also want a control button that invokes Analysis
> Service to process the database.  This is all to be done on an ASP
> page.

> Is this possible?



Fri, 12 Dec 2003 10:44:13 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to process Analysis Services database programmatically?

2. How to programmatically change object event method ?

3. method to pull random data to html page upon first visit to website

4. Problem Programmatically Processing a Cube

5. [VBScript]Unable to programmatically process cube

6. Password processing in DAO (MDB files, programmatically)

7. Process method of MDStore Interface

8. Best method for online processing?

9. IL-Barrington-253381--MS ACCESS-Advanced Excel-Data Processing Methods, Principl

10. Dynamic SQL method 4 with array process

11. DSO Cube Process Method and Transactions

12. How do we know if a process is user process or system process


 
Powered by phpBB® Forum Software