Automate / Productanalize the Cube & Dimension building process?

Similar Threads:

1.Automate / Productanalize the Cube & Dimension building proces

Hi Jeje,

Thanks for the reply.

Any sample reference code that used XMLA commands to create dimensions with 
custom "where" cluases would be helpful.

Please let me know.

Thanks,

Prasad.

"Jj" wrote:

> for the aggregation design, anticipate the number of rows.
> If you plan to have 1 million of rows at the end of the month, put 1million 
> instead of counting the number of rows and aggregate the cube based on the 
> future value, not the today count.
> Having the exact value is not important, but you have to setup a close 
> value.
> 
> Have you try to play with XMLA commands to manage your dimensions? or using 
> VB Scripts like baty says.
> 
> "Prasad" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> >I have 10 large cubes in Production (MSAS 2005). Each cube has monthly
> > partitions (48 for 4 years). Also I have several TIME related dimensions.
> >
> > We have to do "Full" process of these cubes monthly. I have the following
> > issues.
> >
> > 1. Since we do full process of the cubes and the row counts change for 
> > each
> > partition every month, do I have to go back and redo aggregation design on
> > each partition for all the 10 cubes every month? (10 X 48 = 480 
> > Partitions)
> >
> > If yes, is there an easy way to do this? Is there sample code that takes 
> > the
> > cube name and rebuild aggregations for all the partitions?
> >
> > 2. For all the TIME dimensions (Named Queries), I have to go back and 
> > change
> > the "where clause to include the latest month for every monthly rerun. 
> > Please
> > suggest if there is a programmatic way to build the dimensions so that I 
> > can
> > automate the dimension building process.
> >
> > Any references to how to productanalize the whole dimension and cube
> > building process will be helpful.
> >
> > Thanks a bunch,
> >
> > Prasad.
> > 
> 
> 
> 

2.Automate Delivery/ transfer OLAP cube database & process cubes?

I have about 10 cubes I have developed and I am trying to deliver them to 
customers as painlessly as possible I can for them.  I can write a script to 
restore the .cab file using the msmdarch.exe from the command line, but the 
problem is, I still have to manually change the data source via Analysis 
Manager.  Is there anyway to automate this process assuming I know the data 
source connection info?  Then once I get that, is there an easier way to 
reprocess cubes from the command line than creating a DTS package to 
reprocess them, and execute the package using DTSrun.exe from the command 
line?
-- 
Jason

3.OT: Application to automate process of building forms from a SQL DB

Hi!

Is there a software you can recomend that helps build a form or a inet-form
from a SQL DB?

I have a database with rules, triggers, tables and so on and i want to build
forms and so on from the database...

I have looked on a program that is called Constructor() but i wasn't
satisfyed completley with this...

Any suggestions?

Regards

Martin Arvidsson, Visual Systems AB, Sweden

4.Processing dimension and processing cube

5.SSAS 2005 : does cube process process the dimensions?

Hi,

I'd like to know when I process a cube, does that automatically
process the dimensions? I'm especially using a cube process task in
SSAS and I do not know wether it first do a job on the dimensions.

thx,
Chris

6. How to Automate Cube Building in Ananlysis Services

7. Automating cube processing

8. Problems when building cube with Multiple Dimensions. (Urgent)