Tag Archives: App

French language support in Create Time Dimension App

With the most excellent help of Microsoft Excel MVP Frédéric LE GUEN there is now a French language option in the Create Time Dimension App. As expected, it will generate all headings and names in French.

Please visit the following sites for more information on Excel from Frédéric:

Release 3 of Create Time Dimension App now available

This entry is part 3 of 3 in the series Create Time Dimension

Release 3 of the Create Time Dimension App is now live. This version brings Czech language support and ISO-8601 week numbers.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Petr Havlik (Twitter: https://twitter.com/petrhavlik) for helping with the Czech translation.

Please note that the ISO-8601 week numbers are just one way of expressing week numbers and might not be what you want. The week numbers start on Mondays per definition and does not change when changing the week start day. If you would like to use another week numbering format you can still add a column using the =WEEKNUM(date, week number system) formula in Excel.

Cube Status – a new open source project for BI in SharePoint

I have released my Cube Status project (http://cubestatus.codeplex.com) to http://www.codeplex.com.

cubestatusscreenshot

This web part for SharePoint provides the possibility to visualize both the current status of a SQL Server Analysis Services (SSAS) cube or tabular model (BISM) and some of its metadata.

This web part can be used in BI portal type pages in SharePoint to show the current status of a cube used for reports and analysis. This means that there is no need to guess the update status or last process time etc. of a cube.

Both the source code and a .wsp solution file for deployment are available for download from the project page: http://cubestatus.codeplex.com

This project is described in more detail here

This project also works quite well together with the SQL Server Agent Job Status project found at http://jobstatus.codeplex.com and with more details here

Please, feel free to suggest updates and new features etc. either here on the blog or on CodePlex.

Update to Create Time Dimension App

This entry is part 2 of 3 in the series Create Time Dimension

I have published an update to the Create Time Dimension Application for Excel that includes a new Date Integer Id column (in the format 20130616 for June 16, 2013) and Dutch language support.

The update is made on the server so it is available for everyone right away, no update needed on the Excel/Client side.

Big thanks to Frederik Vandeputte (Web: http://www.vandeputte.org/ Twitter: https://twitter.com/frederikvdp) for suggesting the id column and helping with the Dutch translations.

ctd-dutch-ui

 

Screenshot: Updated app UI with the Dutch language choice

A Comparison of OneNote vs. Evernote on the Microsoft Surface (RT)

This entry is part 2 of 7 in the series Evernote Overview

A follow up on the post on Evernote vs. OneNote for Android. This post looks at the note creation features of the Microsoft OneNote 2013 RT that is included in the Microsoft Surface RT tablet and the Evernote app that is available from the Microsoft Store.

The OneNote app that is included with the Surface has about the same feature set as the normal Desktop version of the Office 2013 suite. It runs in desktop mode on the tablet and has all the desktop like interactions and features of the Office 2013 for RT apps.

Evernote is a Microsoft Store App that runs in the ‘Modern UI Style’ (formerly known as Metro) which means either full screen mode or Snap mode where one app is snapped to one edge of the screen. In snap mode it is easy to take notes at the same time as another app is open and visible.

Finding existing notes in Evernote uses the same search functions as all Windows Store Apps, by opening the charms menu there is a search option for Evernote and all other Apps available. Compared to the search options in the Desktop app and the Android app this is quite a poor experience. It is not possible to save searches to create dynamic lists of posts and it is not possible to save the search as a short cut anywhere.

Creating notes in OneNote

The interface in OneNote is very similar to the Windows Office 2013 Desktop Application.

onenote_screenshot

The App runs in window mode and can be resized and moved at will.

Created of notes can include any formatting and object supported. it is easy to insert screenshots with the clipping tool etc.

Creating notes in Evernote

The Evernote note creation experience is of the less is more variant.

evernote_note_Creation_screenshot

There is only plain text input and the only extra options is to choose the notebook the note should be in and the tags to associate with the note.

Snap mode

It is possible to put the note creation interface on either edge of the screen using Snap and use the rest of the screen for another App.

evernote_view_snap

Snap example, use part of the screen for Internet Explorer and part of the screen for Evernote note.

Search for notes in Evernote

The normal view when opening Evernote includes squares of all recent notes.

surface_evernote_notes_view

The opportunity to change view is somewhat limited. by opening the menu options, it is possible to change view based on notebooks and tags and it is possible to change sort order.

evernote_options_on_views

It is also possible to zoom out and view navigation based on months.

evernote_view_monthly

If you are interested in purchasing a Microsoft Surface RT tablet you should probably read this post (Three days in the life of a once and former Microsoft Surface RT user) from ZDNet first…

And then this (5 big things that baffle me about Microsoft Surface RT) ZDNet post