Sum over subset… Jedox !!!

Hi, A seemingly trivial looking task took me all over the board recently to figure out a solution for the business where users didn’t wanted to create consolidated nodes in the dimensions to get the aggregations, instead they wanted to get the aggregated results via subset which where filtered based upon the attributes flags, phew !!! Ne Read More …

Paged Report in Jedox Web

Hi, In this post I would like to introduce you to the new feature set provided by MSSQL server 2012 (syntax) for paged result sets using the “OFFSET FETCH” clause http://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx Now we got the SQL in place to provide the flexibility, so how we go about leverage it. For the same, I have sketched Read More …

Save All Jedox DB To Relational DB ETL

Having worked on couple of projects in the past with Jedox and their implementations across several institutions, I realized a patten of one task which was common across all of them was pushing back the Jedox content to the relational database for multiple purposes. May it be for archiving, backup, referencing (as client can add their Read More …

Screen shot on Web via Javascript and saving back to Server !!!

“Screen Shot’s” associated with the windows keyboard “Print Screen” function key, have been and still being utilized heavily to report error’s occurring on the client side with the application. And clients not sending/capturing the screen state at the time of errors lead to difficulty reproducing the issue within the development arena in order to resolve Read More …