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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Cannot View Dashboard with Time Intelligence Post Formula

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :SharePoint


I am using PerformancePoint DashBoard Designer to create a dashboard that allows user to select a date from the calendar that must be displayed by the Time Intelligence Post Formula filter, but when i try to Preview the dashboard, i get a blank page, and the following title : PerformancePoint[2] with the contexte menu.

Can you help me to resolve this problem, and viewing the dashboard with the calendar filter correctly?

Thanks all.


View Complete Post

More Related Resource Links

Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


Time Dimension Enhancement with Business intelligence Issue

Hi all, I want to add a year over year growth using the BI wizard (Time diemsion enhancement) but when I try to add this enhancement via the wizard then this last one has the button next disabled with a waning that says   A time dimension is required to enable this functionality. Ensure that you have a dimension of type Time, that contains at least one hierarchy with a level flagged as a time period. Inspite of the fact that I added that time dimsension with one hierarchy Time hierarchy Calendar Year Calendar Semester Calendar Quarter Time Key(With namecolumn defined as a named calculation that repsents the day with this format  yyyy, dd mm ) Me personaly I have a doubt about the last condition of the warning (with a level flagged as a time period) but I dont know exactly 1. If my doubt is right 2. What shoud I do to enhance the cube in this context using the time dimension enhancement The complexity resides in the simplicity

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

Remove time from Month Calendar view

We have a calendar part on a page that has very narrow boxes for each day. As such we want to remove the time from appearing before the title of the event. I have managed to do this through css where there is only one event. However, have not been able to remove it where there are mutiple events. Any ideas on how this can be removed in both scenarios? Cheers, Theo

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

i have a XML File how to create a Tree View and how to get & post xml to cgi

<?xml version="1.0"?><Hierarchy>  <HD id="Acct">    <SH id="Books">      <TRK id="Annual">        <TGT id="ABA.0001">Closure of accounts for 2009-10</TGT>      </TRK>      <TRK id="Monthly">        <TGT id="ABM.0003">Finalization of expense accounts for Jun</TGT>      </TRK>    </SH>  </HD>  <HD id="Admin">    <SH id="GH">      <TRK id="Eqpt">        <TGT id="AGE.0001">Shifting of BSNL Landline.</TGT>      </TRK>    </SH>    <SH id="Offc">      <TRK id="Eqpt">        <TGT id="AOE.0002">Routine Maintenance</TGT>        <TGT id="AOE.0003">Electrical Eqpt Procedures</TGT>      </TRK>     

Scorecard Time Intelligence Question

I have what should be a very simple question. I have a score card that I want to use to display information from the previous month, and only the previous month. I set the time intelligence to month-1, but when I add information for the current month, it just adds to last month's goals. What can I do about that? Similarly, I would like to make a score card or some other kind of report that shows the month to date and how far off the target they are. Would I use monthtodate as the time intelligence?

Change value of particular cell in Grid view at run time.



I need to know that how i can edit the particular cell value in grid view at run time just by clicking it(value) then it shows text box and after enter any value, it then save in database.

Waiting for response.

Thanks in advance.

DBType change from compile time to run time. I am not using a view, it is against the oracle db I do


The OLE DB provider "OraOLEDB.Oracle" for linked server "SOMESERVER" supplied inconsistent metadata for a column. The column "ACTIONITEMID" (compile-time ordinal 1) of object ""SOMESERVER_Action"."AI_ACTIONITEM"" was reported to have a "DBTYPE" of 130 at compile time and 131 at run time.

Anonymous user to comment on post, does not allow anonymous user to view pending post SharePoint 201


I have created a Blog site using SharePoint Foundation 2010 , I made allow anonymous access to this site 

and i also made anonymous user to Comment on the Post and View the comment for the Post .  

http://<server_name>/Blog/Default.aspx  this is the default Page were we can see all the Post ..

When i Click on the Comment http://<server_name>/Blog/Lists/Posts/Post.aspx?ID=1 i am redirected to this page 

I have also allowed content approval for the Comment Submitted by the anonymous user 

but the Problem is that Anonymous user can see all the Comment for that particular post before approved.

Please help for this...

Problem binding a collection to a view model on POST when manipulating the DOM with javascript.


Hi, i'm currently working on a strongly typed view and i'm binding a collection to a table like this:


for (int i = 0; i < Model.Cars.Count; i++)





<%= Html.Hidden(String.Format("Cars[{0}].Id", i),




<%= HtmlTextBox(String.Format("Cars[{0}].CarModel", i),



SharePoint Designer seems to time out generating some data view web parts, reasons?


I am trying to add a few DVWPs to my site's default page using SharePoint Designer. I find that I can add some of these with no issues, I pick the data source and 'Show Data' immediately shows the fields to select from. For another list, selecting show data leads to a long period where SPD appears not to be responding before eventually returning the message 'The server could not complete your request.....'. Clicking 'Details' shows that there is no message returned.

The list I am attempting to query now contains only 2 rows of test data. If I drop a list view web part of the same list on the same page the data appears instantaneously.

Any suggestions on why some lists could prove problematic in a DVWP in Designer?

EDIT: If I select to convert that List View Web Part to a Data View I get the same lack of response from Designer

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.

SSIS - OLE DB from VIEW takes long time



I have a question regarding SSIS 2008 and how it handles views. I hope the answer for this question will be a quick "Get a hotfix" heh.


I am experiencing a very odd behavior with setting up a View as a data-source in OLE DB. I have set up a a very simple package (for experimenting) with a Data Flow Task that has only two components, Data-Source and Data-Destination. I have set the data-source to a view and the destination to a table in the same database.

Note: I am developing the package on the server itself.


  • While trying to preview data-source I get an error, "Query Timeout expired (Microsoft SQL Server Native Client 10.0)
  • When executing the package Validation, Pre-Execute phases are complete but no rows are passing through the buffer. I have waited over 12 hours before stop the job. Checking the monitoring verified that IO was on 1. And that no object was locked , which may have caused the package to run so long or not to retrieve data.
  • When connecting to SSMS and doing export of data from the view - it also retrieves no data and the process seems to be stuck.


Additional data:

  • T

How to view the expression formula field on a report


We built this report on 2005 ssrs and recently switched to 2008 versionand now having problem to get to the expressions which was written on some formula fields.

I located the field under the dataset, i right clicked when i do i see two choices delete and properties i chose properties.


now in there there is no way i am able to get to the expression.

Thank you very much for the helpful info.



asp.net mvc ckeditor second time real value post problem


I have added ckeditor on my page. the thing is that when i make changes in the value in the ckeditor and post the value to the controller the new posted value is not there (the previous value is coming). the new value comes on posting it second time.the cycle goes on(the changes in the value in the ckeditor comes on the second posting). if i remove the createsuccess call and use html.beginform it work fine(but i have to return the value from the controller). what i am doing wrong

<script type="text/javascript" >

       function createSuccess(context)

$(function(e) {  $('#editor1').ckeditor();



<% using (Ajax.BeginForm("Index" , new AjaxOptions {OnSuccess="createSuccess"})) { %>
<textarea cols="20" rows="20" id="editor1" name="editor1">Abcdedfghijklmnopqrst</textarea>
<input type="submit"  />

<% } %>


 public ActionResult Index(FormCollection frm)

        string a = frm["editor1"];

        var data = new { PreviousValues = a };
        return Json(data);

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.
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