TM1 Forum

If this is a one shot deal, sometimes if I am lazy I use Excel to do it for me: Since you can Type out 3 Letter Months in Excel and click and drag to complete, same for Numbers, etc. Then copy and paste the values into the corresponding control cube. which is }ElementAttributes_Time (Assuming your d...

Hey BariAbdul, The issue I think is your view: As I mentioned earlier currently you are ONLY copying data for: Sa_PeriodDim -> Charged Current Year & Charged Previous Year Only This is the ONLY data that is (Or rather should be) being copied over. Alternatively if that IS the data you are lookin...

The period for the missing data has already been changed to read only I assume you have a Admin/Manager - Lock/Unlock Process for manual data entry and a specific period in which users have to enter said data? If it is a larger department, one of the issues we have run into in the past is users ste...

Some clarification questions: 1.) Does the new 9 dim cube: DU_SERVICES_REPORT_MASTER have the 7 original dimensions + Projection + Suppliers? (Your CellPut seem to imply this is the case) 2.) Is your intention to copy all data from the original cube (7dim) to the new cube or just some specific data?...

If I gather what you are trying to do correctly: You would like to automatically feed the Sequence # FROM an Number Type Attribute named: 'Sequence_Alias' on the Dimension:Sequence to the Cube Value: 'Seq_Code' in Measure. In Terms feeding it ['Sequence':'Sequence_Alias] => DB('Course', !Version, !S...

At the risk of beating a dead horse; and to expand on what Alan was saying, you can do the same thing in reverse: I.e. Step forward to the current month (Closer I think to what you were shooting for): This starts with Jan, and spits out the same file upto (including) the current month entered. #Prol...

And thank you for saving me as well.

You might look into scripting or pulling the Log files directly. Audit Log files are stored in the logging directory (Tm1Data by default): Audit Logs: tm1rawstore.(Timestamp) (I believe?) Transaction Logs: tm1s(timestamp).log You cannot access the tm1s.log file while the instance is running because ...

At the risk of sounding obvious: Metadata tab is for metadata changes, Data tab is for data changes. Your problem is that you are trying to use data functions like AttrPutS on the Metadata tab and metadata functions like DimensionElementInsert or DimensionElementComponentAdd on the Data tab. Do it ...

Hey all, Starting Learning TM1 about a month ago, so at the risk of this being something incredibly asinine, here is the issue I have run into: I am writing a process to either replace or amend a Dimension (user choice) using the input from a CSV. The CSV has 5 columns but here we are only dealing w...

I had the same problem I made the cube browse the active window (even though I could not see it) then pressed the Window key (the one next to the function key on the bottom left) together with the arrow keys to bring it onto the active monitor. Thereafter, all TM1 views used the correct monitor. ^T...