.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

finding a value that is between to and from in mdx

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

I have 2 tables,

  1. holds a value (fact)
  2. holds a multiplier

now i need to multiply the fact (table 1) with the multiplier from table 2, where the value from table 1 is between a to and from value on table 2


is there a way to do this with MDX, if so an example would be appriciated.

Raymond H

View Complete Post

More Related Resource Links

Finding Rows in ADO.NET

ADO.NET implements three basic forms to locate Rows - The Find method as applied to the Rows collection, the Find method as applied to the DataView object and the Contains method as applied to the Rows collection.

DataRowCollection Find and Contains Method

The DataRowCollection is a major component of the DataTable. While the DataColumnCollection defines the schema of the table, the DataRowCollection contains the actual data for the table, where each DataRow in the DataRowCollection represents a single row.

You can call the Add and Remove methods to insert and delete DataRow objects from the DataRowCollection. You can also call the Find method to search for DataRow objects that contain specific values in primary key columns, and the Contains method to search character-based data for single words or phrases.

DataView Find and FindRows Method

Using the Find and FindRows methods of the DataView, you can search for rows according to their sort key values. The case-sensitivity of search values in the Find and FindRows methods is determined by the CaseSensitive property of the underlying DataTable. Search values must match existing sort key values in their entirety in order to return a result.

Finding username


Im running a query where it selects a property from the user with the matching username but i dont know how to find out the username of the currently loggedin user.

Please Help!

{ End Bracket }: Finding the Best of the Best


Passion, intelligence, and the love of learning exemplify the ideal Microsoft candidate. Howard Dierking explores these and other recruiting philosophies.

Howard Dierking

MSDN Magazine February 2008

C++ at Work: IRegistrar, Finding Submenus, and More


This month DLL problems, context menus, MFC strings to managed C++, and more.

Paul DiLascia

MSDN Magazine October 2006

Review It: Expert Tips for Finding Security Defects in Your Code


Reviewing code for security defects is a key ingredient in the software creation process, ranking alongside planning, design, and testing. Here the author reflects over his years of code security reviews to identify patterns and best practices that all developers can follow when tracking down potential security loopholes. The process begins by examining the environment the code runs in, considering the roles of the users who will run it, and studying the history of any security issues the code may have had. After gaining an understanding of these background issues, specific vulnerabilities can be hunted down, including SQL injection attacks, cross-site scripting, and buffer overruns. In addition, certain red flags, such as variable names like "password", "secret," and other obvious but common security blunders, can be searched for and remedied.

Michael Howard

MSDN Magazine November 2003

C++ Q&A: Finding a Win32 Handle, HTML in CHtmlCtrl


This month Paul DiLascia discusses how to find windows with GetLastChild and outputting HTML with a C++ procedure equivalent to document.write.

Paul DiLascia

MSDN Magazine August 2003

Finding a control from a control collection



I'm trying to write a bit of code that will format all the numeric values in lables in my gridview. here's what i am doing right now:

On the RowDataBound Event, i create a row object for the row that is currently being bound.
then i go use the FindControl method to grab each label by name.

Problem is there's too many columns in this table and i really dont wnat to have to type it all out. Here's an example of what i am currently doing

' Get row being bound
Dim myRow = e.Row

' Get labes to be formatted
Dim lblMunicipalIncineration = CType(myRow.FindControl("lblMunicipalIncineration"), Label)

' format labels
If lblMunicipalIncineration IsNot Nothing Then
    If Not String.IsNullOrEmpty(lblMunicipalIncineration.Text) Then
        lblMunicipalIncineration.Text = FormatNumber(lblMunicipalIncineration.Text, 0, TriState.False, TriState.False, TriState.True)
    End If
End If

Can i use myRow.Controls to grab a list of all the controls and then somehow get a list of all labels in the collection and then use a for loop to go through and format each label?

Finding correct "system.webServer / modules / add"

For example, in web.config you can use... <system.webServer>      <modules>         <remove  name="DefaultAuthentication"     />         <add     name="DefaultAuthentication"     type="System.Web.Security.DefaultAuthenticationModule" />      </modules>   </system.webServer> ...for getting rid of precondition="managedHandler". Where can I find the names and types of the other modules? I suspected that somewhere in the hierarchy there should be some XML describing the defaults. However, I cannot find it. Am I missing some machine.config, web.config file? Michael G. Schneider

Finding a WPF control by Name in a Panel

