Archive › Tecnología @es

MicroStrategy: Creating a count metric of distinct occurrences of Attribute2 in Attribute1

Today I needed to create a simple count report metric without the need of creating a standalone metric in MicroStrategy. What I needed was to count the number of appearences of certain attribute for the last 30 days. In other words, the metric of distinct occurences of “Days” in Attribute1. You could easily achieve this […]

Comments ( 0 )

MicroStrategy 10 Hacks: How to fire selector change via Button for any presentation mode

In order to provide usability to your Dashboards, you can let users the possibility to click somewhere and apply certain filter. For instance, you may want to filter a region by clicking a Button instead of scrolling inside a select list for some particular values: 1) MicroStrategy: Create a “Select List” Selector 2) MicroStrategy: Select any panel or […]

Comments ( 0 )

MicroStrategy 10 hacks: Loading jQuery under new Presentation Mode

First of all I’d like to thank Bryan Brandow because this post is inspired on his various posts about this subject: http://www.bryanbrandow.com/search/jquery Since MicroStrategy 10 was out last year 2015, I’ve been trying to achieve some jQuery hacks in order to provide more usability to our dashboards. The first problem I faced when migrating to MicroStrategy […]

Comments ( 0 )

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )

APEX Relational Flexfield plugin – Tutorial

In this post I’ll guide you on how to use “flexfield” APEX plugin. For a online demo, you can access: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELDS Let’s assume we want to provide admin users the ability to fill some table fields with their own specification. We assume you have your own demo “EMP” table with employee information. 1. First of […]

Comments ( 0 )

APEX 5.0: Change export calendar links position

After trying new amazing APEX 5.0 Calendar, even though I’ve found it great, I really think further work is needed in order to provide more options for developers. We’re unable to change inner HTML code because we’re don’t have Templates associated to this new component, and we’re even unable to define different position for its […]

Comments ( 0 )

APEX: How to create a select list with FontAwesome icons

Hi, Today I needed to create an APEX select list input in order to let users choose its own icon from FontAwesome gallery, like this one: I first tried to insert span tag with font-awesome classes, but APEX scapes HTML tags and it didn’t work. So finally I read at Patrick Wolf’s blog one possible […]

Comments ( 0 )

SQL Server: Find first column with specified value

Returns first column of any table which contains a search value

Comments ( 0 )

Automate Talend backup export scripts with SVN and Commandline

It’s useful to periodically export a backup copy of your Talend item scripts when you’re using SVN, so here you have an script to export all Project items: Note: This script only works for Talend Integration Suite 5+ and Unix environments. Note2: Requires Commandline installation

Enjoy!

Comments ( 0 )

Enable VNC connection for each O.S. user at boot – Ubuntu

Many times you need to enable VNC connections in your unix server by default at boot time. In RHEL it’s quite easy but in Ubuntu it’s quite tricky, that’s why I’m pulishing this entry. First of all, we install vncserver:

and let’s edit ~/.vnc/xstartup for each of our O.S. users with the following script: […]

Comments ( 0 )