Search found 8 matches

by jimhung777
Tue Nov 21, 2017 3:16 am
Forum: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 505

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: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 505

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: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 8
Views: 505

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: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1133

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: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1133

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: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1133

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: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1133

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: Cognos TM1
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1133

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