How can I loop through the controls collection of a WPF panel and find a control by name?  The StackPanel1.Children(0).Name property does not exist. I looking for a method equivelent to this WinForm code... Friend Function DBX_FindControlByName(ByRef objContainer As Object, _   ByVal strControlName As String, _   ByRef objFoundControl As Control) As Boolean   Dim objControl As Control = Nothing   If Not IsNothing(objFoundControl) Then Return True   Try   'objContainer must be a controls collection like Me.Controls   For Each objControl In CType(objContainer, Control.ControlCollection)   If objControl.Name.ToUpper = strControlName.ToUpper Then objFoundControl = objControl   Exit For   Else   If objControl.HasChildren Then   'This control has children so it must be a container DBX_FindControlByName(objControl.Controls, strControlName, objFoundControl)   End If   End If   Next   Return True   Catch ex As Exception strErrMsg = "DBX_FindControlByName." & objControl.Name & ": " & ex.Message   End Try   End Function Thanks. Mike

Finding broken links in a web of Pages

I have a dozen sub-sites all with large Pages libraries of .aspx pages created and maintained under the Publishing features on  MOSS 2007.  Some links also go to Document libraries. How do I detect broken links within the web of .aspx pages? 

Silverlight finding dependency

Hi, We are building a Silverlight based LOB application. Per the business requirements the fields which will be bound to Silverlight screens has dependency in the form of rules. The below example can be more helpful to understand.    public class Model     {         //properties         public int A { get; set; }         public int B { get; set; }         public int C { get; set; }     }       //different assembly     public class Rules     {         private Model model;         public Rules(Model model)         {             this.model = model;         }           public void Rule1()         {             // some logic         }                  public void Rule2()         {    

Finding the next..IP

Ok so i am writing a quick little web app to keep track of our ips we have for our server network.  When i click the button to request a new ip i want it to find the next free ip in the list.  Now i have not created any tables yet. 1.  Not sure how ot right that query 2.  Not sure of what my table structure should be like. The data i would like to collect would be the following1 What is the ip for This would be dropdwon list example Server,Switch,router 2. device name -  User input 3. Make 4. Model and so on I guess what i need help on is writing a query on how to find the next aviable ip.  Now  if let say i decomision a server that ip beccomes aviable again it should find that in the list as a next aviable ip. Thanks  Mike

MVS View not finding the Model

The class I created as a model is not listed in the "View data class" dropdown when I try to create a strongly typed view?   What can I do to solve this? 

View not finding Model

The class that I created as Model is not listed in the "View data class" dropdown while trying to creat a strongly typed view for it.    any ideas what to do?

Linq Ouery / Code / Logic for Finding Best Selling Products

Hello ExpertsPlease do reply as i am a beginner ..This is a table Named Products .. I want to show Best Selling products in a Datalist .. kindly tell me the logic for doing so by providing some examples or code by using LINQ ... Kindly help me .. [ProductId] [int] IDENTITY(1,1) NOT NULL,    [Name] [nvarchar](400) NOT NULL,    [ShortDescription] [nvarchar](max) NOT NULL,    [FullDescription] [nvarchar](max) NOT NULL,    [AdminComment] [nvarchar](max) NOT NULL,    [ProductTypeID] [int] NOT NULL CONSTRAINT [DF_Nop_Product_ProductTypeID]  DEFAULT ((1)),    [TemplateID] [int] NOT NULL,    [ShowOnHomePage] [bit] NOT NULL,    [MetaKeywords] [nvarchar](400) NOT NULL,    [MetaDescription] [nvarchar](4000) NOT NULL,    [MetaTitle] [nvarchar](400) NOT NULL,    [SEName] [nvarchar](100) NOT NULL,    [AllowCustomerReviews] [bit] NOT NULL,    [AllowCustomerRatings] [bit] NOT NULL CONSTRAINT [DF_Nop_Product_AllowCustomerRatings]  DEFAULT ((1)),    [RatingSum] [int] NOT NULL,    [TotalRatingVotes] [int] NOT NULL,    [Published] [bit] NOT NULL,    [Deleted] [bit] NOT NULL,    [CreatedOn] [datetime] NOT NULL,  

Finding the data within a particular range

I need to create a report that will show the list of data that is within that range of period. The scenario will be: - the user will choose the starting month and the ending month from a drop down list. (for example, starting month = July and ending month = September) - then the report will be showing all the data within that range of month chosen by the user. (data from July until September will be shown, including data from the month of AUGUST) - the problem I'm having is that when I choose the starting month and ending month as shown above, I only get the data from the month of JULY and the month of SEPTEMBER, the data from month of AUGUST will not be shown. I'm not sure on how to write the SQL statement??? Needed help from anyone who knows how to solve this porblem.. Thank you..
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