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

Excel Services Compatibility Checker
16 February 09 02:46 PM | Ronen Chenn | with no comments

Hi all, It is amazing how EXCEL SERIVECES has become a major technology for departmental BI capability. Check this link to explore SHAHAR PRISH application, that allow you to both figure out what's wrong with your workbooks and fix them so that they work with Excel Services. I would like to thanks Mr Danny Hoter who enlightened me about this Add-in. Follow this link to Excel Services Compatibility Checker Download Page http://blogs.msdn.com/cumgranosalis/pages/excel-services-compatibility-checker...

תגים:BI 2008, DEV, EXCEL, EXCELL SERVICES

Query directly from Excel
14 January 09 05:30 PM | Ronen Chenn | with no comments

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}', [Sheet1$]) Enjoyee Ronen

תגים:DEV, OPEN QUERY, EXCEL