SSAS Implementations 
Live demos Richard Lee live demo site with SSAS, SharePoint and Excel Services
Live demos Richard Lee live demo site with SSAS, SharePoint and Excel Services
| Richard Lee live demo site with SSAS, SharePoint and Excel Services |
| Written by Vidas Matelis |
| Friday, 21 March 2008 22:08 |
|
Please visit the Demonstrations section of Richard Lee's site, which has a variety of data mining, OLAP and business intelligence tools on several real (census, web logs, Perfmon and libraries) and synthetic (foodmart) databases of over 100 Million records. The demonstrations are platformed on Microsoft SQL Server 2005 and Microsoft SharePoint Server, Microsoft PerformancePoint Server 2007 and Excel Services. Many live and very very good examples of SharePoint dashboards, scorecards, KPI's, reporting services, Excel Services, data mining and PerformancePoint reports. See live what you can do with SQL Server Analysis Services and other Microsoft tools. Demo site: http://richardlees.com.au/sites/Demonstrations
|
Comments (3)
Top Rated
- YouTube video - how SSAS is used
- SQL Data Mining: Interview with Wee Hyong
- Richard Lee live demo site with SSAS, SharePoint and Excel Services
- Podcast - Val Matison Gives Us Business Intelligence!
- Behind the Scenes with Tatyana Yakushev
- Microsoft SQL Server 2008 Data Mining Services - Table Analysis Tools for the claud
- SQL Minds Data Mining Companion - online tool to perform data mining related operations
- SQL Minds BI Companion - online SSAS cube browser
The implementation was very good. Even I have a similar requirement.
I have three hierarchies namely
Team
Project
Region
Location
Calendar
Month
•We have a project which is spread across locations.
•In Reports, we will have three filters namely, Team, Geography and Calendar.
•For e.g.: If we have the data entered for a metric(% of hours spent) at Resource-Facility level which is one level below project-location and this level will not be available in filters for reporting. Resource is tied to a Project. Facility is tied to a location.
•Metric to be seen in report: % of Hours spent = (No. of hours worked/Total No. of Hours reported) * 100
•For this metric, we have the data elements data for No. of hours worked = 10 for every resource and Total No. of Hours reported = 12 for every resource.
•Let’s assume we have 10 resources in a project. Project is spread across 2 locations. Location is mapped to a facility. Both the facility has 5 resources each.
•So when we see the data for this metric at Project-Location level, it should calculate based on formulae as
% of Hours spent = [(10+10+10+10+10)/(12+12+12+12+12)]*100. It should not do aggregation as summation of 5 resources data (10/12)*100.
How the same aggregation and calculation will happen at the higher levels in the cube? What are the functions which can be used to achieve this?
Also the formulae for each metric is stored in the table. I have to write a MDX which will pick up the formulae from the table based on the metric selected in the dimension and it has to do calculation at all the levels.
Please help me to find a way for it.
Thanks in Advance,
Amby