Viewing 15 posts - 196 through 210 (of 669 total)
Why have two different fact tables? Any specific reason?
Also, I do not see any reference of Dimension Key in your fact tables. It is like the fact tables are isolated.
March 3, 2011 at 3:37 am
Also, if the result set is large. Try using the NON EMPTY clause.
March 2, 2011 at 11:44 pm
yanaty999 (3/2/2011)
SELECT {[Measures].[Internet Sales Amount],
[Measures].[Internet Order Count]} on axis(0)
, ...
March 2, 2011 at 7:35 am
Brilliant Read!!!
Not many articles on MDX. Great Job!!:-)
March 2, 2011 at 2:00 am
2) I interchange the terms "datamart" and "datawarehouse", but datamart infers some smarts you can get out of the system , where as to me a data warehouse is just...
February 27, 2011 at 11:10 pm
joydeep.das.mail (2/15/2011)
I need 70-445 brain dumps
Joydeep, dumps will only help you get a certificate on paper.Period.What next??
February 15, 2011 at 7:30 am
Jeff Moden (2/2/2011)
parmar.randheer11 (1/30/2011)
Hi,I have consolidate few SSRS and TSQL questions for interview on my blog http://SQLServerQuest.blogspot.com .
you can check SSRS interview questions from there.
Thanks
Randheer
I got just a couple of...
February 2, 2011 at 11:52 pm
miriyalasrihari (1/22/2011)
any one please explain security issues in ssasor
send some links regarding about security issues in ssas
Hope this helps!!
January 24, 2011 at 12:00 am
stevefromOZ (1/20/2011)
Why not use the MeasureGroupMeasures() function? Official doc hereUsing your example....
select [m3].[attribute1].members on rows,
MeasureGroupMeasures('m1') on columns
from [cube]
This is the case of member missing. MGM() will not handle this...
January 20, 2011 at 10:54 pm
You may set the MDXMemberMissing property to ignore in SSAS
January 20, 2011 at 10:04 pm
Even better. I think I was misquoted for the wizard stmt. My bad. 🙂
January 20, 2011 at 6:43 am
Viewing 15 posts - 196 through 210 (of 669 total)