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 |
|
mvuyelwa
Starting Member
1 Post |
 Posted - 2004-09-06 : 12:41:22
|
| hi am trying to create a calculated member called month to date which will help me determine the difference in my sales values which is last year versus this. i have made use of this in the cube Ancestor([Financial Time].CurrentMember, [Financial Time].[Fin Year]), my problem is that i can't seem to be able to display data on this member after processing the cube. my aim is to display the netsales value measure or all the measures because i have included this monthtodate function as a child within the parent financial year(which is my time dimension). |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-09-06 : 13:47:04
|
why don't you provide us with a sample set of data (preferably with create statements and what not..) And we will be happy to try and point you in the right direction  Corey |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-06 : 17:58:44
|
| parallellperiod() ?rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
|
|
|
MonthToDate Function