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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Finding rolling costs for 13 months

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
 
Hi Experts, I need urgent help on this issue I have a formula 'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])' which calculates rolling costs for last 13 months e.g today current month + last 12 months ,but when i drill down to hierarchy level 8 it shows me few records of year 2006 also,i think this shuld not be case,coz formula should show me records till july 2009 (assuming go back 13 months from current date) can you please gude me are there any corrrections is formula or if i m going to level 8 -drill down then it will include costs for 2006 also? I'm unable to make any firm conclusion on thisHi Experts, I need urgent help on this issue I have a formula 'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])' which calculates rolling costs for last 13 months e.g today current month + last 12 months ,but when i drill down to hierarchy level 8 it shows me few records of year 2006 also,i think this shuld not be case,coz formula should show me records till july 2009 (assuming go back 13 months from current date) can you please gude me are there any corrrections is formula or if i m going to level 8 -drill down then it will include costs for 2006 also? I'm unable to make any firm conclusion on this


View Complete Post


More Related Resource Links

AGE CALCULATION IN YEARS AND MONTHS

  
How to calculate childs age,but when i enter childs age as '03/27/2007' it returns 3 years where as actual age is 2 yr 11 months

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


Gathering MOSS: New Dev-Centric Features In Office SharePoint Server Keep Your Apps Rolling

  

Microsoft Office SharePoint Server (MOSS) 2007 provides great portal and search features and much more, and Ted Pattison puts them to good use here.

Ted Pattison

MSDN Magazine August 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

  

Hello,

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?


Display name of months on x-axis in a chart

  
Could you please let me know if there is any expression which can be used to display the months on x-axis of the column chart. I've tried playing with the Axis option trying to change the interval type to "months" but it is not giving the result. Thank you.

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? 

PerformancePoint filters arranging months out of order

  
I have a pretty simple analytic chart on my sharepoint site. The columns are The name of the location, and the month, and then all of the data is in the rows.   so basically it looks like this                   Place 1                                  Place 2           jan feb mar april may june             jan feb mar april may june row1 row2 row3   You get the point. The problem is, I want to have two filters; one that filters by the locations, and one that filters by the months. When I created the locations filter and connected it to the grid, it made all of the months go in alphabetical order instead of the correct order, like so:                 place 1          aug dec jul nov oct row1 row2 Obviously, this is not how a calendar is supposed to look. I already changed the properties in my sql cube to make the months go in the correct order in the unfiltered chart. They are ordered by the key, which is mont

Algorithm for Computing Age in Years, Months and Days?

  
I am generating a crystal report.net that compute age of a person through formula. of course, there is the birthdate and current date. I am familiar with the datediff function but I want to compute is like: "18 Years, 2 Months and fifteen days old." it should include the leap year. Any Algorithm that I can apply to crystal report formula? Your help is very appreciated.

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()         {    
Categories: 
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