.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

filtering a role playing dimension

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
I have a role playing dimension and need to run a query that will select the intersection of members that are common on a single attribute...    So Dim1 and Dim2, they both have the attribute [Name] (though the fact table has two different foreing keys mapping to the single primary key on the dimension table) I need to select the members where both foreign keys on the fact table map to the same member in the dimension table so for example,  Dim1.Name = 'John Smith' and Dim2.Name = 'John Smith' Any ideas? Javier Guillen

View Complete Post

More Related Resource Links

Different attribute name in each dimension for a role playing dimension

Is it possible to name the attribute differently in a role playing dimension. For example I use the Date dimension as the role playing dimension for Ship Date and Order Date. When I use these attributes on the report, both of them show as 'Date' which is the name of the attribute in the Date dimension. Is there any work around to implement these names differently?

Role playing dimension and member naming question.


I have a fact table with invoice information that has multiple date columns.

I had originaly only needed to join my time dimension to this fact table on it's create date, but I have now added a role-playing dimension to join to the invoice date.

When I had 1 date dimension all of it's members where called 'week','year', 'day', etc.
Now that I have the role-playing dimension I have two dimensions with member names like 'Date.week', 'Date.year', 'Date.day', 'Invoice Date.week', 'Invoice Date.year', 'Invoice Date.day'.

So many queries I had written to reference the original date dimension no longer work because of the extra 'Date.' prefix. Is there a way to hide this prefix for my original date dimension?

Thanks in advance.

Cross Dimension Role Security

Hello guys,





The Problem:

As you can see the DimSeller is related to the DimCustomer by a non key attribute called "CNPJ", my question is how can i define role security based on that dimension attribute.

For example:

Im a customer with the cnpj 1234, and when i want to see the seller cnpj i can only see the "rows" that the Customer.CNPJ in the DimSeller is equal to my cnpj. 

My future needs i will associate the cnpj with a claims autentication user so than i can use that on sharepoint. At this page I found something like i need, but there i should repeat the steps for each attribute of the dimension, and that would be very hard.

Anyone have some suggestion wich is the best approach for doing this?

Dimension browse using Role fails with Error retrieving children

Hi, this concerns SSAS 2008 R2. I've created a test user and I want to give this test user re-only access to a cube and all of its dimensions. So, I created a Role as follows: General: Checked the Read Definition for database permissions Membership: users and groups set to Domain\Testuser Data Sources: (cube data source name), Access None, Read definition (grayed and checked) Cubes: (cube name), Access Read, Local Cube/Drillthrough Drillthrough, Process (unchecked) Cell Data: all blank Dimensions: All database dimensions, Access Read, Read Definition (grayed and checked), Process (unchecked) Dimension Data: (default, all checked) Mining Structures: (default, all blank) The Testuser can browse the cube using Management Studio, no problem. This includes access to all dimension members and browing the member hierarchies (as part of the cube). However, Testuser cannot browse the dimensions. The primary error is a blank pane saying that "the dimension does not contain hierarchies". So, I investigated. While logged on as Testuser, I looked at the properties of the Role as displayed in Management Studio. No suprises until I got to Dimension Data. Then, for each dimension, instead of the list of members and checkboxes in the main display pane, I saw "Error retrieving children: The '$dimensionname' object was not found. Parameter name: index" (where dimension

Link 1 measure group to 2 different role playing date dimensions and browse it by same date dimensio


hello, I'm Using SQL Server Standard 2008.

I have a measure group Sick leave, which holds measures like sick duration, and number of sick registrations.

For sick duration, the measure group is linked to the Date End role playing dimension by Sick End Date.

For Number of Sick registrations, the measure group is linked to the Date Start role playing dimension by Sick Start date.

But now I want to browse both sick duration and number of sick registrations at the same time against Date dimension,

How to do that?


Filtering dimension by measure sum



I'm trying to filter dimension, by sum of measures. I want to filter members, that have atleast one measure greater than 0.

with dynamic set Segment0 as







) > 0



Restrict SSAS dimension hierarchy to show based on role


