?
Solved

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

Posted on 2013-01-29
2
Medium Priority
?
398 Views
Last Modified: 2016-02-18
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
Comment
Question by:keplan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
liija earned 1500 total points
ID: 38832163
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
 

Author Closing Comment

by:keplan
ID: 38882501
good
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question