Nice article Douglas. I though you were crazy until I tried your code compared to what I had in my head. Pretty cool! I am faced with nearly an identical...

I was not shocked to see your response to number (1) and (4). As for number (3), all I am really saying is to add an attribute to your date...

Hello,

Have you made any progress on this issue yet?

Three things occur to me which may or may not work in your situation:

If you have a measure that will overwritten based...

Great! I wanted to see where you were at in your understanding of the lattice. Looks like you've got it.

I'm do not understand what you are attempting with the...

Vineet,

What is the key attribute of "Week Of Month"?

Chris

sachdeva.purnima (4/17/2012)

---

I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis

1. When both branches are same ,

2....

Jon,

Not sure that I understand your last question. Are you asking if the scope statement(s) will work if other dimensions are in play? If so, then the answer is "absolutely!"....

That's not going to work after all Jon. Bad suggestion, sorry. You are correct, the second scope may over-ride the first if it is not carefully crafted. Your second scope...

Did not know about WITH Ties. Great question!

Jonathan Mallia (4/13/2012)

---

How do you suggest go about modifying SCOPE to also cater for the level above category Main Category?

Can it be altered to something like this?

SCOPE ( [Measures].[Remaining...

Jon,

Unless you have explicitly set up a default member for the Category dimension(not something I typically do), SSAS should use the [ALL] member as default. Therefore, [Category].[Categories].[ALL] is exactly what...

Jon,

Do you understand why you had to use a SCOPE to get your total to give you the answer that you desired? If you do not, then ask yourself this:...

Good question. Never used this data type before but I have a project coming my way soon where I may be able to leverage datetimeoffset. Very "timely" har har. Thanks.

Very nice. Thanks for the question!

Debbie,

What is FactSENChild? Is that a measurement (fact), a dimension key, or something else?