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!

Dynamic Member Comparison on a member formula

NJMar 7 2017 — edited Mar 16 2017

Hi Everyone,

I have the following scenario that I seek help on.

I have the entity and department dimension merged to on and simply called department.

To the department dimension I have an attribute dimension tagged named EntAttr.

Example

Department Name Associated Attribute

73000000 730

The Need is to perform a member formula calculation that pulls the attribute and compares the first three characters with the department name and based on that pulls the value for that department combination and performs the needed calculations.

Example:

876509->Growth%->Fy16->73000000->Baseline->Working=3% ( the input block)

the member formula on the member Value % Currently is

IF(@ISATTRIBUTE("730"))

"Growth%"->Baseline->"73000000";

Any thoughts/suggestions are much appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2017

Added on Mar 7 2017

#business-intelligence-applications, #pbcs, #performance-management-applications, #planning-and-budgeting

10 comments

1,339 views