I am having an issue that involves SSAS and Sharepoint.  I don't think I can fix the issue in Sharepoint, I think it has to be in my ssas cube.  THe issue is that in sharepoint I have a ssas filter webpart that displays the geography hierarchy based on the role that is defined in SSAS.  So if I have a user that only has permissions to Switzerland than they will see the geography hierarchy as (Region, Sub Region, Area, Country)

All Sales Region


         Eastern Europe



What I want to know is in SSAS can I restrict the hierarchy to only show country if the user belongs to a certain role.  So what I want to basically say is if the user belongs to SSAS_CH then the hierarchy should just show Switzerland, not All Sales Region > Europe, etc....

Can this be done?



How can we show certain no of dimension only for two different users having different role in a sing



well i might be having a security problem so i just want to know that can we show certain dimension to one user say  (i.e 10dimension for A user and 15 dimension for B user having different user role in a single cube.)

Please any one help me out soon and give some ideas...so that i can solve my issue ,can we solve this issue naa.. :( ..!!!


Anil Maharjan

MDX Conditional Sum using role playing date dimensions


I have a cube with a  single fact: [Measures].[order count] and two roleplaying dimensions [Order Date] and [Shipped Date]

I looking for calculated member that counts the order only if the Order Date and Shipped Date Occur in the same month.

I can do this as a TSQL case statement in the ETL; but I'm curious if there is a MDX based solution?

I'm using MSSAS 2008 R2



TreeSelector : playing with generics and type inference

create a generic way to define a selection starting from a tree of objects, the most simpler way as possible.

Let's start with the beginning...
Here is a very simple little interface defining a node of the tree, basically, a value and the references to the child nodes.

Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

GridView Filtering In ASP.NET

In this tutorial you will learn how to add a filter to a Grid View Control, To modify the query with a parameterized filter, the WHERE Clause, Parameter properties, Parameter Value Editor and To test filtering.

Problem making Role based Menu in MVC application



 I want to make Rolebase menu in MVC such that if user doesnot have permission for some action then that Action name shouldnot be shown in the Menu.

 I have used the code in the url(http://forums.asp.net/t/1566328.aspx) in my MVC application.My application is a Discussion Forum(in MVC) same functionality as in this forum forums.asp.net

 I have used Controllers for post, thread etc.In each controller there are some actions that are using [Authorize(Roles)] attribute

 but this coding does not count  those Actions in Controllers having Authorize attribute according to the url http://forums.asp.net/t/1566328.aspx 

 In the code, Authorize attribute is applied to Controller class, but my requirement is of Applying Authorize attribute to some actions in controller so that some are available for all users and  some links are available rolewise.Now what is the solution for that?



IIS request filtering module


Hi folks,

I have migrated my web application to iis 7.5 Now I am using windows 7 as dev machine.

the problem is it takes several seconds to download a single page into web browser now. It contains only 300 records.

Everything is ok on prod website though. Prod version contains up to 200000 records .I can't also use code profile tool of red gate to analyze possible bottlenecks since the software in question can't restart IIS. No errors in IIS logs. I am using ISAPI Rewrite 3 filter by Helicon to apply some URL rewriting rules. I am thinking about conflict between ISAPI rewriting rules and default IIS 7.5 request filtering rules, since the IIS request filtering module gets a higher priority than even the built-in IIS 7.5 rewriter module. Is it possible to tweak the module through web.config so that priority is given to ISAPI rewriting rules or something like that?

Frankly, I spent several days to figure out solution. No success...

I've also deployed the application on IIS 5.1. Everything works fine. Any ideas about possible solution for IIS 7.5?

Now Playing: Building Custom Players with the Silverlight Media Framework


The Silverlight Media Framework is an extensible and scalable video framework upon which you can create your own player experiences. We'll walk you through a custom player project that displays suggested videos for further viewing after the current video ends.

Ben Rush

MSDN Magazine May 2010

Test-Driven Design: Using Mocks And Tests To Design Role-Based Objects


Use Test-Driven Development with mock objects to design object oriented code in terms of roles and responsibilities, not categorization of objects into class hierarchies.

Isaiah Perumalla

MSDN Magazine June 2009

Patterns in Practice: Object Role Stereotypes


Object role stereotypes can help you better understand and clarify the responsibilities of the objects in your application.

Jeremy Miller

MSDN Magazine August 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend