can anyone tell me the flow of execution in the below case

[Anonymous]

A:

Load * Inline [

A, B, C, Sum

1, P, B, 500

1, P, 4, 600

2, S, 5, 700

3, R, 6, 800

];

B:

Load A,

     B,

     Sum(Sum) As total

     resident A

     Group By A,B;

     Drop Table A;

[hector_munoz]

Hi Gulshan,

1. You create 'A' inline table (with manual entry of information) with 'A', 'B' and 'C' as dimension fields and 'Sum' as an expression field.
2. You create 'B' table from resident table 'A' with dimension fields 'A' and 'B' and an aggregated expresion field 'total' result of the sum of 'Sum' expression field. This aggregation is made from 'A' and 'B' fields.
3. You drop 'A' table as it is not needed furthermore.

Is this what you needed?

Regards,

H

[swuehl]

1) Table A will be loaded, source is an INLINE table

2) Table B will be loaded, source is the resident table A from the data model

while loading table B, the records will be grouped by fields A and B and an aggregate will be calculated.

3) Table A will be dropped from the model

[Anonymous]

Hi Hector,

Actually I just want to know that When Execution flow reaches in table B the first statement that will execute is resident. after that which Statement will execute and why..?

[Anonymous]

Hi Stefan,

Thanks for your information. It helps me a lot. can you please tell me that when I comment the Group by statement then in Drop statement it'll give error. why is it so..?

[hector_munoz]

Gulshan,

I suposse that is not DROP TABLE sentence what fails; if you comment GROUP BY sentence you cannot use Sum() function (or another aggregation function).

Regards,
H

[Anonymous]

But again it gives an error...

[sunny_talwar]

‌you need semi Colon after Resident A;

[Anonymous]

Thanku Sunny....

Now it is working

[sunny_talwar]

‌Awesome