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 |
|
musookia
Starting Member
3 Posts |
 Posted - 2004-08-05 : 07:19:07
|
| Hi All,I have a time dimension in which I have hidden the week level. (Visible levels are month, day). Now I have to create a calculated member which is a week-to-date total that should reference this week level .Obviously I can't do because the week level is not visible and therefore not accessible in name-binding. Does anyone have an idea how to solve this problem.I have tried to make a copy of the time dimension and hide it and make the calculation on the copy but I cannot synchronise the two time dimensions such that when I select a member on one dimension (time_visible), it selects the same member on the other dimension(time_hidden). Does anyone know how to go about this? |
|
|
|
|
|
Hidden level inaccessible to calculated member