TM1 Forum

Then you can: 1) Set up a 2nd cube next to the first cube, with the correct dimensions if they differ from the dimensions in the first cube 2) You have 2 sets of processes, one set to each cube, and with the different logic 3) You run the processes 4) You and some colleagues cancel your plans for t...

Where to start... Firstly, it wouldn't be sensible to review the destination cube till all the concurrent processes are complete. Secondly, TM1 exists to roll up data to totals. If the dimensions of your cubes have been designed sensibly there will be totals on almost all dimensions. Create a slice...

Hello everyone, We consider using the different method to load/write cube. In general, if we choose to use the concurrent TI process, the total job will be done faster. But since the TI called by another TI which is also called by the other TI, there will be several layers to finish the job. It also...

Check your service account you are using for TM1. It might be the service account don't have proper privilege compared with the one you run the PS script. Hi macsir, You are GOAT. In DEV environment, it works according to your instruction. But it still has some problem in PROD, I will upgrade from ...

Might try changing to this: sCommand = 'Powershell D:\TEST\file.ps1 2>ErrorFile.txt'; and try to capture any errors the Powershell script is returning. The TI code looks fine. Hi PavoGa, Thank you for your idea! Even though I can't run the code you provide, I still look for an alternative to reach ...

Hey guys, Here is the code I execute successfully. #TI sCommand = 'Powershell D:\TEST\file.ps1'; ExecuteCommand(sCommand, 0); #PS New-Item c:\TEST\new_file.txt -type file However, when I tried to use TI to call PowerShell to log off a user or clean user's profile on another server, it did not work! ...

Thanks for both responses above.

Due to several reasons, my company chooses to stay on TM1 10.2.2 which is unavailable to colorful syntax in the TI editor like in PAW.

That's why I need to find another editor for coding. And possibly the most convenient way is still Notepad++ for now.

Thank you, Wim.

Recently I just study on how to create self-defined grammars for Atom since it has version control function.

Is there a possible way to convert UDL(User Define Language) from Notepad++ to Atom's grammars and CSS coloring?

Hello~ I have no idea what kind of code editor would be easy for everyone to write code and possibly has version control. The one I am using to write TM1 code is Notepad++. It's great but I still look for others possible more suitable for me. Is there any code editor better than Notepad++ ?? Could a...

lotsaram wrote: ↑Thu Aug 10, 2017 6:49 am
a table where each column represents a level of the hierarchy

Thanks a lot.

I think the thing is clear. We have to output the format suitable for Tableau to recognize the hierarchy and eat.

This point is very informative and useful.

If you want to avoid scripts in Turbo Integrator (even though it's not very hard) you can also right-click a dimension and choose to export to a flat file. This functionality exists out of the box. Thanks a lot. I have already read "Bedrock.Dim.Export" and tried to write dimension info to...

Exporting data from TM1 is quite simple. You build the view you want to extract and then use ASCIIOutput to write to a text file. If you want the hierarchy for a dimension you can write a TI that dumps out the parent/child relationships. For answers on how you can import this into Tableau you shoul...

In the most simplistic way, yes. Export cube view and import into Tableau. But things get slightly complicated if you need hierarchy structure. Most likely you will need to build TI that will export the hierarchy structure together with the data. Moreover, this will be unique to a specific cube/cub...

As the title, I have searched online and noticed there is a business solution to help this issue. But if we want to do it manually, how could it possible to migrate data from tm1 cube to tableau without changing the structure. The only way now I figure out is output data from cube to .csv and let ta...