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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS Batch Process 1

Status
Not open for further replies.
RicoCali

RicoCali

Programmer
Dec 7, 2002
80
US
I'm new to AS. I can process cubes through Analysis Manager. But how do you set it up so I can write an MDX script to automate the process at certain intervals?
 
Sort by date Sort by votes
MDX is only the query language to extract data from a cube. it has no automation capability. However DSO which is the AS API has the object required to do automation. You can use dso in vbs vb or .NET. if it is simple processing you can also do this through DTS.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
181
Komal0735
Komal0735
FarhadR
  • Locked
  • Question
SQL cube Date is recognized as Character in BO
Replies
0
Views
80
FarhadR
FarhadR
StitoJunior
  • Locked
  • Question
SSAS Process Cube Error with Oracle
Replies
1
Views
54
RiverGuy
RiverGuy
informer30
  • Locked
  • Question
MS AS 2005
Replies
1
Views
39
MDXer
MDXer
eo
  • Locked
  • Question
trying to use currentmem properties to use the dim value as calc measu
Replies
0
Views
55
eo
eo

Part and Inventory Search

Sponsor

Back
Top