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

Add new row in TM1 cube/database?

Started by stancho, 31 Jan 2011 01:09:52 PM

Previous topic - Next topic

stancho

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

OLAPBPMguy

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