I have problem with definition for Hyperion planning data server connection. Which data server I need to use for Hyperion Planning connection. Planning app is on separate servers than cube. Cube is on Essbase server. That means I need two different connections, one for data (essbase cube) and another for metadata (server where is planning app). Is this all right?
I made only one connection on essbase server and try reverse engineering to bring essbase cube, which I made with planning, to model but he bring me an error:
com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Could not connect the Planning instance on host hostname], port [port], check if connect information is correct.