Hi ,

I had a typical cube having 3 measures and no of dimensions . The problem is
that i had made these cubes through navision now when i update the tables
with data the cube does not update and in navision there is no process that
can automatically updates the cubes so i want to process the cobe from sql
server or analyssis server but i dont know how to write a mdx query for that.
and put that in a job and it run at acertain time.
pls can anybody help me

--
waiting for solution
from
Sufian

Hi Mohd,
you can process the cube and schedule this job in Microsoft DTS (Data
Transformation Service) which come along with SQL server 7.0 or 2000.

fisrt of all i want to know that after creating these cube have you designed
the storage and calculated the aggregation if yes then use DTS or else you
can use DSO(Decision Support Objects) in Visual basic or any other microsoft
development tool to do all these tasks.

Ninad M. Dixit

"Mohd Sufian" wrote:

Dear Nin,
If u read my questation in deep then i want to tell u that creating a DTS
package is not the best option and not even good with other application i
need to work on DSO but i am not able to understand how to do it .
If u can help me with the code.
One thing more for temporary use i had created a DTS package using APT but
it runs fine for the first time but it give an error when i try agian.
So, i need the code to do that .

If u can help me with this but thanx for ur help





--
waiting for solution
from
Sufian


"Nin" wrote: