Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

Hot Topic

Add New Database Error "object reference not set to an instance of an object"
This SMO transfer script doesnt transfer ?
SSIS Clustering Doubts
Persian Date
reporting services connection error
sp_addlogin
How to use information from a dimension in a calculated member
SQL 2005 Everywhere and Nhibernate
Install and Uninstall problem
Cube deployment issue SSAS 2005

SQL Server

Using CASE in WHERE statement
What is the type of object returned by AquireConnection
Search Values with special characters
HOw to export txt file with column name??
Compare Two Dates
Date out of range?!
Order By
I need a procedure for mi DB
can i make column of report flexible as per data in thst column???
SQL Agent Trouble.

Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

First I will thanks for any friends open this one. My questions is:

1.What's the diffrent between Processing a dimension by "Dimension Processing Destination" or just by "Analysis Services processing Task"
I found that I could do the same work by both, and the MSDN tell nothing about the diffrence.

2.Why the Process Option in the "Dimension Processing Destination" is diffrent to the Process Option in the "Analysis Services processing Task" to deal with a dimension
In the "Analysis Services processing Task",the Option is the same with the MSDN, without the "incremental" option. But in the "Dimension Processing Destination",there is the "incremental" option(the first option). Why

3.What's the diffrent between Processing a cube by "Partition Processing Destination" or just by "Analysis Services processing Task"
The question is similar.

4.I have an AS project. I opened it from the BI studio, and could process one of the Dimension in it every well. And if I process the same Dimension in SSIS pakage by "Dimension Processing Destination" with "Full" option, it will be well too. But if I process the same Dimension in SSIS pakage by "Dimension Processing Destination" with "incremental" option, it will fail. Why

Thanks alot.

Ivan




Answer this question

Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

  • Ed Allan

    Thanks, you let me happy today.

  • MLG_CSE

    Thiese components are owned by Analisys Services team so I'll move the thread there.


    Thanks
    Obvidiu Burlacu



  • smtraber

    Obvidiu,

    The Dimension Processing Destination in an SSIS data flow allows SSIS to write data directly to a dimension structure in SSAS (a "push" model where you are pushing the data into the dimension structure). The full processing option completely reloads the dimension while the incremental processing option adds new dimension members. Thus, if your SSIS data flow results in the same set of records that you are trying to push into the dimension, the incremental processing option will fail as you would be duplicating dimension members by adding them to the dimension again.

    The Analysis Services Processing Task is a control flow element that allows SSIS to instruct the SSAS engine to process an object, in this case, a dimension (a "pull" model where you are telling SSAS to pull data into the dimension structure). When this task is used, no data actually flows through SSIS; rather, SSIS just instructs SSAS to process the object and SSAS takes it from there (launching the appropriate queries needed in order to do the processing).

    The reason you have an incremental processing option in the first case is that you are controlling the data set that gets pushed into the dimension structure, and therefore, SSAS allows you to incrementally add new records to the dimension structure. In the second case, you are asking SSAS to do the processing itself and it has no way of creating an incremental query in order to just get new records. The most common options in this case are the process full option and the process update option (which allows SSAS to reread all of the dimension data from the data source and then merge changes into the dimension structure).

    HTH,

    Dave Fackler

  • siyou

    SSAS supports incremental processing for partitions and dimensions. Both of them can be accomplished with constructing and sending appropriate XML/A queries. Incremental processing of a partition is easier to define in general case because partitions are based on single table only. Dimensions can be based on multiple tables.

    In SQL Server Management Studio and Visual Studio working with OLAP projects or with Integration Services projects there is one user interface component, which collects information from the user about how to process objects and constructs the XML/A queries. That component is reused.

    At the moment of Yukon development the case of incremental processing of the dimension was cut from the user interface part due to time constraints. This is why it is absent in the user interface.

  • Ravel

    Dave,thank you.

    Your answer give me an understanding about it.

    But you said that " you are asking SSAS to do the processing itself and it has no way of creating an incremental query in order to just get new records. " and you mean that's why it hasn't a ProcessAdd option in the AS Process Task in SSIS. I don't think so. Because in the AS Process Task in SSIS, if we process a partition, there is a config form to ask us to set a form or a qurey. We could tell AS how to chose get new records in the query.

    So I think if MS do the same work on the Dimension, we could tell AS how to get new records also. Your answer could not explain WHY there is not a ProcessAdd option for Dimention in the AS Process Task in SSIS.

    Thanks!



  • ProjectDev

    help,help,help me!

  • Questions about "Dimension Processing Destination" & "Analysis Services processing Task"
Answer this question