how can we update data from data base to cog web appliacation

[anilkumar]

hi all
how can we  update data from database table to cog planning  web application.

eg:
in go_capex_contributor asset purchase dimension i enterd some values in cost column 2200 and 300
and published using table layout. now i wud modify thisvalues  in database tables   (in ms sql server) instead of 2200 to 200 and 300 to 100

my qqqq  is how can i bring this modified values to cog web application

its very urgent assignment help me out


Regards
ANIL K.MARRI

[StuartS]

Hello

From reading your post you are changing values in the PUBLISH database.  The planning model works from the PLANNING database, (which I understand to be in xml).

Changing data in the PUBLISH database will make no difference to the planning model.

I would suggest that you capture the data value changes, put in a txt file and load into contributor through the CAC Copy, Load, Prepare function.

Regards

Stuart

[shethsameer]

Hi Anil,

There are couple of ways to get the data from DB but the below steps contains NO manual intervention and it can be automated.

1.   In Analyst create a copy of the go_capex_contributor.asset purchase DCube save it as 'asset purchase data' or whatever like to name it.
2.   Create a DLink and select the source as 'ODBC (SQL) Database'
3.   In the query window, write your query to fetch data from the table where you had it modified.
4.   Save and execute the DLink
5.   Once the data is imported you can have a macro created in Analyst, which will run the above DLink and export the DCube in CSV file format
6.   As well you can create a macro in Contributor which will Copy, Load, Prepare, GTP the above CSV file data.

Now you have imported the data from a DB into the Contributor Web.

Hope this help.

Regards

Sameer Sheth
IBM Certified 8 Consultant – Planning