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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Exporting analysis service project

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

How do i transfer the analysis service project files and ensure that it works in another?

Do i need to set special settings?

View Complete Post

More Related Resource Links

Trying to call an asmx web service from a test project

I am trying to create a proxy for an asmx web service. The only thing I find in Visual Studio 2008 is a service reference. How do I call an asmx web service with a service reference? Certified Geek. Professional Data dude.

calling a web service on a remote server from a ASPX page (web site project VS2005)

HI,I am maintaining a web site project in VS2005 and have to call a new web service on a remote server. I've done add web reference, and created the .wsdl and .discomap files in the app_webReference folder.  When I try to create a object representing the web service in the code ( wsnamespace.serviceName ws = new wsnamespce.serviceName(); ) the code wouldn't compile.The web site project is already calling other web services. When I right click on the type representing the web service and "go to definition" it takes me to a proxy class (derived from of course SoapHttpClientProtocol) in the metadata. I think this is what's missing for  the new web service i'm trying to call. Have I missed any steps?Thanks in advance.-me

SQL Analysis Service based Status Indicator

Can you help me on this error while i am trying to create sql analysis service based status indicator.. 1- I created a .odc file connection string from MS Excel 2010. 2- After that I uploaded that file to my sharepoint site data connection list. 3-  After that I Selected SQL Analysis Server Status Indicator & uploded a .odc file from data connection list. After uploading .odc file it shows an Error : Error :- "This data connection does not use encryption for the communication with the SQL Server Analysis Services server. It is recommended to enable encryption for the SQL Server Analysis Services server to help prevent unauthorized users from viewing this information." Sharepoint version :- 2010 Thanks and Regards, Faheem Ahamed

Workflow Service not calling workflow in another project

I have a windows workflow service 4.0 that calls a workflow located in another project (i.e. another assembly). I have created a project reference in my workflow service project to the workflow in the other assembly. I have set a breakpoint in the workflow service receive activity and this breakpoint is hit. Next I step into the next activity which is an activity located in another project and the debugger does not work. Also the other workflow is sending an email.  It appears that the other workflow is not being called because I never receive an email from the workflow in the other project.   Any help is greatly appreciated.

Analysis Service Process Dimension Cause : OLE DB error: OLE DB or ODBC error: ORA-00942: table or v

Dear Gurus, I'd face a "STRANGE" problem. I'm using SQL2008 connect to Oracle Data Source (OracleOldDB.1) When I process a snow-flake dimension . There is a ORA-00942 problem. But if I past the SQL Statement to a Oracle Tool . It worked without any problem. Does any body ever face this "STRANGE" problem ? And I'd try to remove this table from data-source-view and re-join it . Still same problem !!  Wilson

Analysis Service Oracle Number inconsistent Data Type for TABLE or Named Query

Dear Gurus, I'd VERY OLD PROBLEM. And I believe it addressed since 2006. When I design DataSource Views from Oracle Data Source. I found it return different oracle number data type for TABLE or NAMED QUERY   Provider Data Type Column Data Type Data Source View Data Type Oracle OLE DB Provider (OraOLEDB.Oracle.1) Table Number System.Int64   View Number System.Decimal   Named Querey Number System.Decimal Microsoft OLE DB Provider for Oracle (MSDAORA.1) Table Number System.Double   View Number System.Double   Named Query   1 System.Int64   Named Query   1.1234 System.Int64 Althought I know I can fix IT via MANUALLY EDIT DATASOURCE VIEW XML SOURCE. But I don't think this is a better solution. Is anybody have ideas ?  Wilson

host and consume wcf rest service in web project in single solution

I have  create a solution which have multiple class library project and a web application Like Web(UI),BL,DAL etc. I have also add a WCF REST starter kit Collection project in the same Solution.WCF Rest API is working fine if I host it on IIS but i want to consume this in my web project without using IIS. Is this possible? if yes then what will be the URI  for my WCF Rest services? Add service reference is also not working because WSDL is disable in rest.

Cannot start Analysis Services 2008 service

Hi! I have Sql Server 2008 R2 and Analysis Services 2008. I could use it without problems for few days, but today, when I stop analysis service with Sql Server Configuration Manager and tried to start it again, it gives me error message: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". The msmdsrv.log file doesnt have any entries related to this error. Both Sql Server and AS are installed on my local machine and log on as LocalSystem. My system is XP sp3 professional.

Class project in Web Service-consuming website

I have a website project in VC2008. I add a web reference to a web service, and give it a name (ws). I can now do this:         ws.Service testService = new ws.Service();         ws.Customer objCustomer = testService.GetCustomer("1");   Perfect. Now, is it possible to move the Web Reference into a class file, referenced by my web project? I've done that, but now I can't access the ws object from the website application. Is this even possible? I've seen it done in another project, which I've tried to mimic exactly, but it's not working for me. Could it be an older version worked like that??   Thanks Sean

Deployment Problem of Analysis Service Tutorial

Hi all
 I am new in SSAS. I have install SQL server 2008 standard edition. Then i install Adventure Work Database. I have also read the tutorial from MSDN. I have also found the tutorial Lesson 4 start at 100 samples. But when i deploy the lesson 4 start The following error will occur.

Error    29    Internal error: The operation terminated unsuccessfully.        0    0   
Error    30    Internal error: The operation terminated unsuccessfully.        0    0   
Error    31    Internal error: The operation terminated unsuccessfully.        0    0   
Error    32    Internal error: The operation terminated unsuccessfully.        0    0   
Error    33    Internal error: The operation terminated unsuccessfully.        0    0   
Error    34    OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000.    &nbs

