.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

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

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 

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?

 




View Complete Post


More Related Resource Links

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

 

 


Calculated Measure Help - Comparing Months from two Date Dimensions

  
Hello:   I have a Measure Group that has two Date dimensions, a Reporting Date and a Fee Paid Date. The Reporting Date and the Fee date is based on the same Dimension, which has a standard YQMD hierarchy. It's very typical. The calculation is called "Fees Paid In Same Period", and it would display the Fees paid if the Reporting Month equals the Fees Paid Month.   How do i do this?   Thanks,

ListViewControl - how to group items by their value, for eg. date range

  

Hi,

I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


January

Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)

February 

Yoga Class (15th Feb 2010 - 16th Feb 2010)
 etc...


Thanks for help.


Why can I not group by calculated field in Date format?

  
After migrating to SP2010 Foundation, I've discovered that for some reason I can't group a list by a calculated date field. Ex: Create a list with a date column A. Create another column B with a simple calculated date of [A]+1 and use the field format type 'date' Modify view to group the list by column B.  You're list will load, but when you attempt to expand one of the groups you'll be greated with an exception error. Why?? Am I doing something wrong? Note: You can group fine if the data type for column B is anything except 'date' format, but I really need to group items by a calulated date. Ultimately, what I'm trying to do is group my list items by week by calculating the end of the week using a simple formula =[Must ship by]+7-WEEKDAY([Must ship by])  then I want to gropu by the [Must Ship by] column like I always did in SP 2007, but now it errors out.  I also wanted to create my own timesheet template since the Fab 40 templates aren't available for 2010, but I can't really do that effectively without being able to group timesheet entries by week.  

Previous working date - Time dimensions

  

Hi all,

I need an mdx to get the previous working day. 

I`ve got my complete time dimension, including weekends.  Every day member has got a Member Property that says wether it is a working day or not.  See table below.  Then, I need an mdx expression to return the "Prev working Day".  Any idea??

 

 

day of the month IsWorkingDay Prev Working Day
01/09/2010      1

how to make start date,end date and people and group readonly using sharepoint designer

  

hi,

how to make start date,end date and people and group readonly using sharepoint designer(sharepoint 2007).

I have created calendar list in that i have people and group column .

In edit mode i want start date ,end date and people and group column read only.

 

very urgent


How to get the Min Time and Max Time By Using Group By Date

  

We Have a swipe machine it will record all the data i.e intime and outimes of employees,I want to get the minimum intime and outime ,I have got it by using min and max functions and by using group by date,but we have Employees who start at evening and work for the next day also ,so my query is failing for these employees,I tried to solve this problem by subtracting 6 and half hours from the time recorded so that the recorded data falls in one date,then i used min and max functions and group by date and finally addedd 6 and half hours to the min and max times then i got all the shifts data also perfectly,but in case there is any shift starting at 6'o clock this query will fail,I want a better solution for this problem can u please help me.

 


How to get the Min Time and Max Time By Using Group By Date

  

We Have a swipe machine it will record all the data i.e intime and outimes of employees,I want to get the minimum intime and outime ,I have got it by using min and max functions and by using group by date,but we have Employees who start at evening and work for the next day also ,so my query is failing for these employees,I tried to solve this problem by subtracting 6 and half hours from the time recorded so that the recorded data falls in one date,then i used min and max functions and group by date and finally addedd 6 and half hours to the min and max times then i got all the shifts data also perfectly,but in case there is any shift starting at 6'o clock this query will fail,I want a better solution for this problem can u please help me.

 


how to create calculated measure in cube that always gives value on Year level in Date hierarchy

  

Hello,

I'm using SQL 2008 standarrd. Probably a simple question,

But I want to creata a calculated measure in a cube that always displays a measure(e.g. total sales) on the year level of the Date-dimension-hierachy.

So wether I choose Year, Quarter, Month or Day, it always shows the measure value  (sales) on the Year level. How to do that?

Regards, Hennie


how to create calculated measure in cube that always gives value on Year level in Date hierarchy

  

Hello,

I'm using SQL 2008 standarrd. Probably a simple question,

But I want to creata a calculated measure in a cube that always displays a measure(e.g. total sales) on the year level of the Date-dimension-hierachy.

So wether I choose Year, Quarter, Month or Day, it always shows the measure value  (sales) on the Year level. How to do that?

Regards, Hennie


MDX - Calculated measure over date dimension

  
I have a fact table made up of products and the effective dates they became active with a measure "Charge".  I need a calculated measure that reports the Variance in the "Charge" based on the earliest "Effective Date" (Min)? and the latest "Effective Date" (Max)?  Is this possible and if so could someone off some help?  Thanks in advance.

Using a CompareValidator to check input is a valid date

  
The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

How To Set a Date Format In GridView Using ASP.NET 2.0

  
A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

jQuery Date picker Implementation in ASP.NET

  
I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

How to format datetime & date with century?

  
Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.

http://www.sqlusa.com/bestpractices2005/centurydateformat/

Date and Time Functions in SQLSERVER

  
Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
4 GETDATE and GETUTCDATE Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

  
Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.
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