2 Replies Latest reply: Apr 26, 2013 9:40 AM by Aio Aio RSS

    Selection on a table totally disconnected, affect other tables!


      I got a table used for test on others, it's built with a resident.

      I mean


      LOAD year as year1, B as B1,C as C1,D as D1 resident tableA;


      I haven't got any other table with field call'd B1,C1,D1 or year1.


      But when I make a selection on this table I noticed some changes on a Pivot containg expression based on totally different dimension


      the expression which changes is smt like aggr(max(B), C1,D1) and the results are wrong!


      I don't know what to do, it seems so strange to me.

      I also noticed that if I open the same qvw file from the web, it works correctly...


      Where is my error? Is there a Bug?