Selection on a table totally disconnected, affect other tables!

Fri, 26 Apr 2013 12:43:44 GMT

Hi,

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?

Thanks

Re: Selection on a table totally disconnected, affect other tables!

Fri, 26 Apr 2013 12:54:13 GMT

Hi!

You can send a example?

Rebeca Gums

Fri, 26 Apr 2013 13:40:05 GMT

The problem is related to the Aggr formula, If I recharge the file, it changes from time to time!