.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

SharePoint 2010 Analytic Chart Default ignored when chart opens - uses calendar filter and formula b

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

I created an Analytic Chart and it works great.  All filters work.  When it opens in dashboard designer the chart displays based on the default. There is a calendar filter and the connection formula is Day-15:Day.  When the dashboard is opened in SharePoint the time frame is always based on when the Calendar object was last changed.  How do I get it to initially open based on the MDX parameter default - which is what I see in the Dashboard Designer?  The idea is to initially give user data based on now and then from there user can change time frame and next time the page opens it would always go back to now.

Parameter Default:

{StrToMember("[Calendar Snapshot].[Year-Qtr-Month-Date].[Date].&[" + format(DateAdd("d",-15,now()),"yyyyMMdd") +"]"):StrToMember("[Calendar Snapshot].[Year-Qtr-Month-Date].[Date].&[" + format(now(),"yyyyMMdd") +"]")}

View Complete Post

More Related Resource Links

Open Analytic Chart on New Page In Sharepoint


We have designed a Dashboard with single page

1. A Scorecard --Zone 1

2. Analytic Charts --Zone 2

When a person clicks on any of the KPI on Scorecard corrosponding Chart for that particular KPI is displayed in Zone 2.


So far So good

Now our client has come up with a requirement that

whenever he clicks a KPI the chart should open in a new browser window instead of Zone 2.

Is this possible in Performancepoint 2007 or Sharepoint 2007 if yes then how to accomplish this

SharePoint 2010 Chart Web Part does not appear to work

Using the sharepoint chart web part does not appear to work. Plotting a pie chart from a list with 10 items in it.  Using a numeric field for a Y axis and a choice field for X axis. The choice field has 4 possible selections. Clearly I want a pue chart with 4 slices. What I get is a pie chart with 10 slices, not much use. Fine I thought we've got this optional 'Group by field' so I'll group by my choice field. But then I get a pie chart with one slice?! Am I being dumb or does the chart web part not work properly?

How to create a custom Gantt Chart for SharePoint using VS

So I have been told you can't create a custom gantt chart using SharePoint Designer.  I don't believe that actually, there must be a way to create one from scratch using SPD and a Data View and editing the XSL directly....but assuming there is not..

Are there any articles that explain for a non-developer how to create a custom gantt chart for a SharePoint site using Visual Studio 2008?


SharePoint 2010 Mobile Page Filter Settings

hello, i want to know from where i can edit the mobile page "task" list filter settings ? thanks

Problem Saving Files to A Sharepoint 2010 Site from Office 2010: Saves locally by default rather tha

Hi we are starting to use sharepoint 2010 / word 2010 and have found an interesting bug/problem. Sometimes when a user tries to save a file (by clicking on the save button in the quick access toolbar for word 2010) the save dialog comes up with the users local "Documents" folder as the path (not the correct sharepoint path where the document should be saved).  (I should say that we are creating the file from sharepoint by using a toolbar on the document library, with the new button)  We are using a content type and a template attached to the document library when we create the file.  This is really annoying because the user might not notice that the document is saving locally and not to sharepoint.  I have found a strange workaround which involves clicking the [File] tab on the ribbon in word 2010, then clicking "Save and Send" and then clicking the save button again.  At this point word 2010 seems to "remember" that it is trying to save document to sharepoint and shows the sharepoint document library. This is a real nuisance which could lead to documents being lost/misfiled if people don't realize that this is happening.  Can anyone help me? Thanks Kevin krd

Add "New Calendar" to the site actions menu in SharePoint 2010

I really like how SharePoint 2010 uses Silverlight to allow users to create a new Document Library from the Site Actions menu.  I would like to alter the v4.master page and add a new menu item to the Site Actions menu that allows the user to create a new Calendar.  How do I alter the code below to make a new menu item that will create an events list? <SharePoint:MenuItemTemplate runat="server" id="MenuItem_CreateDocLib" Text="<%$Resources:wss,siteactions_createdoclib%>" Description="<%$Resources:wss,siteactions_createdoclibdesc%>" ImageUrl="/_layouts/images/NewDocLibHH.png" MenuGroupId="200" Sequence="220" UseShortId="true" ClientOnClickScriptContainingPrefixedUrl="if (LaunchCreateHandler('DocLib')) { GoToPage('~site/_layouts/new.aspx?FeatureId={00bfea71-e717-4e80-aa17-d0c71b360101}&amp;ListTemplate=101') }" PermissionsString="ManageLists" PermissionMode="Any" VisibilityFeatureId="00BFEA71-E717-4E80-AA17-D0C71B360101" />

SharePoint 2010 Calendar Webpart not showing overlays

I have made 4 overlays on one calendar and I figured I could add that calendar webpart to the homepage and it would show all the overlays, but it isn't doing that.  Is there a way to show all the overlay calendars in the calendar webpart? Thanks!

default value for MySite's 'As Seen By' web part in SharePoint 2010

Does anyone know how to change the default value for the 'As seen by' web part on the SharePoint 2010 MySite's person.aspx page? Currently it defaults to "Everyone' and our client would like it to default to 'Only Me'. Is this even possible? Regards, Kyle

Does sharepoint 2010 beta 2 supports persian calendar ?

