AdomdConnection.CubeOpened 事件
Occurs when the cube is opened.
命名空間： Microsoft.AnalysisServices.AdomdServer
組件： msmgdsrv (在 msmgdsrv.dll 中)
語法
'宣告
Public Event CubeOpened As EventHandler
'用途
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 支援事件的使用，但不支援新事件的宣告。
備註
The following code is part of the Analysis Services Personalization Extensions (ASPE) and shows how to use CubeClosing and CubeOpened events.
[!附註]
The following sample code can also be downloaded from the Microsoft SQL Server Samples and Community Projects Web site. For more information about how to download and install samples, see Installing SQL Server Samples and Sample Databases in SQL Server Books Online.
範例
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
}
}
}