Request was to show a Running Total of Job Vacancies and Filled Vacancies by Target Date. First, I created a Calendar table: Calendar = CALENDAR(DATE(2021,1,1),DATE(2021,12,31))Second, I had to create a Running Total of Job Vacancies from Jan 1st thru the Target Date. CountTotalRunning = CALCULATE( COUNTA(‘Vacancies'[ID]), FILTER( ALLSELECTED(‘Vacancies’), ‘Vacancies'[Need By Date] <=MAX(‘Calendar'[Date]) )) […]
Category: Uncategorized
Cross County Trail for MapMyRide
Verizon FIOS and IMDB EPG mapping for Emby and Media Portal
US Grabber File located in – C:\ProgramData\Team MediaPortal\MediaPortal TV Server\WebEPG\grabbers\US\www_imdb_com.xml This is for Verizon Fios in the Washington, D.C. and Metro area. I had to also modified C:\ProgramData\Team MediaPortal\MediaPortal TV Server\WebEPG\WebEPG.xml to match channels with my imdb file. <tr><td><a><#START></a></td><td> <b><a><#TITLE></a></b><i> <a></a></i><#DESCRIPTION></td></tr>
Raspberry Pi – PulseAudio daemon SystemWide at Boot
Various findings on how to start PulseAudio at boot. https://www.freedesktop.org/wiki/Software/PulseAudio/Documentation/User/SystemWide/ has general information on running PulseAudio systemwide at boot. Those instructions, however, did not seem to actually start the daemon at boot. sudo chmod 555 /var/run/pulse/.config/pulse/cookie to get around cookie file/authentication errors. Modifying /etc/pulse/system.pa with… load-module module-native-protocol-unix auth-anonymous=1 …seems to […]
Import InfoPath XML to SQL Table with SSIS
Had a request to import InfoPath forms into a SQL table for consolidating reporting purposes. In this scenario the InfoPath form data is stored in the form XML itself. The InfoPath form is for tracking project activities and has 6 fields: Project Leader, Week End Date, Accomplishments, Milestones, Risks, Lessons […]
SQL Server Analysis Services Linking to Other Instance Feature is Disabled
This is related to my previous post on cloning VMs. I was not able to connect to the Analysis Server and Synchronize (cubes) between databases because of the following error. Errors in the OLE DB provider. The server returned the following, error: (Errors related to feature availability and configuration: The ‘Linking to […]