My two cents: I completely agree with @wta306. I would also add that there might not actually be a real relationship between a branch office and an employee. I assume...

Is there a reason that you must have a new cube if you already report transactional data in another cube? "Subscriptions" sounds to me like a slowly changing dimension (type...

I got around to this question late today so I missed all of the excitement. I never knew that 'GO' accepted a count. Never read about 'GO'...HA! Thanks for the...

Just in case the image links in my original post do not work... I am using the following as the value expression in the subtotal textbox: "=Fields!Salesperson.Value"

Could not be any...

Good question. keeps you on your toes.

Michael,

You'll find some that hold the opinion that mixing divergent facts in the same cube produces data sparsely and that this is a bad thing. I however am not one...

stevefromOZ (5/12/2011)

---

I second the question re: why not use both facts (ie measure groups) in the one cube.

I also agree, the 'Used' or 'Active' flag on the dim table could...

Michael Lysons (5/12/2011)

---

My BI system has two fact tables (and therefore cubes); an Inpatient Admissions fact and an Outpatients fact. One dimension that is common to both fact tables is...

good question and explanation.

Thanks.

*blushing a little bit* I should have known this.

Thanks for the help. That worked.

In order to really understand MDX you should steep yourself in multidimentional theory. Read lots of Kimble.

I also found this a good resource as well: http://www.amazon.com/Expert-Development-Microsoft-Analysis-Services/dp/1847197221/ref=sr_1_1?ie=UTF8&s=books&qid=1304695289&sr=1-1

I agree with Carlos that this may be a viable solution for you. My team has built something similar for invoice numbers. However, we strongly advised our client against this...

Matthew,

Your instinct seems correct to me. At my current client, we have one master date table (let's call it DateMaster) which is built well into the future. We then have...

Good question. Thanks Steve.

Thanks for the clarifications everyone. Good conversation.