Under what situations should a cube be rebuilt? Is it just when the
underlying schema has changed? Not when a new data load occurs in the
database, correct?

thx,
M

Rebuild a cube when the structure changes.
Do a data reload when you must re-do the aggregations, or change any
existing fact
Do an increment build during normal daily/weekly processing to add new data
to the cube
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


"M" wrote:

I'm using SQL Server Integration Services to perform daily data loads. Is
there a way to automate the incremental build each time a data load occurs?

thanks,
-Marilyn

"Wayne Snyder" wrote:

yes, SSIS provides some tasks to execute XML/A commands or process a
partition.
and also, there is an option in a dataflow to directly load a partition from
an SQL Source.

for example, you have a query which load your fact table (sales for
example), then you can load these new data into the fact table AND push
directly these rows into your AS partition.

"Marilyn" <Marilyn (AT) discussions (DOT) microsoft.com> wrote

Because there is quite a bit of data manipulation that I need to perform on
the data before it becomes a cube I perform it within stored procedures. I
have an IS package that copies data that I need and then invokes the stored
proc to process it creating the fact and dimension tables. Is there a way via
source code to automate the deployment and processing of the dimensions and
cubes without being forced to use the mapping process that IS has?

thx,
-Marilyn

"Jeje" wrote:

Hi everyone,

I have a question about a connection with Analysis Services:

I have a big XML file with many nodes and many information, to understand
better, I have a littel example called employee.xml:

<AddressBook>
<Person familyName="Gates" firstName="Bob">
<Address street="Pine Rd." number="1239" state="CA"/>
<JobInfo jobDescription="Manager"/>
<Description>Family man</Description>
</Person>
<Person familyName="Brown" firstName="Robert">
<Address street="118 St." number="344" state="NY"/>
<JobInfo jobDescription="Group Leader"/>
<Description>Hacker</Description>
</Person>
<Person familyName="DePaiva" firstName="Kassie">
<Address street="Pine Rd." number="1234" state="CA"/>
<JobInfo jobDescription="Actor"/>
<Description>Actor</Description>
</Person>
</AddressBook>

I want to create a project in Visual Studio for Analysis Services to make
cubes using exclusively the XML file "employee.xml", I tryed with many
providers without success.

I don't want to use temporal tables in SQL Server to store all the XML file,
I need to use directly this information.

Please if you have a way to do it, please help me.

Atte,
Edwin