Search found 14 matches

by jimhung777
Fri Jul 13, 2018 1:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 530

Re: Check if the data of two cubes are the same

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...
by jimhung777
Thu Jul 12, 2018 2:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 530

Re: Check if the data of two cubes are the same

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...
by jimhung777
Thu Jul 12, 2018 5:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 530

Check if the data of two cubes are the same

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...
by jimhung777
Fri Apr 27, 2018 2:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell to logoff and clean profile on another server
Replies: 5
Views: 487

Re: Powershell to logoff and clean profile on another server

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 ...
by jimhung777
Thu Apr 26, 2018 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell to logoff and clean profile on another server
Replies: 5
Views: 487

Re: Powershell to logoff and clean profile on another server

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 ...
by jimhung777
Thu Apr 26, 2018 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell to logoff and clean profile on another server
Replies: 5
Views: 487

Powershell to logoff and clean profile on another server

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! ...
by jimhung777
Tue Nov 21, 2017 3:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 1154

Re: Questions for Code editor (TI/Rule)

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.

:)
by jimhung777
Tue Nov 14, 2017 2:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 1154

Re: Questions for Code editor (TI/Rule)

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?

:D :D :D
by jimhung777
Fri Oct 27, 2017 5:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 1154

Questions for Code editor (TI/Rule)

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...
by jimhung777
Fri Aug 11, 2017 12:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1897

Re: Is there a free way to move data from cube to Tableau?

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. :D :D :D
by jimhung777
Thu Aug 10, 2017 2:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1897

Re: Is there a free way to move data from cube to Tableau?

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 flat file...
by jimhung777
Wed Aug 09, 2017 1:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1897

Re: Is there a free way to move data from cube to Tableau?

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...
by jimhung777
Tue Aug 08, 2017 7:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1897

Re: Is there a free way to move data from cube to Tableau?

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...
by jimhung777
Mon Aug 07, 2017 10:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1897

Is there a free way to move data from cube to Tableau?

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...