Solved

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

Posted on 2013-01-29
2
382 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
2 Comments
 
LVL 6

Accepted Solution

by:
liija earned 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now