Wierd data loads with Group By SQL

[A.Pete]

Hi

im having a hard time undertanding if im doing something wrong or if this is as intended.

So I have an sql statement, I.e
Select A,B,Amount from Table

I put this in a TI process using the wizard so A and B are element and Amount is Data. This should load data to my cube using the ackumulate option.

The above stement works fine but takes some time since there alot of data in the facts table. Due to this I rewrote the SQL to:
Select A, B, Sum(Amount) From Table Group By A, B

This gives me a much smaller amount of data and build the cube in less time. I also change the option from ackumulate to store when using group by. The problem im getting is that when I run the process the process progress report window does the read of the entire result in the metadata part AND in the data part. There is no code in the metadata and only in data...

Why does this happen? Is it verifying the import using passes or am I missing something here?

Thanks in advance
/P

[David Usherwood]

Look at your metadata tab and then at your variables. I'm thinking you have created a variable without telling it to be calculated in only the data tab - the default is 'Both'.

[A.Pete]

That was my thought too so I changed it to Data tab only but still the same behaviour