Registering A Assembly And Calling It From Managemnet Studio

Hi everyone,


i am trying to register a assembly in SSAS which i actually did fine as per BOL by right clicking on assembly folder and pointing to the dll file. And then i tried to call the function from management studio using Call command and Select statement...both outputs a error which looks like



Executing the query ...

Query (1, 6) The '[TestKPIMeasures].[KPIMeasures].[getKPIData]' function does not exist.

Execution complete


Let me explain my scenario so that you ll get a better picture. I have a cube named 'FourH KPI values' and i have registerd the below as dll file.



using System.Data;

using System.Configuration;

using System.Collections;

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 Microsoft.AnalysisServices.AdomdClient;

using System.Reflection;

using System.Reflection.Emit;

namespace TestKPIMeasures

{

public class KPIMeasures

{

public static System.Data.DataTable getKPIData(String Connstring, String ExecCommand, String kpimeasures)

{

CellSet cellset;

//DataSet ds = new DataSet("KpiDataSet");

DataTable dt = new DataTable("KpiMeasures");

// ds.Tables.Add("KpiMeasures");

try

{

//Create AdomdConnection object

AdomdConnection asConnection = new AdomdConnection(Connstring);

asConnection.Open();

String[] keyindicators = kpimeasures.Split(',');

string commandText = ExecCommand;

AdomdCommand command = new AdomdCommand(commandText, asConnection);

DataColumn column = new DataColumn();

column = new DataColumn("KPI Name");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI value");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI goal");

column.DataType = typeof(string);

dt.Columns.Add(column);

column = new DataColumn("KPI status"); column.DataType = typeof(string);

dt.Columns.Add(column);



foreach (string item in keyindicators)

{

command.Parameters.Clear();

command.Parameters.Add(new AdomdParameter("Value", item));

command.Parameters.Add(new AdomdParameter("Goal", item));

command.Parameters.Add(new AdomdParameter("Status", item));

command.Parameters.Add(new AdomdParameter("Trend", item));

cellset = command.ExecuteCellSet();

DataRow row = dt.NewRow();

row["KPI NamE"] = item;

row["KPI value"] = cellset.Cells[0].FormattedValue;

row["KPI goal"] = cellset.Cells[1].FormattedValue;

row["KPI status"] = cellset.Cells[2].FormattedValue;

dt.Rows.Add(row);

}

}

catch (Exception ex)

{

throw ex;

}

return dt;

}

}

}


Now i am trying to call the assembly from management studio,


CALL TestKPIMeasures.KPIMeasures.getKPIData("Provider=MSOLAP.3;DataSource=D64ETL01;Initial Catalog=FourH KPI values", "SELECT{KPIValue(@Value), KPIGoal(@Goal), KPIStatus(@Status)} ON COLUMNS FROM [Key Performance Indicators]", "Test measure,Test measure 2,KPI 3")

also tried Select statment...still no luck

Can anyone tell me what i am missing out.......Thanks in advance