Business Intelligence capabilities in SharePoint 2010


Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork.

Here is a good picture showing all Business Intelligence capabilities in SharePoint 2010. It explains the area of BI, SharePoint BI services such as Excel & PowerPivot, Excel Services, Visio Services, Performance Point Services, Reporting Services and Report Builder. IT also layout application services architecture and type of data sources supported for each services.

Business Intelligence in SharePoint 2010

Business Intelligence in SharePoint 2010

Feel free to download it here:

http://www.bronios.com/wp-content/uploads/choose-a-tool-for-business-intelligence-in-sharepoint-2010.pdf

or

http://www.microsoft.com/downloads/details.aspx?FamilyID=fc97d587-ffa4-4b43-b77d-958f3f8a87b9&displaylang=en<-->

ProClarity Desktop Professional – The grid column widths are not auto-fitted


The grid column widths are not auto-fitted. For example, column totals are often covered and required manual adjustment as display below:

Desired outcome:

For column or row totals, it is well adjusted to display the figure fully. Or similarly in Excel, by highlighting columns or rows, user is able to right click and adjust the column or row width.

This is the feedback from MS Support, PDP does not adjust column wide for the Grand Total, because it’s bold format. Hopefully next release will fix these minor bug.

ProClarity Desktop Professional Report title missing after change of dimension data


If it is just a change of dimension member data, ProClarity still highlight the selected report.

We raise this issue to Microsoft support and here are the result/workaround:

Assessment/ Feedback
==================
This is by Design.
Workaround: click grid properties, and select Title – check Visible and check Preserve Title, and of course give it the “same” name as the page name.
Then click apply, and resave this page

Hope this can benefit someone out there.< >< ><-->

ProClarity Web Standard issues with perspective map view and decomposition tree view


When a security role (incorporate with SSAS cube security) is created to enable a specific user to view limited dimension member data, the publish page/report view in Web Standard is automatically disabled with the following message:

This page is not available now. Please choose another page.
It is base on a member that has changed or is available.

Here are the steps to reproduce the issue.

I am using “AdventureWorksBI.msi” from http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

1. Create an administrator role and assign a user A into it

2. Create an Australia role and assign user B into it

3. Set Dimension Data security for Geography.Country to Australia only.

4. In ProClarity Desktop Professional, a Decomposition Tree chart as below:

6. Publish this book to PAS. Login using Australia Role member – User B to view the report in web standard. The following error will occur.

7. Login using Administrator Role member – User A to view the report in web standard. It works fine!

It seems like a product limitation. We raise this issue to Microsoft support and these is what we get:

Read the rest of this entry »

ProClarity Desktop Professional – Percentage figure exported to excel turn back to actual figures


Using ProClarity function to change actual figure to percentage in grid and then when exported to Excel, percentage turn back to actual figures

Click OK

Desired outcome:

Exported data from ProClarity to Excel should display the same format, ie, if ProClarity is showing percentage, then when exported to Excel, it should also display percentage.

Feedback from MS Support:

This is by design.
Workaround is to use the COPY feature in PRO and paste than in excel.

Personally i think this is a bit weird since PDP known as a powerful analysis tool. It should able to handle all these minor features.