Browse by Tags

Power View 2013
27 December 12 02:00 AM | Ronen Chenn | with no comments

Those of you who looked for pie chart in PowerPivot and could not find it, can fild it now. To use it, you should install SharePoint 2010 SP1 and Sql Server 2012 SP1. The steps for appropriate installation can be found here : http://msdn.microsoft.com/en-us/library/hh231687

תגים:PowerPivot, BI, Power Pivot, BI Best Practice, Tabular, SolidBI.com, SolidBI, PowerView 2013

Replace the Sum(…) prefix in PowerPivot
20 November 11 03:04 PM | Ronen Chenn | with no comments

Problem : when playing with PowerPivot and adding  ∑Values you get the prefix Sum(…) before the value. Solution : 1.Click on the dropdown combo on the right hand. 2. Click on Edit Measure. 3.Copy the Formula in the “Measure will use this formula” … 4.Click on the New Measure icon in the Power Pivot Ribbon 5.paste the formula to the measure settings and change the measure name. 6. That’s it. now you have a new calculated member with your own caption ( Alias or what ever) Enjoy it!!!

תגים:ITPRO, DEV, EXCEL, TECH, PowerPivot, Power Pivot

Consume PowerPivot Data from Pyramid analytics
30 October 11 02:31 PM | Ronen Chenn | with no comments

Pyramid Analytics can consume PowerPivot Data. It can happen with several options: 1. Directly from the XLS file : ex: http://spstst01/PowerPivot%20Gallery/pyramidtest.xlsx Syntax= http://{ServerName/DocumantLibrary/FileName.XLSX ) 2. Connect to the SSAS PowerPivot instance. Both of the option works great. Choose one and start today! Enjoy it!

תגים:DEV, TECH, PowerPivot, Pyramid Analytics

PowerPivot to consume Cognos
20 October 10 11:18 AM | Ronen Chenn | 2 comment(s)

How to make use of RSS read from Cognos 8 ? To make Cognos 8 available as an RSS source feed you can send the following URL to RSS reader: http://servername/cognos8/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/cc.xts&gohome=&feed=rss * change 'servername' to the appropriate Cognos 8 server host name this way you can use PowerPivot o collect data from Cognos directly. please leave any other suggestion or upgrade to the technic… Ronen

תגים:PowerPivot, cognos

BI Group meeting (#15) Jul 26, Monday 17:30
17 July 10 03:11 PM | Ronen Chenn | with no comments

I'd like to invite you to our next Israeli BI Group meeting (#15). When: Jul 26, monsday 17:30. Where: Microsoft Offices, Ra'anana, 2 Hapnina Street, floor 0, DEKEL meeting room near the reception. Program: אריאל נץ, Principal Product Unit Manager of SQL Server Reporting Services אמיר נץ, Distinguished Engineer וארכיטקט BI בכיר במיקרוסופט, אבי ה-PowerPivot ערן מגידו, Principal Group Program Manager Excel Services השלושה יתנו למשתתפים הצצה לתהליכי הפיתוח של בינה עסקית במיקרוסופט ישראל. זוהי...

תגים:TECH, BIUG, DEVV, PowerPivot

PowerPivot RTM download
26 April 10 05:29 PM | Ronen Chenn | 3 comment(s)

Finally PowerPivot RTM is available: Hello all, at the past few days I am struggling with the RTM and the PP Add-in. todays i have found the most updated links for the RTM and sharing it with you all. To install and use Microsoft® SQL Server® 2008 R2 – PowerPivot for Microsoft® Excel 2010, complete the following steps in this order: PowerPivot for Microsoft® Excel X86 Executable (32 bit) PowerPivot for Microsoft® Excel X64 Executable (64 bit) 1. If you are running an operating system other than Microsoft...

תגים:PowerPivot