Reporting – Aus800

Excited to receive a star from Google :)

Surprisingly I received the following from Google search console that congratulates my Google search clicks Further insights is also provided that tells me which of my articles are popular and rank top from Google search For a small site like

Tableau to show HTML data

I was working on Tableau to show some records that were extracted from a database, one of the columns is a HTML document, unfortunately Tableau cannot show HTML data properly. I did my research but found no solution, someone in

Jasper report two subreports in one section

I was putting two subreports together however noticed the title of the 2nd subreport didn’t “float”, checked its property, “float” was ticked, see screen shot below. After 20 minutes of search, it

Microstrategy metric

I have to admit I’m not a fan of Microstrategy, the main reason is its rich features are buried in various places at the corner of tiny configuration items. For example I created a metric using CaseV CaseV(mtrFYear, 2013, 16.33,

Jasper report server

I was developing a telecommunication bill using Jasper Studio (V6.0.4) on Windows and Jasper Server (V6.0.1) which was remotely hosted on an Ubuntu server. Jasper Studio was used to design layout while Jasper Server was in charge of generating final

Microstrategy derived metrics

I’ve been using Microstrategy for more than a year by now, never used derived metric before until recently discovered the beauty of derived metric. Derived metric, a Microstrategy’s term, I’d rather call it report function. Basically it’s a function that

Microstrategy movingsum

Have been using Microstrategy 9 for a while, had a moving sum problem recently. The customer basically needs moving sum for the past 12 months for each state/branch. Of course the month is based on accounting period, i.e. 1 May