.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

How to call assembly in SSAS

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
Hi,   Any pls tell me how to call assembly in SSAS.   i want steps to call the assembly I want to write decryption logic in assembly. Then i want to call the assembly in SSAS. Please any one help to solve the issue. Thanks, Abdul2010    


View Complete Post


More Related Resource Links

how to call c#.net assembly remotely.

  

Hi all,

   am created a .net assembly in one machine, how do i call this assembly remotely from another machine. Can u give the sample code for this.

 

Thanks,

Sanjay........


Calling Assembly in SSAS

  

Hi Experts,

Im using

While using the below MDX query im facing the below error.

 

select security_new.StoredProcedures.security_enc(1) on 0 from EncryptedCube

Executing the query ...
Execution of the managed stored procedure security_enc failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException.
The System.Data.SqlTypes.SqlInt32 type cannot be converted to an MDX type.


SSAS security safe method assembly

  

Hi,

        Any one pls tel me im using Permission as unrestricted in SSAS assembly. The following query is executing but when i use Permission as Safe in SSAS assembly it is not working.

Please tell me about Safe Permission in SSAS assembly.

How to use Safe permission in SSAS assembly.

 

 


Call Statement in SSAS calculation

  

Hi Experts,

 Any one pls tel me how to use the following statement in SSAS calculations

call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=TMDEVDWHSRV01;Integrated Security=SSPI;Initial Catalog=BankingDWHStg"
    ,"Exec DecryptPANKey 1")

 

While i use the above statement in SSAS calculated member it is showing error as

"MdxScript(Dax Data Mart) (8, 5) Parser: The syntax for 'call' is incorrect."

Or tell me how to use the above statement in SSAS Calculations or in Named query

Pls help me to solve the issue.

 

Thanks,

Abdul2010


How to create call statement as object in SSAS

  

Hi Experts,

                 Any one please tell me how to create as object or attribute for the below Call statement.

Otherwise please guide me how to use the below statement in SSAS.


call SQLQuery.ExecuteSql(
    "Provider=SQLNCLI10.1;Data Source=DWHSRV01;Integrated Security=SSPI;Initial Catalog=Banking"
    ,"Exec Key 1")

 

Thanks,

Abdul2010


How to intercept an Excel PivotTable call result from an SSAS cube?

  

We have a SSAS Cube (2008 R2) on a server, which end-users are viewing with Excel 2010’s PivotTable interface.

We now want to stop end-users dynamically from drilling down to sensitive data.

Specifically, we want to dynamically block the return of any pivot table in which any element has a count of less than k  (and ideally: an error to be displayed ‘query results would return sensitive data – please modify your query’)

This feature should be implemented on the server-side cube not at the level individual end-user's Excel (e.g., Excel add-in).

 


SSAS Assembly Error: The main assembly has the same public key

  

I've created a CLR Analysis Server assembly that uses the ADOMD Client DLL. When I import the Assembly into my AS Server I don't receive any errors. But when I attempt to call the assembly I receive a #Error as the return. Hovering over the error it says that it can't find the Microsoft.AnalysisServices.AdomdClient.

When I try to add the ADOMD Client DLL, I get "The main assembly has the same public key as the components installed by SQL Server Setup, you cannot use it as the main file in a CLR Assembly Object. (Microsoft.AnalysisServices)"

So looks like a Catch 22 to me. What am I missing? If AS detects that the assembly already exists in the server, why doesn't it simply use the one that is installed instead of throwing the 2nd error stating that I can't import it either???

Clearly I am missing something in my interpretation of the error, has anyone ever seen this before and how can I get around the problem???


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Using jQuery to directly call ASP.NET AJAX page methods

  
Here I am looking to explain how to call page methods using jQuery. Using jQuery to directly call ASP.NET AJAX page methods

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

How to call an .exe file in .net

  
Sometimes a developer has to call an EXE from another EXE. While calling EXE there can be a requirement to pass parameter.

Error: Encountered multiple versions of the same assembly with GUID...try pre-importing...TlbImp

  

Hi!  Can someone tell me how I can troubleshoot the following error: "Encountered multiple versions of the same assembly with GUID...try pre-importing one of these assemblies".

The website developed in VS 2010 (.Net 3.5). This error is only received on my workstation.  Another person developing the site does not experience this issue at all.  Also, not sure if this matters, but on my workstation the 'Assembly Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.  The GUID being referenced in the error is the main project of the three projects within the solution.

I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.

If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error.  Once I make any changes, such as adding a new aspx file, then the error is received.

I can provide any additional information needed.


The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must

  

Hi,

This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
        {
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        }


Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

 

On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?

Thanks.


MySql.Data assembly problem

  

Hi,

I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
    </connectionStrings>
    <system.web>
        <compilation>
            <assemblies>
                <add assembly="MySql.Data, Version=6.1.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
            </assemblies>
    </compilation></system.web></configuration>


But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?


What the problem can be?





Registering controls of current assembly object reference NOT set error

  

Hi There,

I have created a simple ASP.net Web Application (2.0) and have added a web user control.

Now in my page I have added this control but I have registered like this,

<%@ Register Assembly="WebApplication1" Namespace="WebApplication1" TagPrefix="Custom" %>

Which means I want to access all the controls in my current Web Application project

Then I have added my user control like this,

<Custom:MyUserControl ID="MyUserControl1" runat="server" PublicProperty="Hello" />

Every thing is fine but when I execute the project, NO control on my user control gets "instantiated" and thus I receive error "Object Reference Not Set"

Note that My Control has,

1) Public property PublicProperty as String

2) 1 Label control

In Load Event Handler I am setting Text property of Label Control to PublicProperty. Here object reference NOT set error occurs (which means Label control is NOT initialized).

I don't want to register my control using Src, TagPrefix etc. Any ideas?

Thanks


Could not load file or assembly - Web Deployment Project

  

Hi,

I have the following projects in a solution :

- A Web Application

- A Class Library

- A Web Deployment project

The Web Application compiles and run fine when I don't go through the Web Deployment Project. However when I try to use that, I get the following error:

Error 1 An error occurred creating the configuration section handler for hibernate-configuration: Could not load file or assembly 'NHibernate' or one of its dependencies. The system cannot find the file specified. (F:\Folke\Folke.csproj_deploy\Release\web.config line 4) 1 1 Folke.csproj_deploy

"An error occurred creating the configuration section handler for hibernate-configuration: Could not load file or assembly 'NHibernate' or one of its dependencies. The system cannot find the file specified. (F:\Folke\Folke.csproj_deploy\Release\web.config line 4)"

This is the beginning of my Web.config:

<?

CLR Inside Out: Migrating an APTCA Assembly to the .NET Framework 4

  

The CLR security model in the Microsoft .NET Framework 4 has undergone some substantial changes, including the adoption of "Level2" transparency, similar to the Silverlight security model. Mike Rousos provides an in-depth explanation of how that will likely impact authors of AllowPartiallyTrustedCallers (APTCA) libraries.

Mike Rousos

MSDN Magazine March 2010


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend