.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

Filter rows by Current time - MDX

Posted By:      Posted Date: October 17, 2010    Points: 0   Category :Sql Server
I need to filter by Current time(reporting time).

DimTime has following fields.
Timekey , Time & other fields

Fact table contains the Time key

How do I do this in MDX?

View Complete Post

More Related Resource Links

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

How to insert the Current date and time in to SQL Table..

Hello Members,              I have create the table as per the following ..create table company(  empname varchar(30),  empid int,  joindate smalldatetime)I tried,insert into table values('Kumar',202, ??????)I want to insert Current date and time into table Company.....Please give me the solution...Thanks.. 

Time Intelligence Filter without aggregation

I have a line graph where I am trying to display the drop in a census over time. The report was built using the date level, so If I am showing the current month, or the last 10 days, The graph looks great. The problem is, I want users to be able to sort by Quarter, Semester, and Year. When I do this, I want to display the data by month. That is easy enough. However, when I do that, it adds every day of the month into one value, so instead of displaying a number like, "300," it displays something along the lines of "10k."  What I would like to do is only care about the last day of each month once you get the quarter, semester, and year levels. One solution I tried was setting my time intelligence as Quarter.firstmonth.lastday, Quarter.month.lastday, Quarter.lastmonth.lastday.  This works, if you happen to be in the second month of the quarter. I have also tried passing the second value as Quarter.(firstmonth+1).lastday and Quarter.(lastmonth-1).lastday, but dashboard designer doesn't like that syntax. I have also tried editing the aggregation settings on the measurements in my cube to "no aggregation," and "Last." When I do that and try to deploy the cube, it tells me I can't do that because I am not running the Enterprise version of SQL server 2008. I know the issue just has to be with my formulas, because it looked ok

Can´t get the time intelligence filter to work in PerformancePoint Services/Sharepoint

Hi all, I have created a scorecard in Dashboard Designer based on an SSAS cube which looks ok in both DD and Sharepoint. As I want to connect a time filter to this I have created a TI filter in DD. In Sharepoint I have connected the filter to the scorecard with "send performancepoint values to". In "configure connection" I set source value to "PerformancePoint Values: Formula" and Connect to to "Endpoint_TIFormula". I only need to filter on year and have set the TI properties on the cube. Selected time dimension is "Year", Hierarchy level is set to Year, Member is 2008, reference date is 1/1/2008 and I have associated member level Year to Time aggregation Year. The filter is set up like this in DD: it uses the same data source as the scorecard and I use a list view. I do get the filter to work if I specify one formula for each year (e.g. Formula: "Year" and "Display Name: "2010", "Year-1" and "2009" making up two rows) but that can´t be the right way to do it, right? What i would like is a multiselect tree view where I can choose the year I want and have them display on columns. I have tried the formula Year:Year-2 and in the preview I see [Date].[Year].&[2008],[Date].[Year].&[2009],[Date].[Year].&[2008]. However, in Sharepoint the filter only show on

How to create a list filter like: get all list elements from the current user and all employees from

Hello, is it possible to filter elements by the condition mentioned in the title? Tobias

Display current time (live?) on report?

Is it possible on a report to display a clock showing the current time, ticking? Or, is it possible to display a static picture of an analog clock? I have the current time with an expression, but would love to have it updating real time. Any luck with javascript or anything?

how to get the current date and time using sharepoint designer workflows

hi, how to send an email using sharepoint designer workflow when an item equals to end time. How to get the current date and time.I am able to capture the date but not the time  the time is showing as 12:00:00 AM. First i have create an variable  and storing the date and time in that variable and i am comparing the variable value with end time. If both are equal then i want to send an mail to attendees

Tx Replication Filter rows

I have a subscription that needs to keep some external legacy data static. The Pk for the old data is of len(pk) = 8 and the new data has len(pk_new) = 15. As date field is not available i am using the pk to filter the data coming in from the publisher as follows (select published columns from table where len(pk) > 8. However, i have a question about reinitializing the subscription. When i do so, i only want the new data to be pushed into these tables and to leave the old external legacy data untouched. I hoped using filter would automatically be translated by MSSQL as, for all articles keep existing objects as unchanged, but i guess i have to manually change it on every reinitialization. Please advise. 

How do I populate a Textbox with the current system date and time?

Hello, all! First I am a complete newbie and I have a project that I need help with. I am building a Windows form application to keep track of servers and their last maintenence date. I have a simple one table SQL Express database (empty). One of my rows is set up to store the date and time. But first, I need to know how to auto populate the system date and time to a TextBox control everytime someone opens the application. I have tried using the System.DateTime method in the Textbox event properties as a string but I am doing something wrong. Thanks in advance for your help and guidence!

How can I filter a Sharepoint 2007 libarry list based on current user login?


Hi all.

I would like to know how I can filter a SharePoint library list based on current user login.

Suppose I have created the followings:

1) A SharePoint form library containing bunch of uploaded InfoPath form data.

2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.

I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.

I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK. Apparently [Me] returns a Person/Group data type and the filter cannot compare its value to that of "TargetUser".

I tried using text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me]. The filter accepts the parameter without any error but the resulting fitlered list does not display any items at all.

I have googled this subject for hours but I have not found any solution.

It would be greatly appreciated if anyone can help me t

Adding rows in table at run time?



    I have a table which has few rows.

    A row contain few textboxes, one file upload field and a dropdown list in its cells.

    I want to make it a dynamic table that is i should be able to add extra rows in table at runtime, but I dont know how to do it.

    Please Help.

Calendar View: Unable filter Recurring Event by Start/End Time and Group by Recurring Event View

Hi All,
I have just found several issues with Calendar View from WSS 3.0:

Unable to filter by [Start Time] and [End Time]
I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time.

Unable to use "Group By"
When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column).

Thank you and apprecate for any idea.

Auto Populate current date & time in the New form



I have requirement where I want the current date and time in the newform opened by users. I can get the current date with Today's Date option. But not able to find the time option. Is there a possibility with SPD. Tried using button option to activate a formula to the textbox value so the user can jus click the button to get the current time and date. but facing problem in that.  Kindly advice.



XML with PrimaryKey values to delete rows in database table at a time



I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.

My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??

If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..

My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??

WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method??

Can anyone please help me out clarifying my doubts and also XML Delete Query..


My XML will be like this











Will bulk delete happen in the above case?



Problem with "Current User Filter"


I am trying to create a page that displays documents based on the company of the current user.  The problem that i am experiencing is that the Company field is not available from the Current User Filter.  Any suggestions on how I can filter on this user property.


Thanks in advance



Move up a time hierarchy from current date to return a set of quarters


I have this calculated set to return the previous 3 months.  How do I rewrite to get the last 3 quarters? 



(3,strtomember("[Date].[Month].&[" + Format(Now(),"yyyy-MM") + "-01T00:00:00]").prevmember)

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