I live in the Netherlands and our regional settings are different from the US so i want my cube Measures with 1000 sign in . and decimals with ,. To achieve this set the language property from the cube on Dutch and Formatstring from the measure on “#,#.00″ (dont pay attention to the , and . signs used here, he will parse them ok in the client).
Read more at: http://msdn.microsoft.com/en-us/library/ms175613.aspx
I was testing the perfomance of a query from different perspectives and wanted to make sure SQL Server didn’t cache Query results, to achieve this:
run DBCC DROPCLEANBUFFERS, which clears all data from the cache. Then run DBCC FREEPROCCACHE, which clears the stored procedure cache.
found at:
http://www.devx.com/tips/Tip/14401
New in SQL Server 2008 is the RDLOM, in which you can use Microsoft.ReportingServices.RdlObjectModel.dll to create your RDL’s programmatically within Visual Studio. Apears to be a very powerfull tool!
A few things to keep in mind:
- Not officially supported
- Use at your own risk
- Doesn’t validate RDL semantics
Theo Lachev has a free sample from his book which you can use to get started:
http://prologika.com/Books/0976635313/Resources/amrs2008_code.zip
Chris Webb has dissected the Gemini demos from Donald Farmer at the teched in LA.
Read the entire report and his observations here:
http://cwebbbi.spaces.live.com/Blog/cns!7B84B0F2C239489A!4530.entry
Allan Folting, program manager who works on the Excel team has collected some. Questions customers around specific functionality in Microsoft Excel 2007 PivotTables that is missing when connected to Microsoft SQL Server 2005 Analysis Services Service Pack 2 cubes:
- Filtering individual calculated members
- Showing non-visual totals when filtering
He have also gotten lots of requests for the ability to add calculations to OLAP PivotTables using the object model, specifically:
- Adding calculated members/measures
- Adding named sets
Read the entire article with answers here:
http://blogs.msdn.com/excel/archive/2008/02/05/common-questions-around-excel-2007-OLAP-PivotTables.aspx
On MSDN you can find an very nice article which provides tips for and answers to frequently asked questions for using Microsoft Office SharePoint Server 2007 with Microsoft Office Excel 2007 and Excel Services. It gleans community-contributed information from the SharePoint – Excel Services forum on the Microsoft Developer Network (MSDN).
Now available is a white paper outlining the technologies and steps required to publish PerformancePoint Monitoring Server dashboards in an Extranet. You can download this white paper from:
http://go.microsoft.com/fwlink/?LinkId=151630
Mircosoft has release a video demonstration on the Business background to Gemini and SQL Server Kilimanjaro. It shows how business users and IT administrator will benefit from SQL Server 2008 R2 with self service BI from gemini in Excel 2010.
Watch it here:
http://www.microsoft.com/sqlserver/2008/en/us/killimanjaro-video.aspx
