Replace the Sum(…) prefix in PowerPivot

יום ראשון, נובמבר 20, 2011

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...
תגובה אחת

Consume PowerPivot Data from Pyramid analytics

יום ראשון, אוקטובר 30, 2011

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!  
אין תגובות

PowerPivot to consume Cognos

יום רביעי, אוקטובר 20, 2010

  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? * 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
תגיות: ,
2 תגובות

BI Group meeting (#15) Jul 26, Monday 17:30

יום שבת, יולי 17, 2010

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 השלושה יתנו למשתתפים הצצה לתהליכי הפיתוח של בינה עסקית במיקרוסופט ישראל.  זוהי הזדמנות יוצאת דופן להבין כיצד מיקרוסופט מתכננת, מפתחת ומשיקה את פתרונות הבינה העסקית שלה.  .  Id like to encourage you to propose a session about a...
תגיות: , , ,
אין תגובות

PowerPivot RTM download

יום שני, אפריל 26, 2010

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® Windows® 7or Microsoft® Windows® Server 2008 R2 install .NET Framework 3.5 SP1. 2. If you are running...
2 תגובות