TM1 Forum

Hello again guys, I'm facing difficulties in getting the last possible date in my .CSV file. Here's the scenario: Supposed I have a CSV file with 'Date' column (together with other columns). Example, I have 66 rows of 5/1/2017 (May 1, 2017) data, 10 rows of 5/2/2017 (May 2, 2017) data, and so on and...

Hi Guys,

Good day.

Thanks for all your inputs! I gained the idea based on your suggestions, it now gives the desired result and output looks good.

Thanks everyone!
Michael

Do you want to extract NSW and SS from the string or do you want to dynamically extract the string after the first pipe and the string after the second pipe? if you want to store NSW and SS in a variable then just say v1 = 'NSW' and v2 = 'SS'! Of course I know this isn't what you want to do but it ...

Sorry I haven't tried out yet.

Hello Guys, Good day. I'd like to know how can I extract sub-strings from a string. Please see the following example: PEPSI-MS-0870-3/PO:4500752654.30|NSW|SS I would want to extract the 'NSW' and 'SS' from that string and store them in separate variables. How can I possibly do this in TM1? My senior...

Hi Gurus,

Good day!

I would like to know if anyone tried to connect TM1 to Xero (Accounting Software)? If yes, did you used ODBC and can you give some techniques/guidance in achieving that?

Thanks,
Michael

tomok wrote:DimensionElementComponentDelete, DimensionElementComponentAdd

Hi tomok,

But it will also delete employee's data right? For example if Michael Busita has already data for Annual Salary measure, it will be deleted if I use DimensionElementComponentDelete function.

Hi Guys, Good day to you all. I'd like to know if it is possible for TI to move elements between consolidation hierarchies? If possible, what would be the best suitable function for it? Here's a scenario: In the "People" dimension, the following structure exists. - All People - Directors +...

Based on your rule you should feed to the 'Directors' consolidated element of the 'People' dimension in the 'Labour Costs' cube from the 'Plan P&L' cube instead of feeding to !People. Also, please save yourself a lot of hassle by not using spaces or other non-alphanumeric characters in cube and...

I would guess the plan p&l cube doesn't contain the !people dimension. You can only reference what dims are in the cube the rule or feeder is attached to. Hi Pandinus, Thanks for the input, I combined your thought together with Declanr's and it no error output. It's for testing now to see if th...

Hello Experts, Good day! I'd like to ask for your inputs regarding this scenario. I have a "Labour Costs" cube with the following rule: ['Oct','Director Bonus'] = N: IF(ELPAR('People', !People, 1) @='Directors', DB('Plan P&L',!Version,!Financial Year,'Q1','All States','All Practices','...