• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

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
0
keplan
Asked:
keplan
1 Solution
 
liijaCommented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now