Writeback OLAP Data

  • Comments posted to this topic are about the item Writeback OLAP Data

  • The question is about "AS2005". But the article that the explanation refers to is clearly marked as refering to "Analysis Services (SQL Server 2000)".

    Can someone point me to a source that explains why writeback to a count measure is not allowed in AS 2005?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Hello Hugo

    The explanation is valid also for AS2005 because I suppose it's a logical question (In any case I can understand the writeback miss for funtions as distinct count, but not for count), but unfortunately there isn't information about this issue. I'm trying to contact any Microsoft OLAP engineer for obtaining more information.

    Regards

  • Here is the information concerning AS 2005: http://msdn2.microsoft.com/en-us/library/ms174750.aspx

  • Michael Kipp (11/21/2007)


    Here is the information concerning AS 2005: http://msdn2.microsoft.com/en-us/library/ms174750.aspx

    Thanks, Michael!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • It has nothing to do with the logic. QOD should conform to correct structures. The question should have been about write-enabled partitions rather than cubes. 😀

  • Hi Hajm

    I agree with you, writeback option apply in the partition scope. In any case I was referring to OLAP data and maybe I mixed both concepts without want. :Whistling:

  • Here's the link for 2005 which clearly says that the data must be aggregated by SUM.

    http://msdn2.microsoft.com/en-us/library/ms145568.aspx

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Hi Carlos,

    Thank you for your reply. When we speak of OLAP data, it also includes dimensions so becareful ..;)

    It is all fun and good. We reason and learn and explore new things.

    All the best,

    Najm

  • Thanks Markus,

    An interesting link for explaining the issue. curiously ... The article titled "Use Cube Writeback" and not "Use Partition Writeback" 😉

  • Hi Folks!

    i'm also facing the same problem updating OLAP cube from Excel.

    so i like to know how the reflect the changes back to the Cube from Excel 2003/07 .

    if any suggestion for Excel 2010 also is welcome to me .

    past 2 days i'm crushing my mind to find the solution to resolve the issues .

    Please help me to resolve this issues. so i will be thank full to everybody

    Regards,

    Sabarinathan

  • Thanks for the question.

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply