Viewing 15 posts - 946 through 960 (of 1,353 total)
The last solution is interesting, though as I recall I had trouble using the Now() function successfully, at least for what I intended.
If you use an autonumber type key for...
August 19, 2011 at 6:38 am
It's possible to query data warehouse tables using standard TSQL. This would keep you from having to create a second set of items. You could also consider creating...
August 16, 2011 at 6:34 am
I personally dislike Access because it allows amateurs to set up databases that get all messed up.
I've seen amateurs set up SQL databases. In this case, generally IT staff...
August 10, 2011 at 6:44 am
I agree with the above, other than to say that you should be aiming for a star schema. There are uses for the snowflake, but in most cases it's...
August 10, 2011 at 3:59 am
I'm not sure is access is even technically a RDBMS on the back end.
Gregory F, that's a bold statement without providing a framework as to what you might mean by...
August 9, 2011 at 8:56 am
Also consider that most DBAs do not consider Access as a Database
Access may not be an enterprise level database, but it is a database. Like any tool, there are...
August 9, 2011 at 5:17 am
Drill up and down refers simply to clicking the plus signs on dimension items that open up to more detail. For example, by clicking on the plus sign by...
August 4, 2011 at 4:20 am
"Slice and Dice" a cube simply expresses what a business user can do with the data that is available, not a formal development process that is done with the cube....
August 4, 2011 at 4:17 am
Does anyone know of any other books that details how to 'think' dimensional from relational? Something for beginners?
There weren't any other book recommendations, but I would recommend The Data Warehouse...
August 3, 2011 at 7:37 am
I don't think day numbers is much easier at all. It makes the date human friendly readable, but the users shouldn't be seeing that field anyway. As I...
August 2, 2011 at 7:14 am
Although Kimball initially called his similarly structured dimension a time dimension, this is now (as Kimball also says) called a Date dimension. One day you may actually create a...
July 26, 2011 at 1:56 pm
is there a way to i can specify that the NA member should not be visible?
Do this at the client, not at SSAS. If Excel is your client, N/A...
June 6, 2011 at 3:00 am
For starters, if you come to my desk with a 1:1 relationship better for you to have very, really strong arguments about why those two tables are not just one....
May 31, 2011 at 5:54 am
I always recommend Ralph Kimball's works to anyone starting out.
May 31, 2011 at 5:49 am
It looks like a dimension used by the cube has not been processed. You need to process all dimensions that have new or changed data that are accessed by...
May 31, 2011 at 5:47 am
Viewing 15 posts - 946 through 960 (of 1,353 total)