Skip to Main Content

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!

No Input Rule on Value dimension member <Entity Curr Adjs>

Chandan_DWBIJul 20 2018 — edited Jul 20 2018

Hello All,

I have a requirement to NoInput an intersection of combination of a C4 member on <Entity Curr Adjs>. As per Admin Guide we can not create NoInput Rules on Adjustment members of Value Dimension, so I crated code as below:

If pov_value = "<Entity Curr Adjs>" Then

        HS.NoInput "C4#Member_Nip

End If

Now this code is efficient to block the cells to input data via Webforms, Data Grids and Smartview. But when we are loading the Journal file with Value member as <Entity Curr Adjs> and C4 member as "Member_Nip", the journal is getting loaded in the system, but as per codes it should block the journal to load (post). Below are line if .jlf file I am loading:

!FILE_FORMAT=1.0

!VERSION=1.0.0

!Scenario=ACTUAL

!Year=2018

!Period=AUG

!JOURNAL=NIP_CHECK_ECA;E;R;P;<Entity Curr Adjs>; ;;;

!DESC=NIP_CHECK_ECA on C4 Member_Nip

Entity1;ACCT1;[ICP None];Y00;[None];Sub;Member_Nip;D;1

Entity1;ACCT2;[ICP None];Y00;[None];Sub;Member_Nip;C;1

Entity1;ACCT3;[ICP None];Y00;[None];Sub;Member_Nip;D;1

Entity1;ACCT4;[ICP None];Y00;[None];Sub;Member_Nip;C;1

Can any of you please help to understand the issue. I have used the same codes in version 11.1.2.3.702 and 11.1.2.4.000.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2018
Added on Jul 20 2018
3 comments
673 views