TM1 Forum

Am very new to TM1 Support.

There is a change Request, where we want all measures to be displayed under a cost center.

We have Various plants and the plants are transporting materials using different means like rail, road, air, water etc. The requirement is

If Plant is P1 and transporting via road the code should be 71xxxxx and via rail 72xxxxx, where code start is common ie 71,71, 73 74 and measures data should be residing for it.

Not sure how to do the same. Its okay to hard cord the logic as well, as the cost centers would be contant and no change.

Maybe zero suppression would just do this?

First of all you should prepare your metadata in advance, preferably outside of TM1. For example using an ETL-Tool (like Pentaho PDI or Talend). Or at least via Excel. Then you could import this preferably via a process (or for prototyping also by copy and paste from Excel).
Don't forget to read as a basis for your work: Kimball: The DWH Toolkit 3rd Edition (ISBN-13: 978-1118530801, search engine words:

kimball 3rd

might help also).
And the TM1 manuals for sure.

Hi ,

the ETL for our cubes is SAP BW and unfortunately this change cannot be implemented there. We need to find a work around at the cube level itself.

Also not sure why zero suppression is mentioned. Zero suppression would not help I believe.

Suggest you read the Request for Assistance Guidelines

http://www.tm1forum.com/viewtopic.php?f=3&t=1037

I've read your question several times and I am still none the wiser as to your issue

advayaaa wrote: ↑Fri Aug 04, 2017 6:47 am Hi ,

the ETL for our cubes is SAP BW and unfortunately this change cannot be implemented there.

Are you sure that you know what an ETL is? In TM1's case, it's TurboIntegrator. Also the "T" in ETL stands for "Transform". By definition, an ETL can change (transform) data from one form to another. I'll come back to that.

advayaaa wrote: ↑Fri Aug 04, 2017 6:47 amWe need to find a work around at the cube level itself.

Also not sure why zero suppression is mentioned. Zero suppression would not help I believe.

Probably because your question is far from clear. As Edward suggested you should read the RFA guidelines.

However if I had to guess:
(a) "the code" which starts with a 7 that you mention is the cost centre; and
(b) You are looking for some way to transform some (unspecified in your question) SAP BW values into that code so that you can write the value to the relevant cost centre.

If so, one common way of doing this is to have a mapping cube so that your TI code can do a lookup. The net effect of this is "If the value from SAP BW is X, then the mapping cube says that we use cost centre element 7001234. If the value is Y, the mapping cube says that we use 7001235" and so on. This is what the process of Transforming is.

However it's impossible to be sure that this is what you need without a much clearer question.