Setting process priority on C# 3.5 service project

Hi all,
  I'm working on a windows service that uses WCF with names pipes and Quartz.net to perform process scheduling.  Everything is running well, except I've hit a snag.  I have one process that's quite I/O intensive, and it kills my server while it runs.  Unfortunately, I'm legacied in to some of the architecture, so the process is as optimized as I can get it.  As a result of this, I have 2 questions.

1. Each of my jobs are encapsulated within a class.  Each of these classes are instanciated and run by Quartz in it's own thread.  When the Job starts, I have the following code in the Execute function

  /// <summary>
        /// Called by the <see cref="T:Quartz.IScheduler"/> when a <see cref="T:Quartz.Trigger"/>
        ///             fires that is associated with the <see cref="T:Quartz.IJob"/>.
        /// </summary>
        /// <remarks>
        /// The implementation may wish to set a  result object on the 
        ///             JobExecutionContext before this method exits.  The result itself
        ///             is meaningless to Quartz, but may be informative to 
        ///             <see cref="T:Quartz.IJobListener"/>s or 
        ///             <see cref="T:Quartz.ITriggerListener"

Named Set And Calculated Member within Analysis Services Cube project


Hi there.

I have got the mdx below (titled as MDX In QUERY SsMS) that works fine in SQL Management studio.

I am battling to include it in my Analysis Services project.

Following the logic in the mdx query, I have created the 3 named set and one calculated member (You will see them below), but with no luck.

Please any guidance will do, I desperatly need to include it in my cube



//Get Weeks with sales
[WeeksWithSales] as '
{[Product].[Product Hierarchy].[SKU DESCR]
,([Measures].[SLS R]) >0)}

//the first week
[FirstWeek] as 'HEAD([WeeksWithSales],1)'

[LastWeek] as
[NumWeeks] as 'count([FirstWeek].item(0).item(1):[LastWeek].item(0))'

[NumWeeks] on 0
 (select [Product].[Product Hierarchy].[SKU DESCR].&[BALL BRIDGESTONE 08 E7 +]&[1041597] on 0
 from (select ([FinancialDate].[Financial Calendar].[FINANCIAL MONTH].&[FY2010_MONTH06].parent.parent) on 0
   from [TPSMerch]))

Using WCF WF Service in a Web Project without creating a host



I have created a WCF Workflow Service Application which contains multiple WCF Workflow Services in it. And some of these services contain multiple Send-Receive activities in a flowchart/sequence.

In the same solution, I have created a Asp.Net Web project in which I have to use these WCF WF Services. In this Web Project, I added the Service Reference of the all the WCF Workflow Services that I have, but however when I try to invoke these WF services, it gives errors.

I went thru various samples and in every sample there is ServiceHost created which makes available an endpoint, and consuming the service using this endpoint makes everything working. Now my questions are:

1. Is there no way to make WF services work properly in a Web project without creating a WF Service Host??

2. I am also having problems in persisting a workflow. As I mentioned earlier, I have some services which have multiple send-receive activities in it so I need to persist the workflow instance until the complete workflow is complete. Again, I was able to do this using the Service Host, but how to do it without using a service host?


The problem is I have to host web application (and hence also the WF Services) on my Web hosting (GoDaddy) and on Azure Cloud and in both the cases I cannot create a separate Workflow Console Application that will work

What are layers in Analysis Service?

what is Layer and How many Layer in Analysis Services and what is each usage ? Thanks in advance

Connecting PPS to Service Analysis Cubes


I am new to PPS so this may be a basic question.  I have created a cube in BIDS and deployed it.  When I go into PPS dashboard designer and create a connection to Analysis Services I enter the name of the server and drop down the Cubes list.  It briefly says loading and then lists nothing. No error messages nothing.

I created another connection to the same server using SQL Server Table and that worked fine, listing all the tables.

I dont know how to ge the cubes to list.  Any ideas?

Miscrosoft SQL Server Analysis Service does not show conditions and calculated members



I am using MS visual studio 2005 to modify a report. The reports has got some filters (conditions) and calculated fields but when I open the report, all it shows me blanks values in condition window screen (where it displays Dimension, hierarchy, Operator, Filter Expression, Parameter fields) and also it does not display any calculated fields in the calculated members widnow. 

I am using SP1. Do I need to re-install the software or am I misisng some tool to turn on.

Thanks in Advance


Exporting to Microsoft Excel from a DataView Web Part consuming a Web Service with Parameters

In Sharepoint Designer, I've developed a page displaying a DataView Web Part which consumes an XML Web Service with three parameters.  These parameters are passed in from a simple Form Web Part containing three input fields.  I am able to provide default values for the web service so the dataview is initially populated, and when I enter in new parameters, the web service goes back, grabs the requested data and displays in the dataview nice and slick.

The problem I'm having is this: In Internet Explorer 7, when I right-click on the DataView Web Part and select Export to Microsoft Excel, Excel opens up, says "ExternalData_1: Getting Data..." and returns the data from the web service which applies to the default parameter values each and every time, regardless of whether I have changed the parameters on the web page, and contrary to what the DataView Web Part displays on the screen.

Has anyone else run into this, and is there a solution to the problem?

Best regards,
Mark Christie

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