COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: stancho on 31 Jan 2011 01:09:52 PM

Title: Add new row in TM1 cube/database?
Post by: stancho on 31 Jan 2011 01:09:52 PM
Hi all,

I have tables Sales and SalesForecast in the database.
I have the plannig for all sales for the next months in SalesForecast.
Ex. I plan to sell: 500 tents, 1000 sleeping bags etc.
Is it possible to add new row in the table in the database (or in the cube).
So I want to add: I also plan to sell 100 skis.

Is this possible using TM1? How this should be done?
I only see the feature to change existing values (ex. to change the planned 500 tents to 600).

Thanks and Regards,
Stancho
Title: Re: Add new row in TM1 cube/database?
Post by: OLAPBPMguy on 01 Feb 2011 12:47:09 AM
When a new member is added to a TM1 dimension it is instantly available for data entry in all cubes to which the dimension belongs.

You just need a generic process to add a dimension member and a form to run the process (the native UI is not pretty but administrative tasks such as adding members can be made intuitive and attractive using forms.) - However usually new members would be added automatically via ETL from a source system...