Archive

Posts Tagged ‘ms-powerpivot’

Bugs in MS-Calendaranalytics?

  1. Is there an Off-by-1 bug in MS-Calendaranalytics pivot chart?
    1. I am hovering (as an example) over the first name in the upper list which displays the right name as tooltip, the first name in the second listimage
    2. I guess I could learn DAX to fix this one myself, but what I have found myself doing is copy/paste the legend control from underneath, which does not exhibit this apparent bug, as a screenshot over the wrong legend (Seems strangely inadequate!).
  2. Cannot run visual basic macro because of a syntax errorimageVersion 1 on Excel 2010 (64-bit) on Windows 7 (64-bit). Restarting (Excel/Windows) made this go away.
  3. This stopped working on load from one day to the next, without the file getting saved and updated in between: System.Runtime.InteropServices.COMException (0x80070490): Element not found. (Exception from HRESULT: 0x80070490)
    at Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IHostItemProvider.GetHostExtender(String extenderType, String extenderCookie, IntPtr& extenderObject)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.Office.Tools.IHostItemProvider.GetHostExtender(Type primaryType, String primaryCookie)
    at Microsoft.Office.Tools.Excel.ControlSiteImpl..ctor(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, UInt32 officeVersion, Control control, _OLEObject extenderControl, Boolean isDynamic)
    at Microsoft.Office.Tools.Excel.FactoryImpl.Microsoft.Office.Tools.Excel.Factory.CreateControlSite(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, Control control)
    at Microsoft.Office.Tools.Excel.Controls.Button..ctor(Factory factory, IHostItemProvider hostItemProvider, IServiceProvider serviceProvider, String cookie, String extenderCookie, Object container, String identifier)
    at ExchangeAnalytics.Sheet4.InitializeControls() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 169
    at ExchangeAnalytics.Sheet4.Initialize() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 55
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.LoadEntryPoints(IntPtr serviceProvider)

First steps with MS-Calendar Analytics

2013/06/22 2 comments
  1. After installing Calendar analytics (and, if you do not already have it, PowerPivot), open the Calendaranalytics spreadsheet from your desktop and click on “Refresh Calendar”.
  2. “Enter your full email address.  Users with more than 1 email address may need to try each of them.”
  3. clip_image001
  4. clip_image002
  5. “Enter a start date and end date for the timeframes for the Dashboard to reflect”/
  6. “The interface will prompt you for the user’s aliases to add.  You can add multiple.”
  7. clip_image003
  8. “Type in users’ aliases of whom you have permission (i.e. “Full details”) to access their Outlook calendar and click Add”
  9. clip_image004
  10.  clip_image005
  11. Do not use the fully qualified email address for the alias, or else:
  12. clip_image006
  13. You cannot comma delimit  (so AutoIt to the rescue).
  14. clip_image007
  15. You can continue after such a non-fatal error:
  16. clip_image001
  17. clip_image002
  18. Is your “Update all” greyed out ? Restart Excel.
  19. clip_image003
  20. Accept the offer to upconvert:
  21. clip_image004
  22. clip_image005
  23. clip_image003
  24. Update all becoame available after restart of excel, even with download exceptions – maybe the unsaved update of the spreadsheet form powerpivot 1 was the root cause ?
  25. Not that here upconversion to the new powerpivot version does not “take”:
  26. clip_image006
  27. If after a restart of excel your powerpivot tab on the ribbon  does not show, reenable the powerpivot addin.
  28. How to reenable: excel file/ options / select dropwdown: addins, button:go, check the Checkbox  in front of powerpivot:
  29. clip_image007
  30. What if even after a restart of excel, this does not “take”?  See whether in the registry the key   CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Resiliency\DisabledItems contains the path to your powerpivot add-in,like here:
  31. clip_image008
  32. Delete the key and restart excel, your powerpivot ribbon tab =should be back. Hope this will last?
  33. clip_image009
  34. Now updating does something:
  35. clip_image010
  36. This opens the powerpivot window with the meeting data collected fro mms-exchange:
  37. clip_image011
  38. Which can be interactively: visualized in the calendaranalytics sheet
  39. clip_image012
  40. More results here.