Recently we upgraded our Hyperion product suite from 9 3 1 to 11.1.1.2.2.300.
I will list all the issues we faced on the road to latest and greatest hyperion product suite.
Issue #1
Its common practice of the users to reuse the smartview templates. When some of my users open smartview templates which were created in older version they get an error "COMMON PROVIDER SESSION TYPE MISMATCH". The error can be resolved by closing the sheet and open it again. However this is very annoying as some of the business users use Smart view for most part of their day. Oracle suggested the following resolution
"
1) Open workbook (Don't refresh),
2) In SmartView panel navigate to the required connection and connect.
3) Right click on connection and click on "Adhoc analysis".
4) Choose the following option on prompt "Reuse sheet content and pov".
5) A message box will display with following info "Old SmartView grid format detected, This operation will convert the grid into the new format, do you want to continue?" click Yes.
6) After that save the workbook and user can continue normally.
"
Subscribe to:
Post Comments (Atom)
Posts
Hi , I am new to Hyperion and have a question , can i integrate data from application to Hyperion automatically , for example i work on Hyperion planning integrated with Oracle E-business (GL)now my idea to integrate some data from Oracle Manufacturing and another sales application , can this executed automatically as the date sent from the application to Hyperion by requests , thanks
ReplyDeleteHi
ReplyDeleteyou can do it in multiple ways.
one way is to use ODI.
other is to export data from Oracle E-business in a flat file and load it to planning
let me know if you have more questions.
Thanks for your fast replay , what we want is to make this process automatically that make no need to enter data manually , will ODI make us do that ? ,
DeleteMy other question is about Hyperion business , how can i use Hyperion to do a deep analysis on my business , i mean what is in the books are the mix of region ,market , customer dimensions ,etc . what is the next level to did deeper in business analysis by Hyperion
Yes we can do it.
ReplyDeleteIf you don't have ODI you can use combination of SSIS and MaxL scripts to achieve this.
you can email me at ppasup123@gmail.com
we can discuss on this topic.
Your blog is unquestionably worth a read if anybody comes throughout it.
ReplyDeleteCurrently we are using Hyeprion 9.2.x.x version. we have two different environments. Both environments having their own back end DB's. Recently we switched the DB from one environment to another environment. So from the Hyperion application perspective we changed the host entries pointing to the new DB and comment the existing db entries.
ReplyDeleteNow the Hyperion application is connecting to new DB which we switched, but when we ran any job in the workspace the same job is running twice with same date and time stamp.
I am not sure why is it coming twice even we ran the same report once.
Could you please suggest me anything we need to change at Hyperion application config level, if we switch the DB from one environment to another.
Thanks in advance.
When we ran a job in workspace the same job is running twice with the same date and time.
ReplyDeleteCan anyone one suggest what would be the reason?
Anyone having idea about Hyperion upgradation from 9.2.x.x to 11.1.2.3
ReplyDeleteThanks for documenting this. It saved me a lot of time.
ReplyDelete
ReplyDeleteNice blog.Thanks for sharing wonderful information with us.
Hyperion Planning Online Training
Hyperion Planning Training