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

    Selection on a table totally disconnected, affect other tables!

    Aio Aio

      Hi,

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

      I mean

      B:

      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?

       

      Thanks