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

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

Filter on Multiple Dimensions

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :



I am trying to get a value of measure based on 2 conditions from 2 dimensions. So what I want is No of Hours (Measure) when Account from [COA AHC] dimension = 902000 and Account Unit from [Levels] dimension is 1400. Here is what I have:

select [Measures].[No Of Hoursin Period] on 0,





I keep getting an error. What am I doing wrong? Please help me.



View Complete Post

More Related Resource Links

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Filter search over multiple text columns


Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?



Excel 2007 Filter on multiple values

Hi Everyone,How do I use Excel 2007 Pivot Table's label filters/value filters to filter with multiple conditions? for example, I want to get all customers with customer name start with "G" and doesn't include "E" and with measure>100 and measure between 50-60.Regards,George

T-SQL linear regression in multiple dimensions

Hi! I'm trying to make linear regression T-SQL in multiple dimensions  (y = a + a1*x1+ ... a2*xn) like LINEST function in Excel.I need create a similar stored procedure in SQL Server.I also created the code using the article http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html but i have troubles in re-adapt to a model with multiple dimensions...thanks!

How to filter a List View by multiple values for one filter field?

Hi, I need to create a dynamically created link to a List View with a filter on one field, but with multiple values. Example: http://<server>/Lists/<list>/Allitems.aspx?FilterField1=Name&FilterValue1=John/Jack/Jonas which should give me all items where Name equals John, Jack or Jonas. Is this even possible?

group on or filter multiple datasets in 1 table?

I am fairly new to using BIDS, so please bear with me. I currently have 2 datasets, and 1 table.  The layout of the table is: Header HeaderGroup1 HeaderGroup2 Details FooterGroup2 FooterGroup2 Footer Group1 Footer Group1 Footer This is working, but what I need to do is figure out a way to add another Footer Group2 that includes an expression which involves either using data from a 3rd data set because of needing a different filter, or figuring out a way to filter the same data set twice in the one table.   I can give more specific info if you let me know what you need. Thanks!

Is it possible to create attribute relationship across multiple dimensions?

In other data warehouse tools such as Microstrategy, you can create attribute relationship between different dimensions easily. For example, I can define a joint-child relationship(Attr1 from Dim1, Attr2 from Dim2) decide Attr3 from Dim3. In another word, if it is in a natrual hierarchy, it is                                   Attr3                                      |                             (Attr1, Attr2) If we can build such kind of relationship, first Attr3(dim3) is not necessary to appear in fact table. Second, if query without fact data, you can simple pull out Attr1, Attr2 and Attr3 relationship. Is it possible to make such kind of relationship in SSAS? If not, I think put Dim3 in fact table should be an alternative way to relate Attr1, Attr2 and Attr3.    

Selecting multiple dimensions members


I select multilple dimensions, for instance [dim 1].[atrr hier].allmembers * [dim 2].[dim attr].allmembers ..*[dim 3].[dim attr].[dim 8] and a measure, which is linked to all dimensions .

Since 2 dimensions have grown larger lately, and given large number of dimensions queried, performance degrade has grown to unacceptable levels.

What is the best way to select only these members which are actually relevant? I'm well known with the filter statement but do we have alternatives?

Business Intelligence professional

Is there a way to query entity based on multiple filter criteria? WCF Data Services, Linq to Entiti


Instead of:

DW_CMSOPEN dwc = new DW_CMSOPEN(new Uri("http://acctdev02/WCFDataService/EmployeeService.svc"));

dwc.Credentials = System.Net.CredentialCache.DefaultCredentials;

var employees = from emp in dwc.Employees 
             where emp.DEPT == "123"
             select emp;

I'd like the linq query to resemble:

var employees = from emp in dwc.Employees
              where emp.DEPT // in {"123", "456", etc}
              select emp;

How to pass multiple filter parameters to moss report viewer from custom filter provider


I have written a custom filter provider webpart which implements ITransformableFilterValues to pass parameter value to moss report viewer webpart.

However, this interface only allows to pass one parameter. Please can someone guide me through correct resource which allows my custom filter provider webpart to pass multiple parameters to report viewer. E.g if my report has 5 parameters then my filter provider webpart should allow me to make connection with report viewer and pass all 5 parameters.

Ratio to Parent by Multiple Dimensions on both Row and Column Axes



