That's a very large question. Please read the book and it will give you an idea. As for hard, I would say it depends. I didn't have any...

Status tables are normally very straightforward, although you don't give enough information to know if yours is an exception. An extract from mine would look like

Five columns

...

Agreed on the book recommendation. The third edition has recently been published. It is about 200 pages longer than the second edition. You may want to start with...

I do too. Great saying to...

Sorry, but I'm not following that at all. As I've said, we might be at the limits of being able to help without actually seeing the item and there...

Why doesn't this account have the same PK? This adds an...

We may be at the limits of what we can do without...

I think this was what I wasn't understanding. I did have a similar experience once with...

I don't know. Obviously I'm still missing something trying to help you. I've seen duplicates in the sense...

It seems odd that the amount essentially gets counted twice. Assuming that makes sense, however, I would recommend something along the line of the previous suggestion. I wouldn't...

OK, I see the real issue better. Let me think on this a day and I'll get back with you.

Given that you already have a parent-child table, did you try setting it up that way in SSAS? It actually does so more naturally than in an OLTP design....

To my understanding this is a one-to-many relationship (a single account with a single value can appear many times in the Groups-Accounts dimension), but I'm not sure if: a) this...

And then join DimID with the dimension ID? I already considered doing this, but it's not possible. In the real fact table there are more foreign keys, the most typical...

This won't be helpful per se, but recently I have an extremely difficult time trying to get the dbmail to work. I'd followed all of the steps, and had...