Skip to Main Content
Forums

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!

HFM Rule If condition for Custom dimension

KumarHypMay 4 2015 — edited May 8 2015

Hi Experts,

I have the following requirement:

if department member is d6XXXX or a descendent of d6XXXX, then

R and D Labor and Benefits Equals Labor and Benefits

Department is my custom dimension. I am not able to use it in IF condition(Getting the error: object doesn't support this property or method).

I  am using the following Script but its restricting it to Specific to D6XXXX departments. Its doing this calc for all members

strC1 = HS.Custom2.List("","D6XXXX_Base")

For Each C2Item in strC1

HS.Exp "A#R and D Labor and Benefits.strc1 = A#Labor and Benefits"

Next

D6XXXX_Base is a Member list.

Any help would be appreciated.
This post has been answered by StLanger on May 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2015
Added on May 4 2015
#business-intelligence-applications, #financial-consolidation, #performance-management-applications
9 comments
1,734 views