Evento AdomdConnection.CubeOpened
Ocorre quando o cubo é aberto.
Namespace: Microsoft.AnalysisServices.AdomdServer
Assembly: msmgdsrv (em msmgdsrv.dll)
Sintaxe
'Declaração
Public Event CubeOpened As EventHandler
'Uso
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 dá suporte ao uso de eventos, mas não à declaração de eventos novos.
Comentários
O código a seguir faz parte das Extensões de personalização do Analysis Services (ASPE) e mostra como usar os eventos CubeClosing e CubeOpened.
Dica
O código de exemplo a seguir também pode ser baixado do site Microsoft SQL Server Samples and Community Projects.
Exemplos
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
}
}
}