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
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
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
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 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
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
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
