Tag Archives: Microsoft

Cannot use Open with Explorer in a SharePoint library – solved.

Leave a reply

Cannot use Open with Explorer in a SharePoint library – solved. (“Your client does not support opening this list with Windows Explorer”)

The problem.

When browsing in a SharePoint document library, there is an option on the ribbon bar to Open with Explorer.  This is very exciting because you could copy and paste multiple files into SharePoint or move them from one folder to another.  When clicking on this button you get “Your client does not support opening this list with Windows Explorer”.

The solution.

The solution is to add a registry entry.  The root problem is that in this situation, your credentials are not passed when the target URL has a dot in the address.  The following procedure, from this Microsoft article describes how to fix things:

  1. Click Start, type regedit in the Start Search box, and then press ENTER.
  2. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
  3. On the Edit menu, point to New, and then click Multi-String Value.
  4. Type AuthForwardServerList, and then press ENTER.
  5. On the Edit menu, click Modify.
  6. In the Value data box, type the URL of the server that hosts the Web share, and then click OK.
    Note   You can also type a list of URLs in the Value data box. For more information, see the “Sample URL list” section in this article.
  7. Exit Registry Editor.
Advertisement

MSC-ERR-0008 An error has occured at the transport layer and OP-ERR-0181 At least one invalid member – Cognos and SSAS errors

Leave a reply

MSC-ERR-0008 An error has occurred at the transport layer and OP-ERR-0181 At least one invalid member – Cognos and SSAS errors

A client has found a solution to two errors occurring in an environment with Cognos 10.1 and SQL Server 2008.

  • MSC-ERR-008 An error as occurred at the transport layer.
  • OP-ERR-0181 At least one invalid member reference was encountered in the query.

A hot-fix was applied to Windows as described in these two following articles and initial testing has been positive. The scenario is a single sign-on Cognos environment with Active Directory using Kerberos to authenticate to SQL Server Analysis Services 2008. The errors seemed intermittent.

http://blogs.msdn.com/b/psssql/archive/2009/04/03/errors-may-occur-after-configuring-analysis-services-to-use-kerberos-authentication-on-advanced-encryption-standard-aware-operating-systems.aspx

http://support.microsoft.com/kb/969083

Microsoft Announces New Developer Certification – MCSD

Leave a reply

Microsoft Certified Solution Developer – MCSD

Microsoft has reworked the certification process for developers and introduced a new MCSD – Microsoft Certified Solution Developer credential. This redefined certification now addresses new generation developers by including cloud and application marketplace domains. In this way, they intend to embrace the current technologies.

The new certification is created around Visual Studio 2012, a development environment that allows applications to be built across devices and for specific devices. The focus is fast, light and stunning. The skills required go beyond the traditional environments and extend to the new world of multiple platforms.

The new MCSD certification will be useful to establish credibility in the new world of development. It demonstrates the ability to compete in the latest markets.

The first MCSD certification will be be MCSD: Windows Metro Style Apps. This will focus onskills needed to create beautiful, elegant and fast apps using Windows 8 with Visual Studio, HTML5, and C#.

There’s a free ebook from MS Press to help get started: Programming Windows 8 Apps with HTML, CSS, and JavaScript (First Preview).

Problem using an SSAS data source in IBM Cognos Framework manager

8 Replies

When trying to use a Microsoft SSAS OLAP cube data source in Framework Manager you get this error message:

MO-ERR-0028 The user starting the process doesn’t have the correct privileges

The solution is as follows:

  1. Use a network domain account for the Cognos service
  2. On Cognos server, in Local Security Settings under Local Policies/User Rights Assignment add the cognos service account to “Act as part of the operating system”
  3. ON SQL Server give cognos service security access to cube
  4. For the SSAS Data Source in Cognos Connection use IBM Cognos 8 service credentials for Signon.

Business Intelligence in the Clouds

2 Replies

Cloud computing is high on hype but I think it’s going to cross the chasm. Cloud computing is IT infrastructure as a service. It is on-demand CPU, disk space and software that is virtual and scalable and available via the Internet. It opens the possibility of any software developer to have a web app available that can grow or shrink with demand. For example, a store front may need to grow by orders of magnitude over the Christmas holiday shopping season but need much less capacity in the following months. A cloud solution allows you to pay for what you use. This scalable infrastructure on demand seems to be a great architecture for a business intelligence solution except for two questions. Will it meet security requirements and will there be enough bandwidth to transfer data to the data repositories?

 

At Market Street Solutions we are researching the use of cloud computing resources in business intelligence and performance management. We are creating example architectures in Microsoft, IBM Cognos and QlikView. My project is to create a prototype Microsoft Business Intelligence server in the cloud. I will be using Microsoft SQL Server with Analysis Services and Reporting Services along with SharePoint and PerformancePoint on an Amazon EC2 instance.

 

I’m building a model BI server on Amazon’s Compute Cloud — EC2. The process involves creating key pairs, security groups, Elastic Block volumes, images, instances, AMI’s, S3 buckets and several other terms that that business intelligence professionals didn’t use on a daily basis, if ever. I think that this is going to shake the foundations of IT and the way we build systems.

Installing PerformancePoint on SQL Server 2008

Leave a reply

If you are installing PerformancePoint Monitoring Server on SQL Server 2008 there are some prerequisite steps.  PerformancePoint Monitoring Server requires SQL Server 2005 client component software.  After SQL Server 2008 is installed and properly updated, then Cumulative update package 9 for SQL Server 2005 Service Pack 2 must be installed.  This CU9 is a hotfix and has to be requested at http://support.microsoft.com/kb/953752. 

 

After applying the SQL Server 2005 update, PerformancePoint 2007 can be installed but not configured until after PPS SP2 is applied.

 

Microsoft’s Technet has step by step instructions for these installations and updates at:

http://technet.microsoft.com/en-us/library/dd335966.aspx

Microsoft Business Intelligence Webinar – 3/17/09

Leave a reply

We are presenting a free webinar on Changes in Microsoft’s BI Strategy at 2pm on Tuesday, March 17th. We will introduce Microsoft’s BI strategy, explain how it evolved, show how organizations can benefit from recent licensing changes, and give a live demo of creating scorecards and dashboards.

In January, Microsoft announced a major change in their business intelligence product strategy. PerformancePoint – Microsoft’s dashboard, analytics and scorecard creation software – will no longer be a standalone product and going forward will be included with SharePoint Enterprise. This is a significant change considering that previously PerformancePoint Server carried a list price of $20,000 per server and $199 per user. Now firms that already own SharePoint Enterprise and SQL Server can use PerformancePoint to begin creating and deploying business intelligence solutions.

Details and registration can be found at Changes in Microsoft’s Business Intelligence Strategy

SQL Server 2008 SSAS training scheduled

Leave a reply

We are scheduled to deliver the Microsoft course – 6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services – at New Horizons in Chattanooga on 4/27/09 – 4/29/09.  This should be the beginning of a great partnership between Market Street Solutions and New Horizons.  We can leverage our expertise in business intelligence using Microsoft SQL Server and Dynamics combined with New Horizon’s learning center and training sales and administration experience.

Training courses

Leave a reply

Preparing for a four day private training course for a client.  We are delivering Intro to Business Intelligence, SQL Server 2008 Analysis Services (SSAS), SQL Server 2008 Integration Services (SSIS), Sql Server 2008 Reporting Services (SSRS) and PerformancePoint/SharePoint dashboard and scorecard building. 

I recently was made a Microsoft Certified Trainer along with one of my colleague, Carl Sheffield.  We, along with Jeff Wall, MCT in process, will be delivering the courses.  The time is abreviated so our objective is to achieve a learner level of understanding of business intelligence and the Microsoft tools involved.  They will have heavy hands-on labs to make them comfortable with the basic use of the tools.

It’s amazing how much more you learn about a subject when you have to prepare to teach it.