Microsoft Business Intelligence roadmap

27/01/2009

Microsoft is announcing an update to its Microsoft Business Intelligence roadmap. Microsoft’s strategy is to deliver BI to everyone in the organization through the broadly adopted tools of Microsoft Office SharePoint Server and Microsoft Office Excel, and built on the scalable Microsoft SQL Server BI platform. Based on customer feedback, we are moving the scorecard, dashboard, and analytic functionality from Microsoft Office PerformancePoint Server into Office SharePoint Server Enterprise, making these capabilities available throughout the organization at a lower TCO. In mid 2009, we will release PerformancePoint Server 2007 “service pack 3” which will include updates to the current...
תגיות: , ,
אין תגובות

Alternate Row Color (2)

18/01/2009

Hi, I have posted before on how to alternate row color. Here is another method ( simple one) in two steps: 1.click on the Row Group property 2. paste this code into the backgroundColor  expression IIf(RowNumber(Nothing) Mod 2,"WhiteSmoke","White") Have fun!!! Ronen
אין תגובות

Nice Undocumented feature in Report Builder 1.0

17/01/2009

  1. You can add a textbox that shows the date the report was run by setting the value of the textbox to the following: =String.Format("Date: {0:MM/dd/yyyy}", DateTime.Today) 2.Another potential use of this undocumented feature is to display the values selected by the user for each report parameter. This is a helpful workaround for the fact that the auto-generated filter description does not insert the run-time values for each parameter. Here's an example of an RDL expression that would provide this info: =String.Format("Sales Year: {0}", Parameters!OrderYear.Value) One problem with it is that you will have to guess the...
אין תגובות

Use SQL 2008 reporting services with template

HI, One common best practice for enterprise reporting system is one template for all the reports. In order to use one template  follow this steps: 1. Develop one report with all the template item you wish to include at your template. 2. save it on this folder :  C:\Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject 3. There is a file called report.rdl; that is the default one from MS.  One caveat, you will have to do this on every machine as the template is on your local PC. Enjoy, Ronen Technorati Tags: DEV,SSRS 2008,SSRS TEMPLATE
תגיות: , ,
תגובה אחת

Query directly from Excel

14/01/2009

Hi, As you know there are always customers who want fast delivery NO MATTER WHAT. You can always query directly from the XLS source and by that bypass the ETL step. Please find the attached code for OPEN ROW SET. SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database={FileLocation}', )  Enjoyee  Ronen  
תגיות: , ,
אין תגובות

Israeli Business Intelligence user group

07/01/2009

  שלום לכולם, מזה זמן רב הסתובבנו (יוסי אלקיים, ערן שגיא ואנוכי) עם תחושה כי הגיע הרגע להקים מקום מפגש לאנשי ה - BI,לאחר הרבה מאמצים ובעזרת הצוות המסור של מיקרוסופט אני שמח לבשר על השקת קהילת ה - BI של ישראל. סוף סוף זה מגיע, בתאריך 28.1.2009 ניפגש לפגישה ראשונה של ה   .UserGroup - פתחנו דף הרשמה מיוחד לאירוע http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032401176&Culture=he-IL הפיצו את הלינק בקרב כל חבריכם. בהצלחה. רונן  
תגיות: ,
תגובה אחת

Bad MDX/SQL performance? Worm up the cache

02/01/2009

During Q1/2009 we are facing a huge project of performance improvements project at a very large Technorati Tags: BI,Performance,MDX,CACHE scale DHW. At this time I will share with you some of the technics... To improve server performance, you can preload the cache. To preload the cache with a collection of parameterized report instances, create a data-driven subscription that uses the Null Delivery Provider. When you specify the Null Delivery Provider as the method of delivery in the subscription, the report server targets the report server database as the delivery destination and uses a specialized rendering extension called...
אין תגובות