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

SSAS Cubes Expand / Collapse
Author
Message
Posted Monday, April 6, 2009 11:51 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, October 19, 2013 6:54 AM
Points: 1,046, Visits: 32
Comments posted to this topic are about the item SSAS Cubes
Post #691704
Posted Tuesday, April 7, 2009 5:39 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 8, 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
Posted Tuesday, April 7, 2009 9:17 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:54 PM
Points: 413, Visits: 393
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
Posted Thursday, April 9, 2009 8:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:13 PM
Points: 33,100, Visits: 15,210
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
Posted Thursday, April 9, 2009 9:45 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 8, 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
Posted Thursday, April 9, 2009 9:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:13 PM
Points: 33,100, Visits: 15,210
I saw it yesterday, left it in a browser, and then didn't get to it until today

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 »

Add to briefcase

Permissions Expand / Collapse