Dissolve the Jell-O in hot water. Stir in the pie filling and pineapple. Lightly spray a 9X13 glass dish with cooking spray, pour in the jello mixture and refrigerate until firm.
In a large bowl, combine the softened cream cheese, sour cream and sugar, beat with an electric mixer until fluffy. Spread on top of the firm jello, sprinkle with optional pecans and refrigerate until you're ready to serve.