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 |
|
ramuthota
Starting Member
4 Posts |
 Posted - 2009-01-06 : 03:10:41
|
| Hi All,In a cube there is date dimesion haveing members dateid,actualdate,defaultdate(12/19/08)I need to set a defaultmember for actualdate based on defaultdate like [date].[defaultdate].All but itis giving error "Error 1 The specified default member '[Date].[Defaultdate].[All]' must be from the '[Date].[Actualdate]' hierarchy. "How to solve the problem and set defaultdate as defaultmemberThanks,Ramu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-07 : 10:55:14
|
| didnt understand why you want to set one fields default value from another field. shouldnt you be setting one of members of [Date].[Actualdate] as its default member? |
 |
|
|
|
|
|
problem