Automate / Productanalize the Cube & Dimension building process?

MS SQL SERVER

    Next

  • 1. BI Portal and PivotPrint.dll
    Hi, All! Is there a way to use PivotPrint.dll (from Office XP Web Component Toolpack) functionality in BI Portal? This .dll exist in BIP installation in /ext dir with corresponding .htc file and .Printing class declared in BIPStyleSheet.css. But I dont now which corrections I must do in source files for attaching .Printing behaviour to PivotTable control. Any help will be appreciated. Eugene.
  • 2. Pre-populated time dimension
    Read a thread where a Tom Chester sugested, mainly for performance reasons, using pre-populated time dim. If yo do this, is there a way to show only the times up to a specific time - such as "now"? e.g. On October 31 I don't want November and December to show in the time dim yet. Also, is there a function in MDX to retrieve the current system time. I tried Now and GetDate but ... Les McPhee
  • 3. Can't run Analysis Services on XP machine
    I have been running the SQL Server 2000 Enterprise Edition Evaluation Kit. All has worked great until I loaded Analysis Services. I can not get this tool to run on my Windows XP Pro Pentium 4. The PC becomes extremely slow and locked up. I have tried installing the components of the Service pack 3a, but this didn't help. So finally, I had to uninstall Analysis Services. Is this a known issue and if so, how can I fix it? Thanks, Jim Arnold

Automate / Productanalize the Cube & Dimension building process?

Postby UHJhc2Fk » Fri, 02 Jun 2006 03:35:01 GMT

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 ullprocess 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 here 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.


Re: Automate / Productanalize the Cube & Dimension building process?

Postby baty » Fri, 02 Jun 2006 16:42:50 GMT

You can create a program with VB or C# .net 2, using the
"Microsoft.AnalysisServices" assembly.

This assembly contains all the objects that you need :
Server => Database => Cube => MeasureGroup => Partition ==> Slice.

I never updated the slice with SSAS2005, just with SSAS2000, but it's
really helpfull when you have many partitions.
In our solution (SSAS2000) we create every month new monthly partition
for 15 cubes, with slice definition.

Regards


Thierry






Re: Automate / Productanalize the Cube & Dimension building process?

Postby » Fri, 02 Jun 2006 20:55:21 GMT

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.








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)



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 50 guest