AGG & @IDESCANDANTS Query

@IDESCANDANTS

Summary

AGG & @IDESCANDANTS Query

Content

Hi Experts,

 

A query:

 

Suppose we have a dim like below

 

Customer

- All Customers

--C1 (Dynamic Calc)

---C11

---C12

--C2 (Dynamic Calc)

---C21

---C22

--C3 (Store)

---C31

---C32

 

Suppose value of C11,C12,C21,C22,C31,C32 all are 25 C1 & C2 are dynamic calc & C3 is store

 

Now suppose if i write AGG (Customer) in one script & @IDESCENDANTS(All Customers) in other, what value will be present for both the script for "All Customers"?

I believe for AGG it shoild be 50 as it will ignore the C1 & C2 as per AGG command definition & for @IDESCANDANTS