TI problem loading "Comments"
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
TI problem loading "Comments"
Hello,
I have a cube with 2 dimensions:
Inputs: elements are various items that feed the model
Input_Meas: two elements in this, one is Rates, the other is a string element "Comments"
I have the CSV setup as below
colA colB colC colD
Inputs Rates Measure Comments
element Data Element ????
I got error message saying the dimensions in the variables don't match the number of dimensions in the cube.
how can I update the cube with the comments as well?
thanks!
I have a cube with 2 dimensions:
Inputs: elements are various items that feed the model
Input_Meas: two elements in this, one is Rates, the other is a string element "Comments"
I have the CSV setup as below
colA colB colC colD
Inputs Rates Measure Comments
element Data Element ????
I got error message saying the dimensions in the variables don't match the number of dimensions in the cube.
how can I update the cube with the comments as well?
thanks!
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: TI problem loading "Comments"
Post your code from data tab?
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TI problem loading "Comments"
I would expect a file with 3 columns:
- an element for dimension 1
- an element for dimension 2
- the cell value
Don't think it's going to be more basic than this.
I have the feeling that, based on the questions you ask here in the forum, you will gain a lot with a basic TM1 training.
While this will be a paid training, it will help you in a great deal moving forward.
- an element for dimension 1
- an element for dimension 2
- the cell value
Don't think it's going to be more basic than this.
I have the feeling that, based on the questions you ask here in the forum, you will gain a lot with a basic TM1 training.
While this will be a paid training, it will help you in a great deal moving forward.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
I actually just went to a 3-day training, day one on reporting, day two on rules and day three on TI. I wish the training could be longer and cover more details...
The question really is that I have a string element in the measure dimension (as the last element) and I have a column in CSV that holds the texts for this comment element. in the TI process under variables, should this column go in as data with Type string or something else? I tried but couldn't make it to work.
Again I really appreciate your help!
The question really is that I have a string element in the measure dimension (as the last element) and I have a column in CSV that holds the texts for this comment element. in the TI process under variables, should this column go in as data with Type string or something else? I tried but couldn't make it to work.
Again I really appreciate your help!
- Attachments
-
- Capture3.PNG (14.97 KiB) Viewed 9127 times
-
- Capture2.PNG (16.14 KiB) Viewed 9127 times
-
- Capture.PNG (27.6 KiB) Viewed 9127 times
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: TI problem loading "Comments"
Thanks for posting screenshots. So you're trying to load the amount and comments at the same time, no problem in TI. You can define the contents of the Comments variable as Data the same way you did for the Amount variable in the variables tab (your 1st screenshot). In the mapping tab, you'll then tell the process which element in your measures dimension each Data variable maps to. When you navigate to the data tab after doing that, you'll see two CellPut statements in the generated statements section. The first will be a CellPutN that will write the amount to the Input_Meas measure and the second will be CellPutS to the comments measure (provided you set it up right in the mapping tab!).
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
Thanks so much for helping me out!! we went through a merger (4 big utilities merged) and the mergeCo is now using TM1 for budget/forecasts. I have no IT background whatsoever, so I'm very sorry if my questions are too basic for you. The problem with TM1 is that, unlike Excel with which I can always find solutions by googling, it's a lot harder to find answers directly related to my questions.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
sorry I tried but got the same popup, I don't understand as I have two dimensions and I have two elements under variables?
- Attachments
-
- Capture2.PNG (24.34 KiB) Viewed 9114 times
-
- Capture.PNG (11.02 KiB) Viewed 9114 times
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TI problem loading "Comments"
This screenshot looks okay, inspect the subtabs in the Maps tab.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
I can't proceed, the same pop up came up when I clicked on Dimensions or Advanced. and I tried to delete the process and recreate it, same thing happened. What else could have gone wrong here?
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TI problem loading "Comments"
If you can, set all Contents of the Variables to Other. Like that, the wizard is bypassed.
Then move on gradually. Did you do that ?
Then move on gradually. Did you do that ?
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: TI problem loading "Comments"
Set the third variable to other or ignore and you'll be able to proceed.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
yes it worked! what is the logic behind this if you don't mind me asking?
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
thanks so much for your time!
-
- Community Contributor
- Posts: 312
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: TI problem loading "Comments"
Defining variables as Data/Element/Consolidation/Attribute serves only to help the TI determine what else you need to define in the Maps tab in order to prepare the generated statements for the prolog/metadata/data/epilog tabs. You could mark all the variables as other and write the CellPutN and CellPutS statements in the data tab for this example yourself. You can test this if you want by first going through the Prolog, metadata, data, and epilog tabs and copying all text in the generated statements sections and pasting below each section and then change all variables to other. Cycle through the prolog/metadata/data/epilog tabs and you'll see the generated statements disappeared except for where you pasted outside of that section. As you get more experience and comfort working in TI, you may find that you prefer to mark all variables as other and write the code in prolog/metadata/data/epilog tabs freehand. Doing so will give you more flexibility and make you a better developer. In the meantime, scrutinize the generated statements to help your own understanding and keep the TM1 reference docs handy.lynnsong986 wrote: ↑Wed Oct 09, 2019 9:47 pm yes it worked! what is the logic behind this if you don't mind me asking?
For your specific example, you needed to change variable 3 "measure" to other/ignore because your cube has 2 dimensions and you had marked 2 variables as element and another 2 as data. With each element variable mapping to one dimension in the cube, the TI would only expect 1 data variable. Having 2 is nonsensical to the TI because you wouldn't want to write 2 data values to the same measure. When you have more than 1 variable marked as data, the TI will expect the count of variables marked element to be one less than the count of dimensions in the cube and you'll then specify in the Maps tab which measure each data variable goes to.
Hope this helps.
IBM reference on TI functions, essential when writing your own script in TI:
https://www.ibm.com/support/knowledgece ... 70006.html
IBM reference TI tutorial:
https://www.ibm.com/support/knowledgece ... c0007.html
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: TI problem loading "Comments"
I didn't expect any answers yet you took the time to explain it in such great details...I can't tell you how much I appreciate it!!
I did go through a few rounds during my training changing variable type to "Other" then manipulate the codes directly under Map. I didn't realize where the problem was and didn't even consider doing that in this situation.
I really like TM1 and will continue to learn it, hopefully I'll be good one day!
thank you so so so much!!
I did go through a few rounds during my training changing variable type to "Other" then manipulate the codes directly under Map. I didn't realize where the problem was and didn't even consider doing that in this situation.
I really like TM1 and will continue to learn it, hopefully I'll be good one day!
thank you so so so much!!