Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DP978
Constraint Violating Yak Guru
269 Posts |
 Posted - 2010-02-12 : 12:38:25
|
| Sorry to bother anyone, I really did not know where to go for an answer to this, and MSDN is not helping very much at the moment.If this is the wrong place for this question could someone direct me to a better resource? Thanks in advance.Anyways my question revolved around the use of a CUBESET(), CUBERANKEDMEMBER() and has to do with ranking over a supplied time frame (not an exact member like [Date].[Year].[2009]) like being able to aggragate over a period of say {[2009-01-01]:[2009-01-07]}Problem is that the CUBESET() function does not like to take in another set as its members... I will post more detailed formulas if someone thinks they can help. I can sum up numbers over a date range already, I just can't rank members over a date range and return it!Thanks again...any help is appreciated |
|
|
|
|
|
Cube Function Questions Regarding SSAS/Excel