TM1 Forum

I am developing a TM1 tool for MDX query stuff using MS VB.NET(express edition).
If I upload this tool to share, will that cause any licensing issue? IBM? MS?

macsir wrote:I am developing a TM1 tool for MDX query stuff using MS VB.NET(express edition).
If I upload this tool to share, will that cause any licensing issue? IBM? MS?

As you have created a client I can't see that this would create any issue since anyone using the tool would need a (properly licensed) server to connect to.

lotsaram wrote:

macsir wrote:I am developing a TM1 tool for MDX query stuff using MS VB.NET(express edition).
If I upload this tool to share, will that cause any licensing issue? IBM? MS?

As you have created a client I can't see that this would create any issue since anyone using the tool would need a (properly licensed) server to connect to.

Thanks for reply. Then I plan to release this tool in the couple of weeks.

I'm looking forward to this. It's pretty odd, I think, that TM1 supports MDX for subsets but not for views, assuming you don't want to dive into the murky waters of BI - and even there, I don't know anyone who has been successful in using custom MDX in a report.

David Usherwood wrote:I'm looking forward to this. It's pretty odd, I think, that TM1 supports MDX for subsets but not for views, assuming you don't want to dive into the murky waters of BI - and even there, I don't know anyone who has been successful in using custom MDX in a report.

Hi, David. The purpose of developing this tools for myself is helping debugging Cognos BI reports as they are using MDX to fetch data from TM1 server. The tool can help to you convert any TM1 view into MDX query and you can write your own MDX to run against TM1 cubes and then extract them into excel for analysis. Hope I can finish this tool soon.

macsir wrote:Hi, David. The purpose of developing this tools for myself is helping debugging Cognos BI reports as they are using MDX to fetch data from TM1 server. The tool can help to you convert any TM1 view into MDX query and you can write your own MDX to run against TM1 cubes and then extract them into excel for analysis. Hope I can finish this tool soon.

Oh. I was hoping for something different. Vizier already has a tool to convert any view to MDX. Did you look into that?

lotsaram wrote:

macsir wrote:Hi, David. The purpose of developing this tools for myself is helping debugging Cognos BI reports as they are using MDX to fetch data from TM1 server. The tool can help to you convert any TM1 view into MDX query and you can write your own MDX to run against TM1 cubes and then extract them into excel for analysis. Hope I can finish this tool soon.

Oh. I was hoping for something different. Vizier already has a tool to convert any view to MDX. Did you look into that?

Yes, I tried but failed. Looks like it can't find Applix.TM1.API.dll properly. How did you config this file into Vizier?