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
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
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