AGG & @IDESCANDANTS Query
Summary
AGG & @IDESCANDANTS QueryContent
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
0