SAP Knowledge Base Article - Public

1568540 - How to list the universes a user can access using the BusinessObjects Enterprise .NET SDK.


How to list the universes a user can access using the BusinessObjects Enterprise .NET SDK.


  • BusinessObjects Enterprise XI 3.1
  • Visual Studio 2005 / 2008


Below is the CSharp code to list all universes a user can access.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.Enterprise;

public partial class _Default : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)
        EnterpriseSession ceSession;
        SessionMgr ceSessionMgr = new SessionMgr();
        EnterpriseService ceEnterpriseService;
        InfoStore ceInfoStore;
        InfoObjects ceReportObjects;
        string sQuery;
        //logon to Enterprise
        ceSession = ceSessionMgr.Logon("Username", "Password", "System", "Authentication");
        //Create the infostore object
        ceEnterpriseService = ceSession.GetService("", "InfoStore");
        ceInfoStore = new InfoStore(ceEnterpriseService);
        //Create query to get  report
        sQuery = "Select SI_NAME From CI_APPOBJECTS Where SI_KIND = 'universe'";
        ceReportObjects = ceInfoStore.Query(sQuery);
        if (ceReportObjects.Count > 0)
            Response.Write("<table border=1 cellspacing=2>");
            foreach (InfoObject ceReportObject in ceReportObjects)
                Response.Write("<tr><td>" + ceReportObject.Title.ToString() + " </td>");
                Response.Write("<td>" + ceReportObject.ID.ToString() + " </td></tr>");
            //no objects returned by query
            Response.Write("<br>No report objects found by query <br>");


KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem


SAP BusinessObjects Xcelsius Enterprise 2008