TM1 Forum

Thank you so much for your help! I'm going to try it out!

Hello, I have a dimension "Company_BU" where each BU is rolled up into a company. another dimension "BU" has only the BUs not company. I need to copy the Alias attributes of the "Company_BU" dimension to the "BU" dimension. I found some codes on this forum but...

Thank you so much lotsaram for your time explaining this to me! I'll definitely give it a try!

I created a new cube and use rules to pull the numbers then use TI, it works. I think I know the answer. TI can only read/write from/to leaf-level cells?

Hello, I have a source cube "ca_tax" and a target cube "ca_bal_sheet_cash_flow". the source cube has 3 dimensions: Years, Company_BU, Tax_Meas the target cube has 3 dimensions: Years, Company, Statementline "Deferred tax Asset" and "Deferred Tax Liability" exi...

somehow it worked today! I guess I'm good for now...thanks Wim!

Hello, I have a dimension named 'statement_line' that has various line items in financial statements (balance sheet, income statement and cash flow statement), somehow the "filter by attribute" in subset editor is greyed out (there are multiple attributes attached to each line), can someon...

Hello, All of a sudden I got this message when trying to log in. I don't have admin privilege and I couldn't reach the TM1 guy at work on a Saturday... all I care for now is this question - will I lose any work I've done once the server gets back on? I tried to read a few threads online but I really...

oh wow I never thought of circumventing formulas like that, you are a genius! thanks a ton!!

Hello, I need some help with a circular reference in TM1 (knowing it is not allowed). Attached is a simplified model where a circular reference exists in excel: interest expense (to simply it I only calculate on short term debt) = STD * interest rate; interest is part of net income that goes into re...

Thank you so much Wim as usual!!

Hello, I came across a TI that dynamically creates a view after a bunch of dimensioncreatebyMDX, subsetelementinsert, viewsubsetassign and finally using this newly created view as data source (then copy the data in this view to a target view in data). I understand everything except the part that it ...

Thanks for the link! I'm a beginner and somehow I found Bedrock v3 is a bit easier to understand...very appreciated!

Thanks for the info, I don't think I'll use the direct method much at all knowing that I might crush the server!! my online trainer never got back to me on this question...I assume that he knew he didn't explain it correctly in the video haha!!

Wow that must be it!! thanks so much for your time letting me know!

it's not causing anything really, I just don't understand why it showed up...but I guess I can definitely ignore it sounds like this does happen in TM1... thanks!

Hello, I have a CSV file with 12 columns as data source, but the preview shows V1.......all the way up till v13 (all blanks underneath it - v13 is non existing in the CSV, column 13 has absolutely nothing), also there are 13 variables in the Variable tab. How can I get rid of this v13? thanks so much!

The problem is that we work at different work stations and he's super busy...I'll try to find the log files and go from there. Thanks so much!

Here is the error messages...

Did the execution of SampleExport when called by your 1st TI generate a separate log file of the errors it encountered? No I don't think so, it actually worked when I only have a list of names in the CSV name, it generated the CSV reports in the path with the names. but it didn't generate any file ...