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!

HSP_NOLINK UDA creation

941749Jun 19 2012 — edited Jun 21 2012

Hi,

Issue: We are trying to run a calc on Plan 1 and we found that it is performing an XREF/XWRITE over the plan 2(another database) within the same application(monitored the sessions via EAS). When I researched, I found that I should assign a UDA, HSP_NOLINK for the dimensions having common members.

Implementation: I created an attribute dimension like "UDA_Shr" in the shared library and copied it to the application and associated it to the Account_Shr dimension(assuming that the XREF could be only due to the members in the account dimension). After creation, I have added the HSP_NOLINK to the Gen-1 members in the account dimension(was unable to add the HSP_NOLINK to the whole dimension). After that, I deployed the application again(Full Deploy) and ran the calc script again. It is again doing an extra session to XREF to the common members.

I have no idea if my implementation was right or if I am missing something. I would greatly appreciate any patience in trying to understand and explain this.

Thanks,
Nish.

This post has been answered by Vladimir Vipirailo on Jun 21 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2012

Added on Jun 19 2012

#business-intelligence-applications, #essbase, #hyperion, #performance-management-applications, #planning, #planning-and-budgeting, #rules

10 comments

4,836 views