Posts Categorized: Note To Self

Get Value from XMLA result file in NAnt with xmlpeek

Posted by & filed under Code, Note To Self, Work.

If I got paid for every hour spent wrangling with XML… Oh wait, I do Problem: Read a scalar-result out of an XMLA response file from an MDX query run against a cube. Store it in a NAnt property. Jiest of my XMLA file: <return xmlns=”urn:schemas-microsoft-com:xml-analysis”> <root xmlns=”urn:schemas-microsoft-com:xml-analysis:mddataset” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema”> <CellData xmlns=”urn:schemas-microsoft-com:xml-analysis:mddataset”> <Cell CellOrdinal=”0″> <Value […]

ADD NEW COLUMN TO GOOGLE SPREADSHEET

Posted by & filed under Code, Java, Note To Self.

Yes, ALL CAPS, here is EXACTLY what I want to do: Add new column to google spreadsheet using java api Maybe now that term will be google-able? As with everything handy, it’s impossible to find what you need in the documentation, or on the broader internets. The fun part about google spreadsheets via the API […]

OLAP: Make XML(A) work for you

Posted by & filed under Code, Note To Self, Rant.

The bread and butter at work is all the magic that happens in OLAP, Microsoft Analysis Services in particular. Alot of people assume OLAP is going the way of the Buffalo, they probably also like buzzwords such as “nosql”, “bigdata”. I won’t argue that OLAP has a pretty high barrier to entry, as well as […]