JAVA API get view array with header???

Post Reply
Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

JAVA API get view array with header???

Post by Drg » Mon Jul 10, 2017 3:53 pm

Hi guy's tell me how to build a view with setSuppressZeroes(true) and get coordinates of the cell?
Or the resultant arrays along the coordinate axes?

Example:

Code: Select all

//Create connection
...
//get cube 
TM1Cube Cube =ts.getCube("CUBENAME");
...
//loop dims, create N elements subset
...
//create view
TM1View View=Cube.createView(titleSubsetArr, columnSubsetArr, rowSubsetArr);
...
View.setSuppressZeroes(true);
View.constructArray();	
	
TM1Val Contents = View.getViewArrayValueByRange(1, 1, View.getNumberOfArrayRows(), View.getNumberOfArrayColumns());
//get value from Suppress Zeroes array

TM1Val CELL= Contents.getArrayVal(0).getArrayVal(1) ;
how i can get coordinats of this cell??? :roll: :roll: :roll:

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: JAVA API get view array with header???

Post by Drg » Tue Jul 11, 2017 6:44 am

No ideas?
Am I the only one who has faced such a challenge?

Wim Gielis
MVP
Posts: 1562
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: JAVA API get view array with header???

Post by Wim Gielis » Tue Jul 11, 2017 3:56 pm

Personally I haven't used that API yet so it would be difficult to give assistance.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: JAVA API get view array with header???

Post by Drg » Wed Jul 12, 2017 6:39 am

Wim Gielis wrote:Personally I haven't used that API yet so it would be difficult to give assistance.
IBM even says that it is part of the SDK(rest api, java extension). So I suspect that sooner or later it will remain a part of Performance modeler. :evil:

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: JAVA API get view array with header???

Post by Drg » Fri Jul 14, 2017 10:49 am

UP

User avatar
tomok
MVP
Posts: 2348
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: JAVA API get view array with header???

Post by tomok » Fri Jul 14, 2017 12:23 pm

This is a pretty obscure question and I'm not surprised no one has answered. I've never even looked at the Java API and quite frankly, don't know why I ever would unless I was trying to create some third-party tool to try and sell to the TM1 community. Bumping it up to the top each day is not going to accomplish anything.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

Drg
Posts: 62
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: JAVA API get view array with header???

Post by Drg » Sun Jul 16, 2017 6:13 am

tomok wrote:This is a pretty obscure question and I'm not surprised no one has answered. I've never even looked at the Java API and quite frankly, don't know why I ever would unless I was trying to create some third-party tool to try and sell to the TM1 community. Bumping it up to the top each day is not going to accomplish anything.
I would not ask a question on this forum, but only on this forum there is a detailed description of the use of Java api.

Was it interesting to know how you would solve the tasks of dynamic access to cubes from an external application?

Post Reply