Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ICP Calculation from ICP NONE

Raj -May 12 2011 — edited May 12 2011

Hello All,

i am loading TB data where TB contain ICP Value aswell where [ICP NONE] includes ICP data value.

"Data Load = A#Account.I#[ICP None].C1#Member.C2#Member#C3#Member.C4#TB_Load"

Now, user is inputing ICP data through forms by selecting ICP Entities with ICP accounts.

DataForm input = A#Account.I#ICP Entities.C1#Member.C2#Member#C3#Member.C4#IC_Input

The requirement is differentiate the ICP data from ICP NONE.

[ICPNone] = [ICP NONE] - [ICP Entities]

So that, [ICP None] should have only ICP None data value.

How to acheive this, is any rule to be written for this.

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2011

Added on May 12 2011

#business-intelligence-applications, #financial-consolidation, #from, #performance-management-applications

1 comment

183 views