I am not sure if this is what you are after. If I am not mistaken, transconductance of a MOS transistor can be simulated in Cadence by doing a simple Ids/Vgs simulation. Then you open up the calculator and use the "deriv" function on the I/V curve. The output should be a transconductance curve for the transistor.
OK, but what if i want to plot the (overall) transconductance of a MOS transistor (not gm, but Gm) for a common source connection for example? The above method requires a DC sweep, then taking the derivative of the curve to find transconductance. I was wondering if that can be done only with an AC analysis,that is when frequency varies and the parasitics of the transistor force the overall Gm to start decreasing.