Attribute Types in AppEngine

Ralf Zerfass

Hello and happy new year to everybody,

I want to create an attribute table using an AppEngine  process, but don't know how to specifiy the attribute types.

Tried this:

string dim = "RLZ";

// Connect to database
OLAPConnection oConnection = DBConnection();

OLAPCreateAttributeTable(oConnection, dim, 3);

StringList sNames = CreateStringList();
StringList sTypes = CreateStringList();
StringList sDescriptions = CreateStringList();

Insert(sNames, 0, "ATT3_text_40");
Insert(sNames, 1, "ATT3_double_10_2");

Insert(sTypes, 0, "string(40)");   ***** what is the correct way to define string length and double precision?????
Insert(sTypes, 1, "double(10,2)");

Insert(sDescriptions, 0, "Text-Descr");
Insert(sDescriptions, 1, "Double-Descr");

OLAPCreateAttributeTableFields(oConnection, dim, 3, sNames, sTypes, sDescriptions);

OLAPDisconnect (oConnection);

When trying this, OLAPCreateAttributeTableFields fails with "Unknown attribute type".

Unfortunately, couldn't find anything in the documentation, so I'm asking for help in the user group.

Thanks for any tipps and help,

Ralf

John Robson

Ralf
This may help. Bad is something's are hardcoded not parameters but it was for a specific use case.

Comments - you cannot modify an existing attribute table so the process optionally deletes attribute table 1 in this example.
It shows creation for Bool, String and Numeric.

#define EngineVersion 5.0
#define RuntimeVersion 5.0

bool CreateAttributeTable_v5()
@Description: "Delete and recreate an attribute table 1 for BPDDETAIL";
@Category: "xxx";
@Returns: "True";
{
//Created:202111
//Last Modified 01_Dec_2021 - saved as v5 and tags added.
//Tag:xxx
//Tag:OLAPAttributeTable
//Tag:OLAPCreateStringAttributeTableField
//Tag:try catch

int TableIndex = 1;
string database = "DEPMAPPS"; //The connection must exist in the Data Connections dashboard
OLAPConnection OLAPCon1 = OLAPCreatePooledNamedConnection(database);
bool DeleteExisting = true; //App engine requires lower case.
string errorMessage = "";
int errorCode = 0;
string sDimension = "BPDDETAIL";
//CAUTION - All existing attribute values including name, order position and assignment of schedule detail to schedule is lost when this process is run.

if (DeleteExisting)
{
//Optionally delete existing attribute table
WriteLine("CreateAttributeTable_v5: About to try to delete attribute table number " + ToString(TableIndex) + ".");
OLAPDeleteAttributeTable(OLAPCon1, sDimension, TableIndex);
}

try
{
OLAPAttributeTable table = OLAPCreateAttributeTable(sDimension, 1);
OLAPCreateStringAttributeTableField(table, "Name", "Name",252);
OLAPCreateNumericalAttributeTableField(table, "OrderPos","Order Position",20,0);
OLAPCreateBooleanAttributeTableField(table, "P_A","Assets & Depreciations");
OLAPCreateBooleanAttributeTableField(table, "P_B","Receivables");
OLAPCreateBooleanAttributeTableField(table, "P_C","Payables");
OLAPCreateBooleanAttributeTableField(table, "P_D","Accruals");
OLAPCreateBooleanAttributeTableField(table, "P_E","Equity");
OLAPCreateStringAttributeTableField(table, "Asset","Asset Category",1);
OLAPCreateBooleanAttributeTableField(table, "P_F","P_F");
OLAPCreateBooleanAttributeTableField(table, "P_G","P_G");
OLAPCreateBooleanAttributeTableField(table, "P_H","P_H");
OLAPCreateBooleanAttributeTableField(table, "P_I","P_I");

OLAPCommitAttributeTable(OLAPCon1, table);
WriteLine("CreateAttributeTable_v5: Attribute table created.");
}
catch (errorMessage, errorCode)
{
WriteLine("Error: " + errorMessage);
}
return true;
}