Solved

Creating CUBE Perspectives

Posted on 2011-09-21
2
757 Views
Last Modified: 2016-02-15
Is there a way in a perspective, to filter out a value in a dimension attribute?

For example, i have a dimension called Camapign, one of the attibutes = Practive, i only want to get all values where practce = 'FIN' is this possible? i only see the abilityto filter out attributes,dimensions, measure groups, kpe's etc.
0
Comment
Question by:basile
2 Comments
 
LVL 30

Accepted Solution

by:
Reza Rad earned 500 total points
ID: 36913970
you can use ROLE for this case and use Dimension Data tab in role and choose only practive member or anything else you want
perspective doesn't allow to filter out on attribute members
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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.
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

920 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

15 Experts available now in Live!

Get 1:1 Help Now