Setting Default Dimension Member

[HarryPotter1]

I have a time dimension that is flat. It will be used for viewing snapshots of particular data. As we add new snapshots of inventory to our cube, we will be adding that date to the time_snapshot dimension. What I'd like to do is when we add a new date to the dim and new data to the cube, force that new date to be the default date for the dimension, so when users view the cube, that is the default dimension. Is there an easy way to do this?

In addition, if I can do the above then I'd like to only have particular cell actions be active for this date only. Is there a way to do that?

 

[johnherman]

You have not specified what front-end is being used to view the cube. It seems to me that what you are asking is best controlled at the front-end, where they can do something like "select max (date) from date dimension" before establishing the user's view of the cube.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright