• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 901
  • Last Modified:

Is incremental processing available in SSAS 2005 standard, or I need Enterprise?

Hello Experts,

It seems the processing option of Process Incremental is supported for partitions only.
So, if I use SQL Server 2005 Standard edition (which does not support partitioning cubes), I cannot process cubes incrementalty, or I can?

Thank you.
PW
0
PWinter
Asked:
PWinter
  • 4
  • 3
1 Solution
 
David ToddSenior DBACommented:
Hi,

I'm not sure that this will help, but Analysis Services 2000 Standard has incremental updates.

HTH
  David
0
 
PWinterAuthor Commented:
Thanks dtodd for your reply.

I know that in 2000 it is supported, I've made my BI module with it.
Now a contractor says I need to build a complex (therefore expensive) solution or buy Enterprise in order to make the similar module based on 2005.
That's why I ask: is it true or it is just an attempt to get funding?

Thank you,
PW
0
 
Auric1983Commented:
PW,

Here is the documentation from MSDN http://technet.microsoft.com/en-us/library/cc966446.aspx

Incremental Processing
Generally, when a cache is refreshed, it will fully process the affected Analysis Services object to completely reload the cache. To be more exact, partitions use process option Full, while dimensions use process option Update. These options will ensure that related partition data is preserved. However, it is also possible to perform incremental processing of both partitions and dimensions where it is known that rows are only added and not updated.

This capability is available when using the polling notification scheme. Along with a polling query that indicates that an update has occurred, the designer also provides an incremental processing query, which returns the new rows. This query is parameterized, taking the previous and new value as returned by the polling query. An example is provided in the appendix.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
PWinterAuthor Commented:
Thank you, Auric1983, for participating.

I've read this one, and it does not sound clear to me.
"It is also possible to perform incremental processing of both partitions and dimensions" - ok, but what if the cube is not partitioned?

Thank you,
PW
0
 
Auric1983Commented:
PW,

I think it would still work to incrementally build the dimensions. Partitioning is just a way to split the dimension into multiple sections.  

Where you see big performance gains using partitions is for really large datasets.  In SQL 2000 you needed to emulate this with multiple tables & a view to link them all together.  in SQL 2005 and 2008 you can setup partitions for your data which would give you some performance increases for large datasets.  


0
 
PWinterAuthor Commented:
I believe it will work for dimensions, partitioned or not.

My question is about incremental updating fact data.

Thank you,
PW
0
 
PWinterAuthor Commented:
I've got the following answer from Microsoft's Customer Support:

Process Incremental :-
Used to add newly available fact data and process only the relevant partitions. This processing option is supported for measure groups, and partitions.

Partitions is supported with SQL server 2005 Enterprise edition and which you can see from the following reference.
http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx 

Since standard edition doesn't have partition option we won't be able to perform Incremental Processing with standard edition.

Let me know if you have any other questions and if i can go ahead and close this ticket.

Some links for reference :-
http://technet.microsoft.com/en-us/library/ms174774.aspx 
http://msdn.microsoft.com/en-us/library/ms175688.aspx 

Thanks,
*******
Microsoft SQL Server Support Engineer


This means that SSAS 2005 Std is almost useless, as there is a need to do the full process of a cube after any addition to underlined data.
Even more frustrating the fact that SSAS 2000 Std does support such a key feature.

PW
0
 
Auric1983Commented:
PW,

That's too bad! Glad you got the answer my apologies for not being able to help more, I was out of the office yesterday.

Good luck!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now