Himy question is that does microsoft provide persian calenadr in sharepoint 2010 beta 2 ?as u know in .net 2.0 and above, microsoft has add support for persian canlendar with this class System.Globalization.PersianCalendar, and also add persian collation in sql server 2008, also some office addon's packages published to support persian languages in offuce 2003, 2007. but do not have offical support for persian calendar in sharepoint 2007. i hope this problem solve in 2010.Honestly i request to managers to help me to0 accomplish this goal.thanks in advance. http://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

How to remove conflict between Sharepoint 2010 Post Cache Substitution and Response.Filter

Under SharePoint 2007 (Win Server 2008, SQL 2008) we made use of Response.Filter to meet certain requirements for accessibility to remove certain markup or add to markup that was missing attributes, etc. When we upgraded to SharePoint 2010 we get the following error message from the pages, unless we remove the use of Response.Filter: "Post cache substitution is not compatible with modules in the IIS integrated pipeline that modify the response buffers.  Either a native module in the pipeline has modified an HTTP_DATA_CHUNK structure associated with a managed post cache substitution callback, or a managed filter has modified the response." I have found several posts including this article http://support.microsoft.com/kb/2014472 that explains that it is definately a problem, but no one has an alternative solution to using the Response.Filter, and the article doesn't say how to disable the use of Post Cache Substitution. So, my question is how do I turn off the use of Post Cache Substitution in SharePoint 2010, or how can I alter the final markup of the page "After" the substitution happens?  Or, if it is a control or three that are using Post Cache Substitution, which one(s) so that I can remove them.

Sharepoint 2010 Calendar

Basically we have setup a Calendar in SharePoint that shows everyones location. The problem we are having is, the default view doesn't show all users just the attendees. I can go to People and select a group and see a week view of the group but this is not very freindly. Is there a way to make the default view show appoinments for a all users or a group of users? If not then is there a wy to defaulthe attendees field to default to a group of users?

Custom Default.aspx SharePoint 2010

I would like to replace the default.aspx with a custom default.aspx.  I have been able to accomplish this with a feature. I am finding the when deployed the new default.aspx page shows up in the following directory C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\ProjectInsightSPMaster_ProjectInsightLayoutFeature\defaultpage I also have a default.aspx located in the following directory.  This is the one that is deployed with the site definition. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\SiteTemplates\PISP    When I browse to a site in IE, it is in fact looking at the correct (new) default.aspx page which is located in the FEATURES directory.  How does SharePoint know to use this default.aspx page instead of the one located in the SiteTemplates directory.  This is confusing to me.  Can you explain?   Is this the correct way of deploying an updated default.aspx?   dave

formula validation setting on column sharepoint 2010

Hi, Hi,  I have a two fields(mailid,cost,mailid2), i need a list validation of mailIds if already existing  mails three time I need a validation for new request , i need a formula for column in validation setting ->formula in SP2010  if mail is already existing validation  i need formula for validation setting for list it's new feature in sharepoint 2010 Regards

Add Calendar through code to page SharePoint 2010 - help

I am add a calendar to a page through a feature.  How do I set the view to be 'All Events'.  Currently the page gets rendered with the calendar in full graphic mode (showing all days in the month). I would like to through code have the calendar be visible by default 'All Events' ..help? I am using code similar to the following.  You can see some of the things i have tried (commented out lines)  ListViewWebPart calendarWP = new ListViewWebPart();                                     SPList calendarList = site.Lists["Calendar"];                                     //SPView view = calendarList.Views["All Events"];                                     calendarWP.ListName = calendarList.ID.ToString("B").ToUpper();                                     calendarWP.TitleUrl = calendarList.DefaultViewUrl;                                     calendarWP.WebId = calendarLis


I'm getting an error when i connect the form(which has a chart object in it) to a database... I've another project where it is already to the database. There i couldn't find the chart object in the toolbox... please help me... PS: i'm using VISUAL STUDIO 2010

Reporting Services Chart in SharePoint Web Part, Broken Image Problem

I have a reporting services report that displays a dundas chart, it is a snapshot report executed daily.  When displaying the report inside a page viewer webpart or a report viewer web part in SharePoint, the first time after a recent snapshot occurs, the image shows up broken.  On refresh of the page the image is visible.

MOSS 2007
SQL Server 2005 Reporting Services NOT running in SharePoint Integration mode.

Any ideas or work arounds to get the image to display on the first load of the page or why the image is broken?  I've tried different report parameters, Format, ClearSesson with no luck.  Viewing the report in Report Manager works fine and also going directly to the ReportServer page is fine.  It only occurs when it's inside of SharePoint inside of the Page Viewer or Report Viewer web parts or even if I manually create an iframe in a content editor web part.


Month Group View in Calendar in SharePoint 2010


Dear collegs,

I have one issue and hope that you maybe can help me.

Namely, I created on new Calendar.  In that Calendar exist 5 standard views (under the main Calendar view) and that are :

1) Day Group

2) Week Group

3) Day 

4) Week

5) Month

What I need is something what missed here - Month Group (namely exists standard view Month but not Month Group).

Do maybe somebody know how can add or make Group Month ? Is for that neccesary some programing or can simply that do only isnide SharePoint.

Thanks in Advance.


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