If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

What is a datastore in planning CAD?

Started by renilrising, 13 Mar 2014 12:56:26 PM

Previous topic - Next topic

renilrising

Hi,
I am new to cognos enterprise planning and i would like to know what i meant by datastore in CAD.While doing a GTP in CAD we are creating a datastore in a database eg: SQL SERVER.I believe this will create a new database    in SQL SERVER for that particular application.Will this database store all the planning data entered by the user in contributor webclient,if not where is the planning data stored?   

ericlfg

Hi Renilrising,

Welcome to Planning and welcome to the community!

To start, when you say CAD are you referring to the Contributor Administrator? (also referred to as the CAC).  At a high level this is the hierarchy: 
Datastores > %sql_server% > applications > %custom_applications%

The %sql_server% will be your SQL server that has been added to the navigation.  The %custom_applications% are SQL databases that sit in your SQL server.  So if you are running a GTP, the application database already exists.  The actual data for the application is not accessible directly from the application database tables, if you're looking to extract the data you will need to run a publish.

Since you're new to planning, and if you don't already have it, please find below a link to all the IBM documentation for Planning version 10.1.0 and 10.1.1:

10.1.0:
http://www-01.ibm.com/support/docview.wss?uid=swg27019499

10.1.1:
http://www-01.ibm.com/support/docview.wss?uid=swg27023015

Good luck and post up any other questions.

renilrising

Hi ericlfg,

Thanks for your reply.But my question was when a normal user enters planning data ,where it is stored?Is it stored in these application database or in the analyst library files.Why we are using these application databases?

ericlfg

The contributor data that the end user's input into the applications on the web are stored in the application databases.  The analyst libraries are the structural objects used to build the application and generally do not contain data that end users have entered into the web (there are exceptions to this, such as running analyst d-links that pull data from contributor into analyst).

Hope this helps.

renilrising

Yes Eric .Thanks for your prompt reply.
I have another question here.Currently i have 3 planning applications in a data store which is sqlserver.I want to replace this current datastore and use another sqlserver which present in another machine.what is the procedure to do this excercise?