AdomdConnection.CubeOpened Olayı
Küp açıldığında oluşur.
Ad Alanı: Microsoft.AnalysisServices.AdomdServer
Derleme: msmgdsrv (msmgdsrv içinde.dll)
Sözdizimi
'Bildirim
Public Event CubeOpened As EventHandler
'Kullanım
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, olayların kullanılmasını destekler, ancak yenilerinin bildirilmesini desteklemez.
Açıklamalar
Aşağıdaki kod, Analysis Services kişiselleştirme Extensions (aspe) bir parçasıdır ve nasıl kullanılacağını gösteren CubeClosing ve CubeOpened olayları.
Not
Aşağıdaki örnek kod da den yüklenen Microsoft SQL Server Samples and Community Projects Web sitesi.Karşıdan yükleme ve kurma örnekleri hakkında daha fazla bilgi için bkz: Yükleme sql Server örnekleri ve örnek veritabanları de SQL Server Books Online.
Örnekler
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
}
}
}