Real time Bitcoin rate
There are many websites that give you the latest real time quote for Bitcoin: but this is the only one that speaks the rate out! https://freeboard.io/board/0PBWdT
dmoraschi
How to revoke access permission from Google account
If you granted access to some of your data in Google (analytics, calendar, contacts, etc.) to some external application (like Xobni for example); you may want -at some point- to revoke them as you no longer use that application. To do that click on the gear icon and select “Account settings” go to your accountRead More
Have you read the news today?
You may already know that Oracle has the capability to get data directly from the Web. Like in: SELECT HTTPURITYPE.createuri (‘http://www.economist.com/rss/leaders_rss.xml’).getclob () RSS FROM DUAL; This offers a lot of possibilities when you need to query external data and, combined with some XML magic, can make a cute RSS view out of a well-formed xmlRead More
Playing with DATE ranges
If you search on the net for a trick to generate date rangees in Oracle, you most probably will end up here: http://stackoverflow.com/questions/418318/generate-a-range-of-dates-using-sql variuos interesting and mind-challenging ways to achieve the same result. I found this way the most cost effective and readable, yet flexible enough for my datawarehouse ETL processes. WITH LIMITS AS (SELECTRead More
SELECT ‘MicroStrategy’ FROM DUAL;
I often use the DUAL pseudo table in Oracle to generate constants or execute functions, like in SELECT SYSDATE FROM DUAL; Appearently there is no easy way to convince MicroStrategy to use DUAL in FROM clause because it doesn’t appear in the list of available tables. Until now I used to create a Logical view withRead More
MicroStrategy and LinkedIn
With custom SSO it is possible to allow users log into MicroStrategy using their LinkedIn account. By leveraging the OAuth API offered by the social network we can authorize and create new users without previously knowing their names. Once validated and connected it’s simple to use they user ID to retrieve profile, groups or evenRead More
MicroStrategy Personal Cloud
MicroStrategy released a beta version of its Personal Cloud service. I personally find it amazing! Give it a try http://tinyurl.com/3jyoyh6 MicroStrategy Cloud Personal is a free service that lets you explore your data on your own. Upload your data and share your insights on the web and through mobile devices. It’s quick, easy and it’sRead More
MicroStrategy and Windows 8 (2)
If you try to install MSTR Intelligence Server onto Windows 8 Preview, the setup will run smoothly with no error, but the service won’t start: the reported error is Failed to start service. Unexpected error occurred. The dependency service or group failed to start The Intelligence Server depends on several Windows services (more details inRead More
MicroStrategy and Windows 8 (1)
Trying to install MicroStrategy Desktop on Windows 8 Developer Preview you may get this error: MSTR setup tries to install .NET framework. Windows 8 come with .NET 4 and you also have the option to enable 3.5.1 in the operating system. For further details see the article: http://techdows.com/2011/09/enable-net-framework-3-5-1-on-windows-8-developer-preview-to-run-applications.html After enabling .NET framework you should beRead More
Google News Data API – Google Blogoscoped Forum
via blogoscoped.com