Microsoft BIMicrosoft Business Intelligence from the fieldhttp://blogs.msdn.com/b/howardm/atom.aspxTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)2011-06-03T21:35:00ZMicrosoft SAP Resourceshttp://blogs.msdn.com/b/howardm/archive/2012/08/01/microsoft-sap-resources.aspx2012-08-01T16:23:00Z2012-08-01T16:23:00Z<p>Here are some great Microsoft SAP resources</p>
<p>SAP and SAP BW data in PowerPivot <br /><a href="http://sqlcat.com/whitepapers/archive/2011/01/26/using-sql-server-powerpivot-for-excel-to-analyze-sap-data.aspx" target="_blank">using-sql-server-powerpivot-for-excel-to-analyze-sap-data.aspx</a>.</p>
<p>SAP HANA data in PowerPivot<br /><a href="http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26747" target="_blank">http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26747</a>.</p>
<p>Microsoft Connector</p>
<p><a href="http://msdn.microsoft.com/en-us/library/dd299430.aspx">http://msdn.microsoft.com/en-us/library/dd299430.aspx</a></p>
<p>BizTalk Adapter</p>
<p><a href="http://msdn.microsoft.com/en-us/library/cc185427.aspx">http://msdn.microsoft.com/en-us/library/cc185427.aspx</a></p>
<p>XML/A Provider with .NET</p>
<p><a href="http://msdn.microsoft.com/en-us/library/cc974473.aspx">http://msdn.microsoft.com/en-us/library/cc974473.aspx</a></p>
<p>SAP Excel ODBO connector, see:</p>
<p><a href="https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1031a475-a633-2a10-f4b4-ccfe615c051">https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1031a475-a633-2a10-f4b4-ccfe615c0517</a></p>
<p>Multiple SAP BI interoperability papers</p>
<p><a href="http://www.microsoft.com/isv/sap/technology/interop/bi.aspx">http://www.microsoft.com/isv/sap/technology/interop/bi.aspx</a></p>
<p>SSIS and SAP BI White Paper</p>
<p><a href="http://msdn.microsoft.com/en-us/library/dd299430.aspx">http://msdn.microsoft.com/en-us/library/dd299430.aspx</a></p>
<p>SSRS and SAP NetWeaver BI Technical Article</p>
<p><a href="http://msdn.microsoft.com/en-us/library/cc974473.aspx">http://msdn.microsoft.com/en-us/library/cc974473.aspx</a></p>
<p>Microsoft .NET and SAP - Interoperability</p>
<p><a href="http://www.microsoft.com/learning/en/us/Books/12513.aspx">http://www.microsoft.com/learning/en/us/Books/12513.aspx</a></p>
<p>SAP Business Information Warehouse:</p>
<p><a href="http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm">http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm</a> </p>
<p>ODBO flattening algorithm:</p>
<p><a href="http://msdn2.microsoft.com/en-us/library/ms709733.aspx">http://msdn2.microsoft.com/en-us/library/ms709733.aspx</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10335667" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxNew Office 2013 BI capabilitieshttp://blogs.msdn.com/b/howardm/archive/2012/07/30/new-office-2013-bi-capabilities.aspx2012-07-30T17:39:25Z2012-07-30T17:39:25Z<p>Some new links to check out about what is coming from a BI perspective in Office/SharePoint 2013</p>
<ul>
<li><a href="http://officepreview.microsoft.com/en-us/excel-help/powerpivot-powerful-data-analysis-and-data-modeling-in-excel-HA102837110.aspx?CTT=1">PowerPivot:Powerful data analysis and data modeling in Excel</a></li>
<li><a href="http://officepreview.microsoft.com/en-us/excel-help/whats-new-in-powerpivot-in-excel-2013-HA102893837.aspx?CTT=1">What’s new in PowerPivot in Excel 2013</a></li>
<li><a href="http://officepreview.microsoft.com/en-us/excel-help/power-view-explore-visualize-and-present-your-data-HA102835634.aspx?CTT=1">Power View:Explore, visualize, and present your data</a></li>
<li><a href="http://officepreview.microsoft.com/en-us/excel-help/whats-new-in-power-view-in-excel-2013-and-in-sharepoint-2013-HA102901475.aspx?CTT=5&origin=HA102835634">What’s new inPower View in Excel 2013 and in SharePoint 2013</a></li>
<li><a href="http://officepreview.microsoft.com/en-us/excel-help/quickstart-learn-dax-basics-in-30-minutes-HA102891601.aspx?CTT=1">QuickStart: LearnDAX Basics in 30 Minutes</a></li>
</ul><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10334871" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxMicrosoft Named a Self-Service Business Intelligence Leader by Forrester Researchhttp://blogs.msdn.com/b/howardm/archive/2012/07/24/microsoft-named-a-self-service-business-intelligence-leader-by-forrester-research.aspx2012-07-24T21:44:57Z2012-07-24T21:44:57Z<p><a href="http://www.forrester.com/home">Forrester Research</a> has positioned Microsoft as a leader in the <a href="http://download.microsoft.com/download/8/F/F/8FFFD378-159C-4107-898C-B60835D85384/The_Forrester_Wave_Self-Service_BI_Platforms_Q2_2012.pdf">"The Forrester Wave™: Self-Service Business Intelligence Platforms, Q2 2012"</a> report.</p>
<p><span style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><span style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ansi-language: EN-US; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"><v:f eqn="sum @0 1 0"><br /> <v:f eqn="sum 0 0 @1"><br /> <v:f eqn="prod @2 1 2"><br /> <v:f eqn="prod @3 21600 pixelWidth"><br /> <v:f eqn="prod @3 21600 pixelHeight"><br /> <v:f eqn="sum @0 0 1"><br /> <v:f eqn="prod @6 1 2"><br /> <v:f eqn="prod @7 21600 pixelWidth"><br /> <v:f eqn="sum @8 21600 0"><br /> <v:f eqn="prod @7 21600 pixelHeight"><br /> <v:f eqn="sum @10 21600 0"><br /> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas><br /> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"><br /> <o:lock aspectratio="t" v:ext="edit"><br /></o:lock></v:path></v:stroke></v:shapetype><v:shape style="width: 325.5pt; height: 304.5pt;" id="Picture_x0020_4" type="#_x0000_t75" alt="Description: cid:image001.jpg@01CD69C3.36CF8000" o:spid="_x0000_i1025"><br /> <v:imagedata o:href="cid:image001.jpg@01CD69C3.36CF8000" src="file:///C:\Users\howardm\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg"><br /></v:imagedata></v:shape></span><br /> <v:stroke joinstyle="miter"><br /> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"><br /> <v:f eqn="sum @0 1 0"><br /> <v:f eqn="sum 0 0 @1"><br /> <v:f eqn="prod @2 1 2"><br /> <v:f eqn="prod @3 21600 pixelWidth"><br /> <v:f eqn="prod @3 21600 pixelHeight"><br /> <v:f eqn="sum @0 0 1"><br /> <v:f eqn="prod @6 1 2"><br /> <v:f eqn="prod @7 21600 pixelWidth"><br /> <v:f eqn="sum @8 21600 0"><br /> <v:f eqn="prod @7 21600 pixelHeight"><br /> <v:f eqn="sum @10 21600 0"><br /> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas><br /> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"><br /> <o:lock aspectratio="t" v:ext="edit"><br /></o:lock></v:path></v:stroke></v:shapetype><v:shape style="width: 325.5pt; height: 304.5pt;" id="Picture_x0020_4" type="#_x0000_t75" alt="Description: cid:image001.jpg@01CD69C3.36CF8000" o:spid="_x0000_i1025"><br /> <v:imagedata o:href="cid:image001.jpg@01CD69C3.36CF8000" src="file:///C:\Users\howardm\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg"><br /></v:imagedata></v:shape></span></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10333114" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxMicrosoft SQL Server traininghttp://blogs.msdn.com/b/howardm/archive/2012/07/19/microsoft-sql-server-training.aspx2012-07-19T20:51:55Z2012-07-19T20:51:55Z<p>Free MVA courses here <a href="http://www.microsoftvirtualacademy.com/colleges/sqlserver">http://www.microsoftvirtualacademy.com/colleges/sqlserver</a></p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10331750" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxIntro to DQShttp://blogs.msdn.com/b/howardm/archive/2012/07/18/intro-to-dqs.aspx2012-07-18T13:57:26Z2012-07-18T13:57:26Z<p>Looks like a good online training on Microsoft Data Quality Services. <a href="http://technet.microsoft.com/en-us/sqlserver/hh830374.aspx">http://technet.microsoft.com/en-us/sqlserver/hh830374.aspx</a></p>
<p>Also a nice AdWorks sample <a href="http://gallery.technet.microsoft.com/AdventureWorks-Sample-for-826a2ce9">http://gallery.technet.microsoft.com/AdventureWorks-Sample-for-826a2ce9</a></p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10331154" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxDemo Image XII: SQL 2012 http://blogs.msdn.com/b/howardm/archive/2012/06/14/demo-image-xii-sql-2012.aspx2012-06-14T12:36:40Z2012-06-14T12:36:40Z<p>Latest and greatest All up Microsoft BI Demo image is located here <a href="http://www.microsoft.com/betaexperience/pd/BIVHD/enus/">http://www.microsoft.com/betaexperience/pd/BIVHD/enus/</a>. Also hosted version is here <a href="http://fs.mssalesdemos.com">http://fs.mssalesdemos.com</a></p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10319871" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashx64 bit version of the Data Mining Add-in for Excel 2010http://blogs.msdn.com/b/howardm/archive/2012/05/17/64-bit-version-of-the-data-mining-add-in-for-excel-2010.aspx2012-05-17T13:35:58Z2012-05-17T13:35:58Z<p>FINALLY!!!! and updated for SQL Server 2012.</p>
<p><a href="http://www.microsoft.com/en-us/download/details.aspx?id=29061">http://www.microsoft.com/en-us/download/details.aspx?id=29061</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10306233" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxSQL Server 2012 Developer Training Kit http://blogs.msdn.com/b/howardm/archive/2012/05/03/sql-server-2012-developer-training-kit.aspx2012-05-03T23:07:38Z2012-05-03T23:07:38Z<p>This is truly excellent content. Kudos to the MS Team. Links to presos and videos below.</p>
<p><a href="http://social.technet.microsoft.com/wiki/contents/articles/6982.sql-server-2012-developer-training-kit-bom-en-us.aspx">http://social.technet.microsoft.com/wiki/contents/articles/6982.sql-server-2012-developer-training-kit-bom-en-us.aspx</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10300676" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxMicrosoft Business Intelligence 2012 - Single Server Install Guidehttp://blogs.msdn.com/b/howardm/archive/2012/05/02/microsoft-business-intelligence-2012-single-server-install-guide.aspx2012-05-02T02:40:00Z2012-05-02T02:40:00Z<p>I just put this together for a customer and thought I would share it. It goes through the entire install and configuration process screen by screen, to build a stand alone server with all the server side components of the Microsoft Business intelligence solution.</p>
<p>Enjoy!</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10299753" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxSQL Server 2012 Product Guidehttp://blogs.msdn.com/b/howardm/archive/2012/04/12/sql-server-2012-product-guide.aspx2012-04-12T19:15:39Z2012-04-12T19:15:39Z<p>Just released a new <a title="SQL Server 2012 Product Guide " href="http://download.microsoft.com/download/3/3/4/334DB8C8-B367-4C8E-9F03-089FD819980C/SQL_Server_2012_Product_Guide_Apr2012.zip">SQL Server 2012 Product Guide</a> ready to download.</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10293315" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxconnect PowerPivot to an Oracle databasehttp://blogs.msdn.com/b/howardm/archive/2012/04/10/connect-powerpivot-to-an-oracle-database.aspx2012-04-10T13:59:54Z2012-04-10T13:59:54Z<p>Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle client installed and the TNS names configured.</p>
<p>In PowerPivot the server name to connect to the Oracle instance is <span style="font-size: large;">host:port/service_name</span>. If port number is already in TNS names you should be good. Other little gotcha was be sure ORACLE_HOME is set and in your path.</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10292235" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxReporting Services 2012 and Dashboard Designerhttp://blogs.msdn.com/b/howardm/archive/2012/04/10/reporting-services-2012-and-dashboard-designer.aspx2012-04-10T13:38:42Z2012-04-10T13:38:42Z<p>Alot of confusion on how to integrate the new SharePoint integrated mode of Reporting Services 2012 into your Performance Point Dashboards.</p>
<p>If Reporting Services is configured to use Trusted Account authentication in SharePoint Server, then the server name typically takes the form <a href="http://servername/_vti_bin/reportserver">http://servername/_vti_bin/reportserver</a>.</p>
<p>more info <a title="here" href="http://technet.microsoft.com/en-us/library/ff724283.aspx">here</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10292230" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxMicrosoft BI on an ipadhttp://blogs.msdn.com/b/howardm/archive/2012/02/17/microsoft-bi-on-an-ipad.aspx2012-02-17T15:30:51Z2012-02-17T15:30:51Z<p>Microsoft has released new guidance on viewing reports and scorecards on Apple iPad devices, and a SharePoint Cumulative Update to enable it.</p>
<p><a href="http://technet.microsoft.com/en-us/library/hh697482.aspx">http://technet.microsoft.com/en-us/library/hh697482.aspx</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10269052" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxSharePoint Summithttp://blogs.msdn.com/b/howardm/archive/2012/01/27/sharepoint-summit.aspx2012-01-27T16:10:25Z2012-01-27T16:10:25Z<p>For those in Toronto, I will be presenting a session at the SharePoint Summit on May14-16th on Building Better Dashboards</p>
<p><a href="http://www.sharepointsummit.org/Toronto/conference-day2.htm#session_9_2">http://www.sharepointsummit.org/Toronto/conference-day2.htm#session_9_2</a></p>
<p>Hope to see you there!</p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10261232" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxLaunch BISM File (.bism) in Excelhttp://blogs.msdn.com/b/howardm/archive/2012/01/11/launch-bism-file-bism-in-excel.aspx2012-01-11T17:00:00Z2012-01-11T17:00:00Z<p xmlns="http://www.w3.org/1999/xhtml">BI semantic model connections from Excel require that you have Excel 2010 and the MSOLAP.5 OLE DB provider installed on your workstation</p>
<p xmlns="http://www.w3.org/1999/xhtml">For connections to succeed you must have Excel 2010 and the MSOLAP.5.dll installed on the client computer. You can get the provider by installing the version of PowerPivot for Excel that is current for this release or you can download just the Analysis Services OLE DB provider from the <a href="http://go.microsoft.com/fwlink/?linkid=214066">Feature Pack download page</a>.</p>
<p xmlns="http://www.w3.org/1999/xhtml">To confirm that MSOLAP.5.dll is the current version, check <span><span class="input">HKEY_CLASSES_ROOT\MSOLAP</span></span> in the registry. <span><span class="input">CurVer</span></span> should be set to MSOLAP.5. Also, copy the CLSID of the MSOLAP.5 provider.</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10255608" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxProject Barcelona (again)http://blogs.msdn.com/b/howardm/archive/2012/01/05/project-barcelona-again.aspx2012-01-05T23:52:00Z2012-01-05T23:52:00Z<p>check this out for what is coming...btw, it is in CTP1 release now.</p>
<p> <a href="http://projectbarcelona.cloudapp.net/">http://projectbarcelona.cloudapp.net/</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10253721" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxDAT279 New Business Intelligence Functionality in Microsoft SQL Server Code-Named "Denali" http://blogs.msdn.com/b/howardm/archive/2011/10/20/dat279-new-business-intelligence-functionality-in-microsoft-sql-server-code-named-quot-denali-quot.aspx2011-10-20T03:26:00Z2011-10-20T03:26:00Z<p>I am doing a session next week at our local techdays event. <a href="http://www.techdays.ca">http://www.techdays.ca</a>. I hope to see some folks there. here is what I am covering...</p>
<p>In this session we dive into some of the new Business Intelligence capabilities that are being introduced in SQL Server code-named "Denali". We'll start with the new Business Intelligence Semantic Model (BISM) and shown how BI developer scenarios are enhanced in Visual Studio 2010 and deployed to the new Tabular version of Analysis Services. You will then learn about the new self-service BI scenarios leveraging the BISM along with Project Crescent, a new interactive web based authoring and data visualization tool that is tightly integrated into SharePoint 2010.</p>
<p>I am going to show how a developer, using the new data tools in VS2010 can "productionize" a BI Semantic model based on a business user's powerpivot model. Then deploy to the new tabular version of Analysis services and enable business users to create Power View (formerely Crescent) reports in SharePoint 2010.<br /><br /></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10227931" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxMicrosoft Big Datahttp://blogs.msdn.com/b/howardm/archive/2011/10/13/microsoft-big-data.aspx2011-10-13T21:34:35Z2011-10-13T21:34:35Z<p class="intro">Unlock business insights from all your structured and unstructured data, including large volumes of data not previously activated, with Microsoft’s Big Data solution. Microsoft’s end-to-end roadmap for Big Data embraces Apache Hadoop™ by distributing enterprise class Hadoop based solutions on both Windows Server and Windows Azure. Our solution is also integrated into the Microsoft BI tools such as SQL Server Analysis Services, Reporting Services and even PowerPivot and Excel. This enables you to do BI on all your data, including those in Hadoop.</p>
<p class="intro"><a href="http://download.microsoft.com/download/F/A/1/FA126D6D-841B-4565-BB26-D2ADD4A28F24/SolutionSheet_Microsoft_Big_Data_Oct2011v2.pdf">Microsoft Big Data Solution Sheet</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10224907" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxPerformancePoint Services SuperFlowshttp://blogs.msdn.com/b/howardm/archive/2011/08/27/performancepoint-services-superflows.aspx2011-08-27T11:50:49Z2011-08-27T11:50:49Z<p>It's like a help file on steroids. There are 2.</p>
<p><a href="http://go.microsoft.com/fwlink/p/?LinkId=226358">IT configuration</a> - how to configure Performance Point Services</p>
<p><a href="http://go.microsoft.com/fwlink/p/?LinkId=226357">Dashboard creation</a> - how to create Performance Point content: kpi, scorecards, reports, filters, dashboards, etc...</p>
<p> </p>
<p> </p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10201167" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxReporting Services 2012 SharePoint Service http://blogs.msdn.com/b/howardm/archive/2011/07/27/reporting-services-2011-sharepoint-service.aspx2011-07-27T17:12:00Z2011-07-27T17:12:00Z<p>There are couple of post install manual configs you need to do in order to get the reporting services Sharepoint service to show up in your sharepoint farm. First of all, you NEED SharePoint 2010 SP1.</p>
<ol>
<li>In SharePoint PowerShell, as admin:</li>
<ul>
<li>Install the Service > Install-SPRSService</li>
<li>Install the Proxy > Install-SPRSServiceProxy</li>
<li>Start the service (You can do this is in CA too)</li>
<ul>
<li>> get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance</li>
</ul>
</ul>
<li>Create the Shared Service</li>
<ul>
<li><span class="label"> <span class="label">Application Management</span> group | <span class="label">Manage Service Applications | New | </span>SQL Server Reporting Services Service Application</span></li>
<li><span class="label">add your config settings</span></li>
</ul>
</ol>
<p><span class="label">More details <a href="http://technet.microsoft.com/en-us/library/gg492276(SQL.110).aspx">here</a></span></p>
<p><span class="label"></span> </p>
<p> </p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10190409" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxSQL Denali CTP3 is outhttp://blogs.msdn.com/b/howardm/archive/2011/07/12/sql-denali-ctp3-is-out.aspx2011-07-12T20:44:34Z2011-07-12T20:44:34Z<p>latest and greatest denali bits.</p>
<p><a href="http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx">http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx</a> and you will need this too</p>
<p>Microsoft® SQL Server® Code-Named 'Denali' PowerPivot for Microsoft® Excel Community Technology Preview 3 (CTP 3)</p>
<p><a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=80edc21c-643e-4e1b-a4c9-7f51f24b6d98">http://www.microsoft.com/downloads/details.aspx?FamilyId=80edc21c-643e-4e1b-a4c9-7f51f24b6d98</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10185758" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxPowerPivot: DAX: Time Intelligence Functionshttp://blogs.msdn.com/b/howardm/archive/2011/07/08/powerpivot-dax-time-intelligence-functions.aspx2011-07-08T20:42:09Z2011-07-08T20:42:09Z<p>Useful list of time calcs for powerpivot and soon to be tabular bi models.</p>
<p><a href="http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-dax-time-intelligence-functions.aspx">http://social.technet.microsoft.com/wiki/contents/articles/powerpivot-dax-time-intelligence-functions.aspx</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10184721" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxCascading filters in PPShttp://blogs.msdn.com/b/howardm/archive/2011/06/30/cascading-filters-in-pps.aspx2011-06-30T15:05:00Z2011-06-30T15:05:00Z<p>here is a little known PPS <a title="http://blogs.msdn.com/b/performancepoint/archive/2011/06/07/what-s-new-in-performancepoint-services-and-sp1.aspx" href="http://blogs.msdn.com/controlpanel/blogs/posteditor.aspx/feature add" target="_blank">feature add for SP1 for SharePoint 2010</a></p>
<p><a href="http://technet.microsoft.com/en-us/library/hh272541.aspx">http://technet.microsoft.com/en-us/library/hh272541.aspx</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10181959" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxTwitter Analyticshttp://blogs.msdn.com/b/howardm/archive/2011/06/15/twitter-analytics.aspx2011-06-15T14:31:42Z2011-06-15T14:31:42Z<p>A new cool FREE tool to gain valuable insight into your tweets using PowerPivot.</p>
<p><a href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=07a56b57-5f60-4a2f-a010-bebf40a94eae&displaylang=en" title="Download it here">Download it here</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10174820" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashxWindows 8http://blogs.msdn.com/b/howardm/archive/2011/06/03/windows-8.aspx2011-06-03T21:35:00Z2011-06-03T21:35:00Z<p>i can think of a few cool BI scenarios with this new UI</p>
<p><a href="http://blogs.msdn.com/b/howardm/archive/2011/06/03/windows-8.aspx">(Please visit the site to view this file)</a></p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10171243" width="1" height="1">bi-kinghttp://blogs.msdn.com/msbi-can/ProfileUrlRedirect.ashx