Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. February 2008 Entries
adding a fact table to a SSAS 2005 cube
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 ......

Posted On Monday, February 11, 2008 9:28 AM

SSAS cube: "attribute key not found" error
I just spent over an hour trying to figure out why my data tables were correct but I was getting an error about an attribute key not being found (i.e. an unlinkable foreign key).   I finally figured out that processing one dimension at a time before processing the cube can get fix whatever is out of sync.  [Right-click on the dimension in Solution Explorer to process it separately.]

Posted On Wednesday, February 6, 2008 11:05 AM

CPU percent limit in .Net

Why doesn't the .Net framework have anything that lets you set a maximum CPU usage for an application?  Is it something Windows can't handle?  I'd really like to be able to say, "I don't care if this app gets stuck in a loop or whatever, it will never get above 25% CPU."

Posted On Friday, February 1, 2008 11:29 AM

Copyright © Alex Bransky | Powered by: