Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Writeback OLAP Data Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2007 12:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 08, 2011 4:12 PM
Points: 146, Visits: 120
Comments posted to this topic are about the item Writeback OLAP Data
Post #424438
Posted Wednesday, November 21, 2007 1:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:48 PM
Points: 5,802, Visits: 8,019
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #424454
Posted Wednesday, November 21, 2007 3:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 08, 2011 4:12 PM
Points: 146, Visits: 120
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
Post #424493
Posted Wednesday, November 21, 2007 5:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:40 AM
Points: 3,093, Visits: 1,150
Here is the information concerning AS 2005: http://msdn2.microsoft.com/en-us/library/ms174750.aspx
Post #424542
Posted Wednesday, November 21, 2007 6:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:48 PM
Points: 5,802, Visits: 8,019
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #424563
Posted Wednesday, November 21, 2007 7:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 352, Visits: 111
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. :D
Post #424593
Posted Wednesday, November 21, 2007 7:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 08, 2011 4:12 PM
Points: 146, Visits: 120
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.
Post #424611
Posted Wednesday, November 21, 2007 8:03 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 4,432, Visits: 4,157
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


Markus Bohse
Post #424617
Posted Wednesday, November 21, 2007 8:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 352, Visits: 111
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
Post #424620
Posted Wednesday, November 21, 2007 8:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 08, 2011 4:12 PM
Points: 146, Visits: 120
Thanks Markus,
An interesting link for explaining the issue. curiously ... The article titled "Use Cube Writeback" and not "Use Partition Writeback" ;)
Post #424624
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse