TM1 Forum

@EvgenyT, this might look very silly to you but I have spent hours trying to do this simple thing because I am new to this world. the first answer AttrInsert('DimName','','AliasName','A'); itself was simple it is just that I'm doing it the wrong way. I'm trying to learn the basics and I am asking qu...

thanks Wim. I followed some turorials and i am able to load data. I actually asked the question in a wrong way.

How to add elements to my dimension with 3 alias not measures?

thanks again.

hurray! that work perfect! thank you Declan

Please help me load 3 columns of data from csv/.txt file to these 3 columns using ti or manually whichever is easier.

thanks again.

Hi everyone, I am trying to create dimension in TM1 cube with 3 alias but did come across any topic on how to achieve that. I know how to manually create a dimension without alias but for this topic I will need your help. for example I want to create region dimension 1st alias with ShortName = UK 2n...

thank for quick reply.

Is TM1 free available for Local Windows7 so that user can install small server/tm1 and perspective/cafe in windows7 and practice or get to know the software better?

thanks in advance for your answer.

Perfect... this information is very useful. Thank you!

If anyone is looking to create something like this there is no options like this. This thread can be closed.

All these options works and very helpful. Thanks everyone for helping. Thanks!

Okay thanks again. At least now I wont have to try something impossible .

thanks again this help. I'll have 2 forms to handle this.

Thanks for the inputs. So now I'm to work with one masterrow and maybe have all my condition in that row. Currently using 2 rows formulas I am trying to achieve below. in row1 B26 =TM1RPTROW($B$9,"TM1DEV:Region","",Ctrl!$B$2:$B$9,"Name",0) then I want C26 =TM1RPTROW($B$...

thanks for the link. I have gone through this link (Guidelines when working with Active Forms and IBM Cognos TM1) couple of times already in the past too. I could not figure out how to add 2 rows with formulas. I add them but when rebuild it wipes everything off by itself.

pleas advice.

Hi I want ActiveForm to have multiple TM1RPTDATARNG currently is single row. I have more combination row data I want to be able to sync data/drill. I tried changing the name range to include 2 rows but whn i rebuild the sheet it wipes off everything after the first row in active form where I have my...

Thanks this is very helpful.

Hi, please help me with MDX to drill/get decedents of multiple consolidated elements? I have a cost center dimension and I want to be able to drill bottom level for 3 of consolidated elements for single element i use {TM1FILTERBYLEVEL({TM1SUBSETALL( [CostCenter].[CCLV1] )}, 0)} now i want to do for ...

this works thank you.

I tried this but still doesn't work. Not sure what I'm missing out. It works perfect if I use teh TM1 ribbon Rebuild current book.

Hi, Please help me out here. I am using below VBA to Rebuild Current Book but doesnt seem to work.
I want to rebuild the whole workbook wherever I have activeform. Please advice
sub test1()
Application.Run "TM1RECALC"
end sub

You're right RJ. I tried the updating the view from Viewer and I am able to replicate the issue. thank for your help.

Also please advice. Do I need to have dynamic ActiveForm have lastest heirarchy sync/updated in my Excel report?

Hi I have TM1 Perspective SpreadSheet Browser (ISB) template which was working perfect. Everytime i recalc the whole view is re-sync (including new elements)...so everything was fine. Now today when I open the template the buttons are all like some shapes which can be selected and when clicked on it...