JAVA API get view array with header???

Post Reply
Drg
Regular Participant
Posts: 159
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 »

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
Regular Participant
Posts: 159
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 »

No ideas?
Am I the only one who has faced such a challenge?
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Drg
Regular Participant
Posts: 159
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 »

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
Regular Participant
Posts: 159
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 »

UP
tomok
MVP
Posts: 2831
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 »

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
Regular Participant
Posts: 159
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 »

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