Writeback OLAP Data

Question

Writeback OLAP Data

Carlos Iglesias

Old Hand

Points: 324
More actions
November 21, 2007 at 12:09 am

#180677

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

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

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 1

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/

Carlos Iglesias Old Hand Points: 324 More actions · Answer 2

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

Mighty SSCrazy Eights Points: 9063 More actions · Answer 3

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

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/

Najm Hashmi SSC-Addicted Points: 484 More actions · Answer 5

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. 😀

Carlos Iglesias Old Hand Points: 324 More actions · Answer 6

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:

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 7

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]

Najm Hashmi SSC-Addicted Points: 484 More actions · Answer 8

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

Carlos Iglesias Old Hand Points: 324 More actions · Answer 9

Thanks Markus,

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

sabarichandru SSCommitted Points: 1704 More actions · Answer 10

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

akljfhnlaflkj

SSC Guru

Points: 76202

October 7, 2014 at 7:06 am

#1750556

Thanks for the question.