.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

Calculated Series Period

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

If there is less data than the period value for the calculated series then the entire chart does not render and I get the ugly message 'Formula error - There are not enough data points for the Period'.  Reducing the period to an artificially low value to prevent the error is pointless really.   The period value cannot be formula driven so what options are available for at least displaying the normal values, or perhaps paramaterising the period value?

Colin.




View Complete Post


More Related Resource Links

How to do a calculated series in 2008 R2?

  
An RDL from pre-R2 shows a calculated series section in the chart data context menu, however I can see no way to add a new one.  How?

Formulas used for Calculated Series

  
I'm trying to find documentation on what the formulas are that are used for the various selections for SSRS 2008 Calcuted Series.  In particular, the Performance formula appears to be based on the slope of the underlying data points.  But, what is the true calculation used?  I can not find this information anywhere (in MSDN and in searches).

mdx calculated measure sum of sick duration for all sick cases ended in period T

  

Hello,

I'm using SQL server 2008 standard edition.

I have a cube with measure groep sickness, and dimensions date and employee.

In the sickness fact table i have employeeID, sick ID, sick start date, sick end date. The employeeID is linked to employee dimension, and both the sick start date and end date are linked to the date dimension.

Now i want to create a calculated measure, which calculates the sum of the duration of all sick cases that ended in period t.

So that I later can create a report with on one axis the period (months) and on the other axes the sum of the duration of all sick cases ended in that month.

I already have a measure which counts sick duration. But how can I add the condition that it only takes the sick cases ended in a period?

Regards, Hennie

 

 


mdx calculated measure sum of sick duration for all sick cases ended in period T

  

Hello,

I'm using SQL server 2008 standard edition.

I have a cube with measure groep sickness, and dimensions date and employee.

In the sickness fact table i have employeeID, sick ID, sick start date, sick end date. The employeeID is linked to employee dimension, and both the sick start date and end date are linked to the date dimension.

Now i want to create a calculated measure, which calculates the sum of the duration of all sick cases that ended in period t.

So that I later can create a report with on one axis the period (months) and on the other axes the sum of the duration of all sick cases ended in that month.

I already have a measure which counts sick duration. But how can I add the condition that it only takes the sick cases ended in a period?

Regards, Hennie

 

 


Chart display issue with Moving Average Calculated Series

  

I have successfully produced a line graph containing 2 data series; a count of events by month and a moving average (5 month period) of said events.

My problem is trying to limit the chart to show ONLY a certain period of time.  In order to generate the Moving Average (calculated series) I had to make the query go further back in time to count the previous months' events.

For Example:  Chart should display Jan2010 through Oct2010, EventsPerMonth (series1), MovingAVG (series2). 

At first it displayed back to the begining of the data which was Sept2009 - Oct2010.  I figured out how to cut it off at Jan2010 using the Horizontal Axis Properties > Scalar features.

Final issue: I need to get the first data point (Jan2010) off of the Y-axis as a starting point.  Basically I need to shift it one interval to right, leaving a space, so that there is no line connected between the data line and the Y-axis. 

This is difficult to discribe, I apologize if this isn't super clear. 

Thank you!

 


ASP.NET, HTML, JavaScript Snippet Support (VS 2010 and .NET 4.0 Series)

  
This post covers another useful improvement in VS 2010 - HTML/ASP.NET/JavaScript snippet support. Snippets allow you to be more productive within source view by allowing you to create chunks of code and markup that you can quickly apply and use in your application with a minimum of character typing.

Visual Studio has supported the concept of "snippets" for VB and C# in previous releases - but not for HTML, ASP.NET markup and JavaScript. With VS 2010 we now support snippets for these content types as well.

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

  
.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET AJAX
.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

  
When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.

VS 2010 and .NET 4 Series

  
VS 2010 and .NET 4 are the next major releases of our developer tools and framework. Together they contain a ton of new functionality and improvements that I think you'll really like, and which make building applications of all types easier, faster and better. The improvements range from nice small tweaks to major, major enhancements - and can be found across the .NET Framework, the languages, and the IDE.

GridView Sorting/Paging : 'REAL' AJAX with Asp.Net Series

  
This is a continuation of my 'REAL' AJAX with Asp.Net (not Asp.Net AJAX) series posts for those of us trying to stop relying on Asp.Net 'AJAX'.

Ok, nothing too dramatic to start things off, we are going to make some tabled data sortable and pagable all without using a bit of postback. Not only that, but it is going to be incredibly easy!

Free Series of SharePoint Workflow How-to Videos

  
This is the series of "How to" Document Workflow with SharePoint using Visual Studio 2008 (using the .NET Framework 3.0 for backward compatibility to Visual Studio 2005). I have created video's that show the most common requests that I have seen around MOSS/SharePoint 2007 workflow & document workflow.

Feature available to Silverlight 4 with VS 2010.

  
In Part I of this article series we have seen some features available to Silverlight 4 with VS 2010. We will continue to explore more in this article.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no

  

Hi,

 I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.

Thanks in adavance.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlCl

Get A Raise: Discover a Series of Fortunate Event Handlers in Visual Basic

  

You may use them every day, but how much do you really know about events? What's going on when you add an event handler to a class? In this article, Ken Getz demonstrates various ways to interact with events and event handlers, and shows how they can solve common problems. Along with the article, you can download two sample applications (one for Visual Basic .NET 2002 and 2003 and one for Visual Basic 2005) and follow along.

Ken Getz

MSDN Magazine June 2005


Resource File: Windows Media 9 Series Digital Rights Management

  

If you have an application that handles Windows Media content and you need an effective way to track content usage, Windows Media 9 Series now offers Digital Rights Management (DRM). It allows you to take advantage of the peer-to-peer distribution model and still redirect users back to your app once they have downloaded your content (prior to viewing).

MSDN Magazine May 2003


How to get character count in 'Multiple Text 'column using Calculated Column?

  

Hi All,

I have a multiple text box in a list

I want

  • A column which lists number of characters in multiple list column example 188, 199 etc
  • Multiple character column must not have more than 200 chars
Is this possible?

Appreciate all the help!

-saumil


Calculated Columns in a Form Library receive error: Value does not fall within the expected range.

  

I have a forms library that posts the date the form was created. We would like to create a calculated column that allows us to look at these forms based on the month and year they were created. I had created a calculated column that extracts the month and replaces the number with a text string by using an if statement; "IF(MONTH([Proposal Date])=1,"January","") It goes on to evaluate each month and replace the number with the text string. This formula worked for quite some time, though now when I try to add any calculated columns or edit any existing calculated columns on this form library I receive the following error: Value does not fall within the expected range. Now my existing calculated columns (like the one above) do not work and I can not create new calcualted columns. Any insight would be awesome as this has been plaguing me for a couple of months now.


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