Archive › Uncategorized @en

Oracle APEX 5.0: How-to call modal page from dynamic action and capture close event

Today I needed to submit a page saving data and opening a modal page afterwards. For my surprise, APEX 5.0 raises an “400 – Bad request” error when calling a modal page from “Branch” section after processesing (calls apex.navigation.dialog without stating “javascript:” sentence first). It seems to be a Bug of 5.0 version (which hopefuly […]

Comments ( 1 )

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 )

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 )

How to execute Native DB SQL under Microstrategy metric

In case you need to execute native DB SQL inside Microstrategy metric, you can use the following procedure:

#O = Is where the value of  MS Object will be included <MS_OBJECT>= You can drag any MS Object: Text, Attribute, Metric, etc. For instance, in case you need to apply a date mask in Oracle: […]

Comments ( 0 )