TM1 Forum

I have a view to look at level 0, so main code are done in data tab. I need to put in char(34) / double quotation mark, as I need to use the export in Qlikview, by doing the string, the system thinks it is one long text. Data ## To print Header ##################### IF( vExported @= '' ); vExportStr...

Declan

Thank you very much, it's very useful.

I have changed the code a little bit, as I already have a view with level 0 on the dimension.

Phyllis

I have about 20 }ElementAttributes_xx cubes like below that I want to export to Text File, but they all have different numbers of attributes. Instead of having 20 different TI, I want to have just one. Can someone help me on how I can approach it please? Dim1 Attribute1 Attribute2 Attribute3 A A1 A2...

Thank you all for the very useful information. It will save me a lot of times.

Sorry for the late reply, my inbox has put all the tm1forum emails to junk... :( Carl, we are using TM1 as reporting, so we don't use the sandbox/committ model. And the data was defintely there, as I have copied the data from production to development about a month ago, and I can see the data in dev...

Hi all Is there a quicker way to compare rules and TI processes in 2 different instances (production and development), than comparing them line by line manually? Many developers had worked on the projects, and sometimes they were not updated in both versions. And I think it's time to do a clean up, ...

HI I have this scernaio at work, some data for a particular company just gone missing. The period for the missing data has already been changed to read only, the only one can overwrite the data are admin users. We don't go into the production data unless we have to. Is that possible that a restart o...

I think the flow chart will be useful to understand all the relationship between cubes and process. Is there any approach that can speed up my learning curve? I guess I am kind of looking for a short cut, but I know it's impossible. I just want to hear from the experienced people and see how they ap...

Thanks all.. It sounds like I will have a lot of "fun" documenting them, anyway it will be good for me to understand those instances.

We are still on 10.1, not sure when we will upgrade to 10.2 yet though.

There is about 3 different instances in TM1, and they are all been written by different contractors who no longer worked for the company. All the instances are working fine, and they are maintained by new contractors, but there is not much documentation around. I just joined the company recently as ...

Thanks for the link. It will be my weekend reading.

Thanks for the info, but the article "A collection of introductory questions about writing TI Code (O.A.F.)" cannot be accessed, do you have a pdf copy that I can have please? or there is another link for it?
Thanks in advance.

What is the best way to learn about TI? How did you learn it in the first place? Any tips and hints would be appreciated.

I have done the IBM course, but there are only 2 exercises.

Thanks.
Phyllis

Actually should be using TM1DRILLDOWNMEMBER instead of DRILLDOWNLEVEL

I found the way to do it now, so happy.

=TM1RPTROW($C$9,pServer&":Country",,,,,"{DRILLDOWNLEVEL( {[Country].[" & $D$18 & "] })}")

if I put in the Region, then it works. TM1RPTROW($C$9,pServer&":Country",,,,,"{DRILLDOWNLEVEL( {[Country].[Region 1]})}") But if I like it to a cell like below, then it doesn't work. =TM1RPTROW($C$9,pServer&":Country",,,,,"{DRILLDOWNLEVEL( {[Country].$D$18}...

Hi all I have an unbalanced dimension (Country), and I want to show level 0 items only, but it has to be based on user's selection. e.g. C: Total C: Region 1 N: Country 1 N: Country 2 C: Region 2 N: Country 3 N: Country 4 For example, if the user select Level 0 Country 1, then I want my report to sh...

Declan

Thanks for the clarification.

It makes a lot more sense now.

P

Hi all I am a beginner in TM1, and I am looking at the IBM rules guide. I can't seems to understand this CONTINUE example they use in the guide. ['Jan']= if(!region @= 'Argentina',10,CONTINUE);['Jan']=20; Why can't they just write it as below: ['Jan']= if(!region @= 'Argentina',10, 20); Thanks in ad...

Stephen

Thanks for your suggestions, my colleagues have already given me the rules.pdf, TM1 Cookbook, and some old training notes. The online one suits me better as I can do it at my own pace, and I usually sit with contractor at work to learn real life examples.

Phyllis