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("<b>Reports</b><br>");
            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>");
            }
            Response.Write("</table>");
        }
        else
        {
            //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