Viewing 15 posts - 1 through 15 (of 50 total)
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...
March 25, 2014 at 6:50 am
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...
May 4, 2012 at 10:40 am
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...
May 4, 2012 at 7:13 am
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...
April 17, 2012 at 7:20 am
Vineet,
What is the key attribute of "Week Of Month"?
Chris
April 17, 2012 at 7:03 am
sachdeva.purnima (4/17/2012)
1. When both branches are same ,
2....
April 17, 2012 at 6:45 am
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!"....
April 17, 2012 at 6:40 am
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...
April 16, 2012 at 8:19 am
Jonathan Mallia (4/13/2012)
Can it be altered to something like this?
SCOPE ( [Measures].[Remaining...
April 16, 2012 at 6:53 am
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...
April 12, 2012 at 12:25 pm
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:...
April 12, 2012 at 8:29 am
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.
April 9, 2012 at 8:31 am
Debbie,
What is FactSENChild? Is that a measurement (fact), a dimension key, or something else?
January 27, 2012 at 11:55 am
Viewing 15 posts - 1 through 15 (of 50 total)