I recently read "Percentage of Parent for all dimensions" thread ...To say the least, it was eye-opening...The amount of effort and detailed explanation that Tomislav Piasevoli put in was tremendous and helpful. I'm doing the same thing for our BI requirements, and I practically copied the entire code and see that it works for dimensions that are being identified on both Axes (Column / Row). However, the code is not a perfect solution for my situation.It seems that the calculation only works for any single Dimension on each Axis.  If I select more than one dimension onto the Colum / Row axes, the results came out incorrectly for the inner dimensions.

Note that: The possible dimensions that will be used for the "Ratio to Parent" are as follows:


sharing a multivalue parameter of the report accross multiple dimensions ?


My problem is quite simple : I'm generating a report that uses 2 cubes as sources. The 2 cubes have a time dimensions. 

These time dimensions are multivalued parameters for the report.

Today the user needs to select multiple time the periods he's looking for. I would like him to select his values only once and then pass them to all the parameters.

For example, he would select Q1 2009, Q1 2010, Q2 2010 and all the time parameters would take these values.

Any idea ?

how to create multiple dimensions on single parent column


How i cant create multiple dimensions on single parent column? 

This is the senario


Workflow fact table

Wf_id (int)






Department Dimension Table




Now if i create dimension from dimdept , it have only one department name column, how i can use this same lookup to represent the service and source department names? Same senario pops up in sales fact tables as well , like manage_id and salesman_id both looks up to same parent table "Emp_id"

Cannot apply filter on SP dashboard using the 'Budgeting and Tracking Multiple Projects' template


The 'Budgeting and Tracking Multiple Projects'  template provides a dashboard that tracks all projects and their associated tasks/costs/issues etc. Unfortunately this does not filter by the project status so will be a continuous list forever long. I wanted to apply a filter such that only items where the status = Open is displayed. I tried this in SPD but adding filters would not work. If I add a rule to say = Open, nothing is displayed or if i enter != Complete then everything is displayed regardless. Additionally, sort conditions are not recognised either. a similar problem was posted on another forum with no answer. the problem is described in full detail.


Filter document library based on multiple lookup values



I have a very unique requirement for MOSS 2007.
Lets say there is a list of projects; A, B, C, etc.
Then there are phases of the project: Design, Develop, QA, etc.
When the documents are uploaded to a document library, a project and phase is selected at the time of check-in.
I want to create a project page to show project documents by showing documents for each phase in a different web part: eg. Design web part, Develop web part, etc. all bringing documents from the document library.
So far, all good. This can be created by using web parts, views and filters, etc.
Now, I want to create a custom list with Username, Project, Phase. like this:
User1, Project A, Design
User1, Project A, Develop
User1, Project A, QA
User1, Project B, QA

Now, if User1 goes to this project page for Project A - the user sees documents in all 3 phases.
if user1 goes to Project B - the user sees only QA documents.
I will be ok with just showing and hiding web parts completely.
or showing the web parts, but filtering out the documents. either is fine.

I have tried a combination of filters, CAML, etc. but getting values from a custom list to apply the filter is where I am stumped. I want the custom list as it will be easier for the end user to manage permissions for each user for each project for each phas

What is the most efficient way to filter on detail lines and have multiple detail lines displaying o



Here is my dilemma - i have 10 different sizes of, let's say, Tshirts in different stores.

I need a report that displays on one detail line a count of how many shirts of size 1 thru 3 i have in store A, B and C (the stores are the columns). and i need a second detail line displaying how many shirts of size 7 thru 9 i have in the same stores. How would i filter the data to display this most efficiently. Also, i will need to total the two lines at the end of the report.


             storeA     B         C

size 1-3      15        10     12

size 7-9     23         1        5


How to use DVWP to filter multiple columns in a document library


I am not new to SP, but newer to developing in SP, so I need some help please.

I am attempting to convert my company away from nested folders on SP. Elsewhere I saw a way to add multiple custom columns to a document library and then use a different web part (I thought the Form Web Part, but that only lets you filter on one column at a time) to filter the document library using those columns.

Ex: I have three columns:

* Market - with the checkbox choices being Employer, Public, Payer, and GovEduLab. A document could be a part of all, some or one of those markets.
* Product - with the checkbox choices being Care Solutions and Behavioral Solutions. A document could be a part of all, some or one of those markets.
* Process - again, checkbox choices being Account Planning, Commissions, Contracts, etc. And again, the doucment could be a part of all, some or one of those markets.

I want to create something that will allow the user to use some kind of "form" to filter find any document that is a Public-Care Solutions-Contract document and only show thsoe documents in the library.

This is what I have been trying to make it look like, but I am not tied to this:

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