Tuesday, September 19, 2006

Drill Thru Tip

When creating a drill through process you will most likely need to do some coding in the Prolog section of the TI process.
If a user does a drill on an element which shows an alias you will probably need to convert this name back into a code which the underlying database system recognises to use in a SQL statement.
I therefore use a DIMIX and DIMNM formula to return the element.

e.g. Costcentre = DIMNM('Costcentre', DIMIX('Costcentre', Costcentre));