How can i insert attribute with Java API?

Post Reply
jackie
Posts: 1
Joined: Fri Jul 01, 2011 10:30 am
OLAP Product: TM1
Version: 9.1
Excel Version: 2003

How can i insert attribute with Java API?

Post by jackie »

Hi All,
I got some troubles when i insert attribute for a dimension with Java API. The java source code and the output as below:

Java source code:
package HMI;

import com.applix.tm1.TM1Attribute;
import com.applix.tm1.TM1Bean;
import com.applix.tm1.TM1Dimension;
import com.applix.tm1.TM1Element;
import com.applix.tm1.TM1ObjectType;
import com.applix.tm1.TM1Server;
import com.applix.tm1.TM1Val;

public class Test {

public static void main(String[] args) {
try {
TM1Bean bean = new TM1Bean();
bean.setAdminHost("MyAdminHost");

TM1Server tm1Server = bean.openConnection1001("tm1serv_sol5_vn",
"jackie_test1", "jackie_test1");


if (!tm1Server.isError()) {
//dimensionCREATE.dimCreate(tm1Server,"jackie_test_dim","C:\\dim.txt");
TM1Dimension dimension = tm1Server.getDimension("jackie_test_dim");
if (!dimension.isError()) {
System.out.println("dimension=" + dimension);

TM1Attribute attribute=dimension.getAttribute("Name");

//TM1Element attribute=dimension.getElement("Name");
insertAttribute(dimension);
if(!attribute.isError()){
System.out.println("attrubute="+attribute);


}else{
System.out.println("###Occured error when getAttribute");
System.out.println("Error message :"+attribute.getErrorMessage());
}
}else{
System.out.println("###Occured error when getDimension");
System.out.println("###Msg:"+dimension.getErrorMessage());
}
} else {
System.out.println("###Occured error when open connection");
System.out.println("Error message :"+tm1Server.getErrorMessage());
}
} catch (Exception e) {
e.printStackTrace();
}
}


private static void insertAttribute(TM1Dimension dimension)throws Exception{

System.out.println("Is dimension writable?:"+dimension.isWritable());
System.out.println("Is dimension readable?:"+dimension.isReadable());

TM1Val tv1=dimension.insertAttribute(TM1Attribute.NullAttribute, "jackie_test",TM1ObjectType.AttributeString);
if(dimension.isError()){
System.out.println("***Dimension error:"+dimension.getErrorMessage());
}

if(tv1.isError()){
System.out.println("***Tv1 error:"+tv1.getErrorMessage());
}

}
}


Output:
dimension=com.applix.tm1.TM1Dimension@a39137
Is dimension writable?:false
Is dimension readable?:true
###Occured error when getAttribute
Error message :ObjectPropertyNotList



I check dimension "jackie_test_dim" after run the above program and found the new attribute "jackie_test" does not insert successfully. It's very urgent . Woule anyone help? Thanks.
User avatar
tianoklein
Posts: 41
Joined: Fri Jun 13, 2014 1:23 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: How can i insert attribute with Java API?

Post by tianoklein »

Hi Jackie...
I'm in the same hole...
Did you find the fix?
Post Reply