Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time.

So you're trying to add a fact table to a cube that you've already created, but you can't figure out how to do so without recreating the cube from scratch?  Here's what you do:  In the Measures pane in the Cube Structure tab, right-click and select New Measure Group.  Then select the fact table, and voila!  (This is assuming you've already put the fact table in the data source view.)

addendum:  Looks like the standard way to add a dimension to the cube is to right-click on the cube name in the Dimensions window in the Cube Structure tab and select Add Cube Dimension.


Posted on Monday, February 11, 2008 9:28 AM all tech stuff , SQL Server | Back to top

Comments on this post: adding a fact table to a SSAS 2005 cube

# re: adding a fact table to a SSAS 2005 cube
Requesting Gravatar...
Thank you for offering the solution in one paragraph! I have added dimensions the way you mention, but having more than one fact table is something I have not tried yet for my project, even though I already used it from one of the examples I found on a textbook I am using. Your explanation makes sense. Thank you again.
Left by Jaime Montoya on Jul 17, 2015 2:19 PM

Your comment:
 (will show your gravatar)

Copyright © Alex Bransky | Powered by: