ProClarity 6.3 Service Pack 3 (SP3) is a cumulative release that includes all fixes made to ProClarity Analytics Server 6.3 and ProClarity Professional 6.3 since the General Availability (GA) release of these products.

*  ProClarity 6.3 Service Pack 3 is a patch build, not a full product build. Before you can install this service pack, ProClarity Analytics Server 6.3 (build 6.3.129.200) must already be installed. Additional configuration is required to deploy ProClarity 6.3 SP3 on Windows Server 2008 with Service Pack 2 (SP2) or Windows Server 2008 R2.

Download site click here.

Note: ProClarity Analytics Server 6.3 SP3 does not include any fixes for ProClarity Dashboard Server 6.3. To obtain the latest updates for ProClarity Dashboard Server 6.3, install the ProClarity Dashboard Server 6.3 Service Pack 2 release.

In order to distribute ProClarity 6.3 SP3 from ProClarity Analytics Server to ProClarity Professional users:
1. On a computer running ProClarity Analytics Server 6.3, open the PAS Administration Tool.
2. In the left pane of the Administration Tool, right-click the Components folder and select New Component.
3. In the New Component dialog box, browse to the location of the hotfix components and select PRO63Hotfix2222.xml.
4. Click OK. The update will display in the details pane of the Administration Tool.
Note: ProClarity Analytics Server security must be configured to enable users to download software.

For more information, visit the ProClarity Analytics Server Solution Center (http://go.microsoft.com/fwlink/?LinkId=166126).

• Read more
• 1 comment(s)

New features, enhancements & fixes:

• Improved messaging when a filter or other selection returns no rows or columns in an analytic grid.
• You can now install PerformancePoint Monitoring Server and PerformancePoint Dashboard Designer on a machine that has .NET 3.5 already installed.
• Improved handling of scrolling on very large dashboard pages from within Dashboard Designer.
• Improved handling of zone adjustments in Dashboard Designer.
• Improved usability of the PerformancePoint Server Web Parts
• Improved Time Intelligence calendar control. This enables easier filtering on dates.
• Better handling for connecting to SQL Server Reporting Services (SSRS) 2008 reports and for displaying SSRS multi-select filter reports.
• Better handling when display conditions and stacked zones are both in use.
• Excel Services report views now load into Dashboard Designer, even with no SharePoint root site.
• Improved analytic chart, show details, and scorecard formatting when exporting to Microsoft Office Excel.
• Improved drill-through functionality on analytic reports.
• Font-size changes in scorecards are appropriately displayed in published dashboards.
• Better handling of scorecard KPIs when using named sets.
• Improved integration with Excel Services: Excel Services reports display properly in dashboards. Empty cells no longer prevent the dashboard author from connecting to the data source in Dashboard Designer.
• Better migration support: analytic charts and grids that are created with SQL Server 2005 Analysis Services data can be updated to use SQL Server 2008 Analysis Services data.
• Improved integration with SharePoint: Now you can use the edit mode in Microsoft Office SharePoint Server or Windows SharePoint Services to add a SharePoint Web Part to a PerformancePoint dashboard; SharePoint style sheets no longer override cell-level font size and font-family settings.
• Improved integration with ProClarity: PerformancePoint Server filters passed to ProClarity reports retain the correct hierarchical order. Sorting of columns in a ProClarity report that is displayed in a PerformancePoint Web Part is now more effective.
• Customers can now upload their own custom Help into PerformancePoint Web Parts.

you can find the link here

Bye,

Ronen

• Read more
• 4 comment(s)

Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database helps to ease provisioning and deployment of multiple databases. Developers do not have to install, setup, patch or manage any software. High availability and fault tolerance is built-in and no physical administration is required. SQL Azure Database supports Transact-SQL (T-SQL). Customers can use existing knowledge in T-SQL development and a familiar relational data model for symmetry with existing on-premises databases. SQL Azure Database can help reduce costs by integrating with existing toolsets and providing symmetry with on-premises and cloud databases.

Please find more information at thus links:

Connecting to SQL Azure database

SQL Azure Tools

SQL Azure Articles, Tutorials and Blogs

SQL Azure Training

SQL Azure Videos

SQL Azure - Migrating databases

SQL Azure Samples

SQL Azure Bloggers

SQL Azure and SQL Server Integration Services (SSIS)

Have fun!

Ronen

• Read more
• No comments

Microsoft officially rebranded the long-developed data analysis add-on at the SharePoint Conference 2009 in Las Vegas this week.

The solution has actually been split into two products:

 SQL Server PowerPivot for Excel and SQL Server PowerPivot for SharePoint. Both are designed to integrate with SQL Server 2008 R2 and SharePoint Server 2010 to create a self-service business intelligence solution for organizations.

• Read more
• No comments

Hello,

I'd like to invite you to our next Israeli BI Group meeting (#7).

When: OCT 28th, Wednesday 17:30.

Where: Microsoft Offices, Ra'anana, 2 Hapnina Street, floor 0, DEKEL meeting room near the reception.

Program:
17:30 - 17:45 Gathering
17:45 - 19: Yossi Elkayam & Franck Sidi – Microsoft Israel. The BI Quest. Comprehensive review on the platform and the future.

19:15 - 19:30 Break
19:30 - 20:30 The BI Quest  Cont…

20:30- 21:00 Q&A
I’d like to encourage you to propose a session about a topic that you think that may interest our group.
If you’re interested, please send us e-mail with the topic and duration (ideally 60 minutes).

Regards,
Ronen Chenn

• Read more
• No comments

Balanced scorecards strive to present an immediately comprehensible picture of a complete organizational strategy. This approach recognizes that the different aspects of a business all influence each other. A Balanced Scorecard examines performance from several critical perspectives. Typically, a Balanced Scorecard depicts four different perspectives:

• Financial perspective   Financial metrics portray the economic results of previous business decisions and actions. Financial metrics generally lag behind actions, and therefore might not necessarily reflect the business as it is run today. However, financial metrics often determine whether a particular strategy is successful.
• Internal Process perspective   The operational perspective reflects the internal business processes that support the strategy. They might include processes related to financial collections, safety in manufacturing, or product development. Typically, customers might not notice these processes directly, but business must excel at these processes to succeed.
• Customer perspective   The customer perspective includes sales, because sales focuses on how the customers perceive the business. Because customer perception is affected by many business activities, this perspective is often a good general performance indicator. For example, it is affected by such things a product quality, delivery reliability, help-desk responsiveness and competency, and how the customer perceives the company. If your customers perceive your performance negatively, you might have to make adjustments in other perspectives.
• Learning and Growth perspective   The learning and growth perspective covers the human infrastructure of the organization. It addresses performance indicators that concern employees, systems, and organizational procedures. Metrics in this perspective frequently highlight topics such as employee skills, work satisfaction, systems that employees use to perform their jobs, and organizational procedures.

Using the Performance Point Services allow us to benefit all this perspectives with a relative low cost effort.

For more information http://www.microsoft.com/bi/

Bye,

Ronen

• Read more
• No comments

This innovative Excel add-in enables Excel power users to easily create powerful BI solutions by streamlining the integration of data from multiple sources enabling interactive modeling and analysis of massive amount of data and by supporting the seamless sharing of data models and reports through Microsoft Office SharePoint 2010.

At the October BI User Group, we shell have a full session with amazing live demos .

Until then,there is a sneak preview of Gemini videos and blogs.

http://blogs.msdn.com/bi/archive/2009/05/04/preview-of-project-gemini.aspx

http://www.youtube.com/geminute

http://blogs.msdn.com/gemini/archive/2009/08/13/welcome-to-the-gemini-team-blog.aspx

Have Fun,

Ronen

• Read more
• No comments