Solved

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

Posted on 2013-01-29
2
385 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

808 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