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!

EPM 11.1.1.3 Financial reporting cluster

NarayanMar 8 2012 — edited Jan 4 2013
Hello gurus,

We want to add two different financial reporting servers in EPM 11.1.1.3 distributed environment.
here is the scenario:

We are having
OS: WIn. server 2003 x86
EPM 11.1.1.3

server1: Database, shared service, Workspace, Financial reporting (All are configured)
server2: Only Financial reporting. (Configured with the Database for Workspace on Server1)

Is it possible to configure FR on server2 with shared service on server1?
because after done we are getting an error of authentication while login to the FR studio that is on Server 2.
I don't know what is the reason behind that.

and another question is,
What are the steps to cluster Two EPM 11.1.1.3 Financial reporting servers? (if possible).

any help will be appreciated,

Thank You
Narayan.

Comments

odie_63
Answer

You'll have to do it in two steps in order to avoid namespace redeclarations at child level :

SQL> SELECT xmlserialize(document


  2           insertchildxml(


  3             appendChildXML(


  4               xmltype('<A xmlns="namespace" xmlns:def="myns_namespace"><B/></A>')


  5             , '/A'


  6             , xmlelement("C", xmlattributes('attribute' as "attr"))


  7             , 'xmlns="namespace"'


  8             )


  9           , '/A/C'


 10           , '@def:attribute'


 11           , 'def_attribute'


 12           , 'xmlns="namespace" xmlns:def="myns_namespace"'


 13           )


 14           indent


 15         )


 16  FROM dual;




XMLSERIALIZE(DOCUMENTINSERTCHI


--------------------------------------------------------------------------------


<A xmlns="namespace" xmlns:def="myns_namespace">


  <B/>


  <C attr="attribute" def:attribute="def_attribute"/>


</A>
Marked as Answer by Geraud · Sep 27 2020
Geraud

Weird, I really thought I had tried this approach and it didn't work. I must not have commented out another line that I should have. This works, thank you.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 5 2012
Added on Mar 8 2012
#business-intelligence-applications, #financial-consolidation, #performance-management-applications
0 comments
75 views