Evento AdomdConnection.CubeOpened
Viene generato all'apertura del cubo.
Spazio dei nomi Microsoft.AnalysisServices.AdomdServer
Assembly: msmgdsrv (in msmgdsrv.dll)
Sintassi
'Dichiarazione
Public Event CubeOpened As EventHandler
'Utilizzo
Dim instance As AdomdConnection
Dim handler As EventHandler
AddHandler instance.CubeOpened, handler
public event EventHandler CubeOpened
public:
event EventHandler^ CubeOpened {
void add (EventHandler^ value);
void remove (EventHandler^ value);
}
member CubeOpened : IEvent<EventHandler,
EventArgs>
JScript supporta l'utilizzo di eventi, ma non la dichiarazione di nuovi eventi.
Osservazioni
Il codice seguente fa parte di Analysis Services Personalization Extensions (ASPE) e illustra come utilizzare gli eventi CubeOpened e CubeClosing.
Nota
Il codice di esempio seguente può essere scaricato anche dal sito Web Microsoft SQL Server Samples and Community Projects.
Esempi
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.AnalysisServices.AdomdServer;
namespace ISV_1.ASClientExtensions
{
public class SessionMgr
{
public SessionMgr()
{
Context.CurrentConnection.CubeOpened += new EventHandler(CubeOpened);
Context.CurrentConnection.CubeClosing += new EventHandler(CubeClosing);
}
~SessionMgr()
{
}
public void CubeOpened(object sender, EventArgs e)
{
String username = Context.CurrentConnection.User.Name;
username = username.Substring(username.IndexOf('\\')+1).ToLowerInvariant();
//Verify and set user experience for opened cube
// that is define calculated members according to user profile.
AuthoringAndManagement.DefineMembers(Context.CurrentDatabaseName, Context.CurrentCube.Name, username);
// that is define KPIs according to user profile
AuthoringAndManagement.DefineKPIs(Context.CurrentDatabaseName, Context.CurrentCube.Name, username);
// that is define sets according to user profile.
AuthoringAndManagement.DefineSets(Context.CurrentDatabaseName, Context.CurrentCube.Name, username);
}
public void CubeClosing(object sender, EventArgs e)
{
//Close and discard any object that requires clean-up
}
}
}