SSAS Cubes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by jconesa » SSAS Cubes

SSAS Cubes

Rate Topic

Display Mode

Topic Options

Author

Message

jconesa

Posted Monday, April 06, 2009 11:51 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, March 01, 2013 11:29 AM
Points: 916, Visits: 28

Comments posted to this topic are about the item SSAS Cubes

Post #691704

liam.stirling

Posted Tuesday, April 07, 2009 5:39 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 7:08 AM
Points: 469, Visits: 124

Not strictly true - it does process, it just doesn't have anything to calculate the aggregations with. If CALCULATE has been replaced with something else, removing CALCULATE doesn't have an effect so its a bit ambiguous. I just tried it to see. All of my dimensions were still intact and the cube "processed" without any problems from BIDS - there just weren't any aggregations on the measures (so the cube is a bit useless but it didn't report any errors). Had I got some other aggregate expressions in place, deleting CALCULATE may have had no effect...

Post #691863

ppcx

Posted Tuesday, April 07, 2009 9:17 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:08 PM
Points: 220, Visits: 352

This post agrees that it processes, but doesn't do anything: http://www.dbtalk.net/microsoft-public-sqlserver-olap/hey-my-cube-empty-what-357327.html

Post #692162

Steve Jones - SSC Editor

Posted Thursday, April 09, 2009 8:41 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

The question has been corrected and the points awarded back.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #694058

liam.stirling

Posted Thursday, April 09, 2009 9:45 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 7:08 AM
Points: 469, Visits: 124

Thanks, Steve.

To have come across this you really are as busy as you say in you editorials!

Post #694143

Steve Jones - SSC Editor

Posted Thursday, April 09, 2009 9:56 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

I saw it yesterday, left it in a browser, and then didn't get to it until today Sad

Definitely busy, and perhaps not necessarily managing my time great, but trying.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #694156

« Prev Topic | Next Topic »

Permissions