I need help with definition of data server and physical Schema? I use Hyperion Planning technology and put my server name with correct user and password. After I go to edit physical schema and try to put Application Catalog, and Work Catalog. What I need to put into this options? Does it need to show me automatic catalog=cubes from my server? In my way It didn't show me automatically and I enter the name of my cube application name. It did't show me any error but when I try to make reverse engineering in model in designer tab it didn't bring me any tables(dimensions) from my cube. I also use RKM Hyperion Planning.
First you have to define data server for hyperion planning and give user name and password during creation of data server( admin, pwd). then create physical schema as you are doing and you have to put manually catalog and work catalog name , it will be your cube name.
and now you can create model for hyperion planning
just remember when you do reverse engineering, your localagent services has to be started.
open cmd prompt
After that you can do reverse engineering,.