How to access structured properties like si_webi and si_universe

[Former Member]

Hi Experts

I am trying to develop a jsp page which lists out webi reports,the universe on which it is based.I am facing difficulty when i fire this query:

select si_name,si_owner,si_universe,si_parent_folder from ci_infoobjects where si_kind='webi'

Though i get the output like the one below:

                                                                                                          I am not able to find a way to access the contents of si_universe like the universe id(4981) using java sdk.
Please guide me how to access these nested contents of si_universe.

Thanks in advance.

[Former Member]

Thanx a lot prithvi ..

I will try this out..:)

[Former Member]

Hello Ankit,

You would need to use the IProperties class of BusinessObjects Platform SDKs.

I am attaching a sample snippet for your referrence.

String query = "SELECT SI_ID,SI_NAME,SI_UNIVERSE FROM CI_INFOOBJECTS WHERE SI_KIND = 'webi'";
  IInfoObjects webiObjects = (IInfoObjects)iStore.query(query);
  for(int i=0;i<webiObjects.size(); i++)
  {
  IInfoObject webiObject = (IInfoObject)webiObjects.get(i);
  IProperties webiProperties=webiObject.properties();
  IProperties webiProperty=(IProperties)webiProperties.getProperties("SI_UNIVERSE");
 
  String universeTotal=webiProperty.getProperty("SI_TOTAL").getValue().toString();
 
  Integer universe=new Integer(universeTotal);
    if(universe.intValue()!=0)
  {
  for(int temp=1;temp<=universe.intValue();temp++)
  { 
  String universeID=webiProperty.getProperty(""+temp).getValue().toString();
  String queryWebi = "select SI_NAME from ci_appobjects where si_id="+universeID;
  IInfoObjects universeQuery = iStore.query(queryWebi);
 
     
    IInfoObject universeObject = (IInfoObject)universeQuery.get(0);
             
 
  out.print(universeObject.getTitle());

 
    }
}

Hope this helps.

Thanks,

Prithvi