Browse by Tags

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 | 1 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