Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
AGG & @IDESCANDANTS Query — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

AGG & @IDESCANDANTS Query

Received Response
17
Views
17
Comments
edited Aug 2, 2018 2:36AM in Essbase 17 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!