Aggr

[priyarane]

Hi Community,

Can I have alternate calculated dimension with aggr or with any other function as I am not getting all IRB_Band values

aggr(aggr(only({<%Month = {'$(=$(=vCurrMonth))'},%Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB_Band),IRB_Band),INVOLVED_PARTY_ID)

[jonathandienst]

If you need a calculated dimension for IRB_Band, then this should be enough:

aggr(only({<%Month = {'$(=$(=vCurrMonth))'},%Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB_Band),IRB_Band)

or better:

aggr(only({<%Month = {'$(vCurrMonth)'},%Year = {'$(vCurrYear)'},CURRENCY = {'$(vCurr)'}>} IRB_Band), IRB_Band)

I am not sure why you believe that a nested Aggr() is required. Perhaps you could provide a lot more information about your data model, or better still a sample illustrating the problem.

[sunny_talwar]

What do you mean alternate calculated dimension? Are you wanting to use alternate state? May be move the whole chart to another state if that's what you are looking for.