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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • BusinessObjects Enterprise XI 3.1
  • Visual Studio 2005 / 2008

Resolution

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>");
           
        }
    }
}

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008