GetSchemaDataSet not returning correct results

the following function returns proprietry actions cube.  cube has 6 measure groups many-many relationships dimensions, fact relationships direct relationships (if has relevance).  code returns cell action exists long there no data in measure groups/fact tables have many-many dimension relationships...

 

so in summary, code correct , want do, when data exists behaves differently (incorrectly) , doens't return results.

 

has else had similar problems?  ideas , appreciated. 

 

thanks

james

 

public string getaction(ienumerable<member> celltuple)

{

string catalogname = this.command.connection.database;

string schemaname = null;

string cubename = query.cube.name;

string actionname = null;

int actiontype = 64; // proprietry

string cell = "(";

 

foreach (member member in celltuple)

cell += member.uniquename + ",";

cell = cell.trimend(',') + ")";

 

object[] restrictions = new object[] { catalogname, schemaname, cubename, actionname, actiontype, cell, 6 };

dataset actionsdataset = this.command.connection.getschemadataset(adomdschemaguid.actions, restrictions);

if (actionsdataset.tables.count == 1 && actionsdataset.tables[0].rows.count >= 1)

{

// don't come in here when should!!!!!!

}

 

return null;

}

SQL Server  >  SQL Server Analysis Services