.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

Sharepoint 2007 and Analysis Services KPI

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


Trying to create a KPI in Sharepoint that connects to a SSAS cube/kpi.  I 
have created an .odc file that contains the account for connection.  It is 
also the Web application pool for the Sharepoint Web Application.  The .odc 
works fine for excel services and you can drill into cube,etc..., but when 
used in Sharepoint KPI it produces the following error.  

This data connection does not use encryption for the communication with the 
SQL Server 2005 Analysis Services server. 

The connection was either timed out or was lost

If try to use impersonation it seems to work but the sharepoint user previledges
profiling is lost. The menu is the same for all users. The Sql Analysis Server 2005
is not in 

View Complete Post

More Related Resource Links

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

Sharepoint Managed Metadata Services and Office 2007

Is there a patch or a workaround which would allow you to fill in metadata information pertaining to a column(which is a managed metadata type) from office 2007 client application. Currently it is greyed out and says Edit in server. Thanks KI am what i am

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

Publishing reports from Business Intelligence to Sharepoint Services 2007

We currently have sharepoint services 2007 and SQL server 2005 installed (with reporting services) and Sharepoint SQl web part on a single box named 'king-sharepoint'.   We have sucessfully setup the reporting services from Native to integrated sharepoint with a db name of 'spkingsdb'. We are trying to publish reports to the sharepoint database using Visual Studio, as we are new to sharepoint we are confused as to how to achieve this.  We understand to publish it we need to know the path of the database (reportserver(spkingsdb)), the folder in which the reports will be published to (do we create this? If so then how?), and the server name (http://king-sharepoint/reportserver).  thanks

Word 2007 documents won't open from Sharepoint Services site

I have a Sharepoint Services 3.0 site that contains shared documents, Word, Excel, PDF, etc.  I cannot open Word documents directly from the shared documents portal.  Other file types like Excel adn PDF open fine.  It's only Word that has the issue.  I'm using Word 2007 and it doesn't matter if it is a .docx or a .doc, both act the same.  Word tries tro open, then just sits there....no error message or anything.  Any help would be greatly appreciated!

Sharepoint Services 3.0 - hooking into outlook 2007 / 2010?


I'm looking at creating a Meeting Workplace using sharepoint services 3.0.

I'm reading a lot about calendars and how you can configure them to receive emails & update the calendar & such.

What I want to know is if it can be hooked into Outlook 2007 / 2010 so that it will either directly update my (and other members) calendars, or if it can be configured to broadcast the meeting request to the other members.


How to deploy the reporting services to locahost and integrate it with the sharepoint 2007


I have a probelm with deploying the sql reporting services to the locahost when i provide the TragetServerURL as http://localhost/reportserver
and if i deploy then i get the error has below

A connection could not be made to the report server http://localhost/reportserver.

Additional information
The attempt to the connect to the report server failed.Check your Connection information and the that the report server is a compatible version(Microsoft.Reportingservices.Designer)



Getting Started with Windows SharePoint Services

Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

New Features in Windows SharePoint Services 3.0

Windows SharePoint Services 3.0 (WSS 3.0) is the next version of WSS 2.0, released on 2007, and Microsoft Office SharePoint Server 2007 (MOSS 2007) is built on top of this. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. WSS 3.0 offers a lot of new features and programmability support. I have consolidated a list of new features and enhancements in the below section:

Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible

SharePoint 2007 Workflows - Things to Consider Before You Start

SharePoint 2007 (MOSS) utilizes the Workflow Foundation (WF) to enable workflows on lists and content types. But before you start doing cartwheels there are few things you should know before you get started. The experiences I'll be discussing are not from book smarts but from building real MOSS solutions that are in production today.

Writing Custom Web Parts for SharePoint 2007

As I mentioned in an earlier blog post, SharePoint 2007 is built on top of ASP.NET 2.0, which means you can now use ASP.NET 2.0 features (Forms Authentication, Master Pages, Membership, Site Navigation, New Data Controls, etc) when building SharePoint sites. This is true for both the new Windows SharePoint Services 3.0 version (which will be a free download) as well as Microsoft Office SharePoint Server 2007 (which costs money).

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

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