Hi all,
I am new to Cognos TM1
I want to write a simple script for creating a dimension hirerchy with out any source file , below is my requriment.
Dimension name should be = Codes
Inside the dimension my hirerchy should be
All Codes - Consolidation
|
C1 - Child
C2 - Child
C3 - Child
etc
C10
Can you please provide me the TI script.
Regards
Himen
Script using TI for creating a dimension hirerchy
-
- Posts: 3
- Joined: Fri Oct 18, 2013 7:47 am
- OLAP Product: cognos TM1
- Version: 10.2
- Excel Version: 2010
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Script using TI for creating a dimension hirerchy
Request for assistance guidelines (PLEASE READ)Himenkumar wrote: I want to write a simple script for creating a dimension hirerchy , below is my requriment.
Dimension name should be = Codes
Inside the dimension my hirerchy should be
All Codes - Consolidation
|
C1
Specifically, the section headed "TM1 TurboIntegrator Functions", sub-section "Dimension Manipulation TurboIntegrator Functions".RFA Guidelines wrote: 6) Give a brief outline of what you've done to find the answer; which manuals or guides you've looked in, what tests you've done. TM1 documentation isn't the best or most logically organised, and nobody expects new users to be able to find things which are obscure. It's OK to ask a question which more experienced users might consider obvious; we've all done it. However if the person answering your question knows what you've looked at, they won't waste your time or theirs by telling you what you already know. At a minimum, you should ensure that you browse the FAQ thread and use the search box in the top right to see whether there is already a solution to your problem. Also, please don't ask very basic questions about how to do things in TurboIntegrator or Rules without at least looking through the relevant functions in the Reference Guide.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3241
- 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: Script using TI for creating a dimension hirerchy
Himenkumar,
You don't need a degree in computer sciences or mathematics or whatever to use 2 functions in a Turbo Integrator process.
Did you really take out the time to read the documentation?
Your question is as basic as you can possibly go.
PS: it's "hierarchy" in English. Not hirerchy, as you seem to think for 3 times.
You don't need a degree in computer sciences or mathematics or whatever to use 2 functions in a Turbo Integrator process.
Did you really take out the time to read the documentation?
Your question is as basic as you can possibly go.
PS: it's "hierarchy" in English. Not hirerchy, as you seem to think for 3 times.
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: 3
- Joined: Fri Oct 18, 2013 7:47 am
- OLAP Product: cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: Script using TI for creating a dimension hirerchy
HI All,
please anyone else can give me the script.
Regards
Himen
please anyone else can give me the script.
Regards
Himen
Last edited by Himenkumar on Wed Oct 30, 2013 9:04 am, edited 1 time in total.
-
- MVP
- Posts: 3241
- 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: Script using TI for creating a dimension hirerchy
Priceless. You're the winner of the day !Himenkumar wrote:HI All,
Anyone else can give the script.
Regards
Himen
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
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Script using TI for creating a dimension hirerchy
See this? This right here? The bit where you've been told that you need to at least make some kind of attempt to do it yourself and you simply ignore that and demand that someone else "givez meh teh codez"?Himenkumar wrote:HI All,
Anyone else can give the script.
Regards
Himen
That would probably get you formally blacklisted at a site like StackOverflow. At the very least your little backside would be looking at a 2 week suspension.
We are rather more tolerant. That kind of attitude is more likely to only get you only informally blacklisted, where you can ask as many questions as you like but the wind blows and tumbleweeds roll down the street of your threads.
For any new members who do not expect to have their work done for them and are willing to not only learn, but put some effort into learning, don't be put off by replies like this or replies like Wim's. Re-read the original question. Note the lack of any form of effort to do any work to find an answer, or to even follow the forum guidelines. Note the complete lack of respect shown for people who give up their free time to answer these questions, respect that is shown in deed and not in word by not abusing the valuable and limited time of those who do the answering. The disrespect is shown not only by the initial asking of trivial questions that are covered quite well in the documentation, but by then re-asking without following the guidance given. That is what earns responses like these.
For new users who are prepared to make an effort and to use this resource with due regard for the value of it, the responses are not likely to be quite as... tangy, even if the questions are not in the advanced league.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 3241
- 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: Script using TI for creating a dimension hirerchy
Himen,
The general message is: read the documentation and try it yourself. Use Google to search for further help or see other code snippets.
If you're stuck or things don't work out as expected, please show us your code and explain what is the problem you face.
If you take that approach, I'm sure people will be happy to help you out or give pointers.
Do not ask: "give me the code" or any variant thereof without showing your own effort. It will not work.
The general message is: read the documentation and try it yourself. Use Google to search for further help or see other code snippets.
If you're stuck or things don't work out as expected, please show us your code and explain what is the problem you face.
If you take that approach, I'm sure people will be happy to help you out or give pointers.
Do not ask: "give me the code" or any variant thereof without showing your own effort. It will not work.
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: 3
- Joined: Fri Oct 18, 2013 7:47 am
- OLAP Product: cognos TM1
- Version: 10.2
- Excel Version: 2010
Re: Script using TI for creating a dimension hirerchy
Hi Alan,wim,
my intension of writing previous post is not disrespect anyone.as i m new here i don't know exactly what to be post in which way .so you can say my way of representation is wrong here.i apologize for that.
i m looking for basic scripting example where i can create dimension like this with below hierarchy.
"codes->all codes->c1,c2,c3..c10"... please help me out scripting part regarding my query.
Best Regards,
Himen
my intension of writing previous post is not disrespect anyone.as i m new here i don't know exactly what to be post in which way .so you can say my way of representation is wrong here.i apologize for that.
i m looking for basic scripting example where i can create dimension like this with below hierarchy.
"codes->all codes->c1,c2,c3..c10"... please help me out scripting part regarding my query.
Best Regards,
Himen
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Script using TI for creating a dimension hirerchy
I don't know how many more ways there are to say this.Himenkumar wrote:Hi Alan,wim,
my intension of writing previous post is not disrespect anyone.as i m new here i don't know exactly what to be post in which way .so you can say my way of representation is wrong here.i apologize for that.
i m looking for basic scripting example where i can create dimension like this with below hierarchy.
"codes->all codes->c1,c2,c3..c10"... please help me out scripting part regarding my query.
Have.
You.
Read.
The.
Documentation?
That is what you were asked to do. That is what you have given no indication of having done, even now.
We are here in part to discuss TM1, in greater part to give people a hand when they need it. We are not here to do people's work for them or provide them with ready made solutions.
You can talk about not being disrespectful until you're blue in the face but it's not worth the electrons it's printed on. Deeds, not words, count. Read the documentation, write some code based on it, and if it doesn't work then say "this is my code, this is what I've tried, and I have this specific problem with it".
Actually, given that this is TI 101 then if whatever code you write really doesn't work then it's time to book yourself in for a training course because it really doesn't get much simpler than this.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.