Steps to create a planning application
-> Create a RDBMS database
-> Create a Datasource
steps to create a Datasource
Data source link the relational database to the Essbase server. You must create a data source when you create an application.Each data source must be associated with an instance.When you create or update applications using the Classic Application Wizard, you select a data source for the application.

1. log on to workspace.
2. I workspace select Navigate->Administer->Classic Application Administration->Planning Administration.
3. In classic Administration wizard , click Manage Data Source.
4. In Data source name enter a data source name.
5. From the select database platform drop down list, select a database type such as SQL or oracle.
7. In the application database area, enter Planning application details and click Validate database connection.
8. In the Essbase serverarea, enter Essbase server details and click Validate Essbase Connection.
9. Validate both connections and click finish

->Create a shared services Project
Steps:
Open the shared services using the following url
htttp://Shared services Server Name:28080/interop
1. Provide the administrator login details.
2. Click on login (admin,password)
3. Expand the Projects
4. Right click on project->click on new
5. Provide an appropriate project name
6. Click on Finish , Click on OK

-> Create a planning application
Steps;
open the work space using the following url
http://workspace webserver name:19000/workspace
1. Provide the login details.
2. Click on login
3. Click on navigate and click on Administrator
4. click classic administrator
5. click p[lanning administrator
6. click on create application
then it will displays all available datasources in a dropdown list choose the one you have already created.
7. provide the planning application name
8. select the shared services project from dropdown list
9. leave the default instance and click on next
10. select the base time periods as 12 months
11. click on next
12. Select the default application currency according to your reporting currency
13. click on next
14. select the number of plan types according to your number of departments that is going to use the budget application. technically each plan is nothing but a planning application under planning database.
15. click next
16.review your selection
17. click finish

once application has being created successfully
-> click on file->Open-> Applications -> Planning -> Name of application to open the planning application.