How to Restrict drill down to date lowest level from month -ssas

How to restric drill down to day level for measure groups that are lowest  level is month.
Sine I've one calendar dimension sharing different level of measure group, such as month and day level.

So I don't want users to drill down to day level the measures that are month lowest level.

Any help please
keplanAsked:
Who is Participating?
 
liijaConnect With a Mentor Commented:
Hmm, I think you would need two time dimensions - that is if you have these different  level measure groups inside one cube.
Other dimension for month level and the other day level.
But you'll end up in more problems with that - with calculations, usability etc. Very bad idea to have two time dimensions. But that would be the only way to do what you'd want. There's no connection between dimension hierarchies and measure groups.

You could also add two hierarchies to date. Other without day level. But with that solution - users can still choose the day-level hierarchy.

I've had several cubes with measure groups with different time granularity. But I have never heart any complaints on that from the users. Normally I have a few hierarchies in date dimension. Like in Adventure Works sample cube.
0
 
keplanAuthor Commented:
good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.