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

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

Modifying MDX for a Cube deployed on AS Server

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server


I have a cube deployed on an SSAS Server. Is there any way I can modify the cube's MDX online (without taking it offline) via a C# App?


Appreciate your soon reply!


View Complete Post

More Related Resource Links

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

Not able to access Class methods when deployed on a remote server?

I have a web service project. In the project I have a class named "Piper"In testing the web service in localhost mode in the VS IDE, I can access membersof the class, such as my method "Proceed" and property "Comber" The problem I am having is that when the web service is deployed to the serverin staging, or the deployment server, I am not able to access any methods of my class. Onlythe properties. This is very strange? As they are both public and I can access them when I run the project in local host in the IDE. Does anyone know what the problem might be?Here is a simplified example of my class. Public Class Piper Public Sub Proceed() End Sub Public Property Comber() As Boolean  Get   Return True  End Get  Set(ByVal value As Boolean)       _comber = value  End SetEnd Property End Class

Has anyone deployed and hosted SharePoint or Project Server 2010 on Amazon's EC2 'Cloud' yet?

Has anyone deployed and hosted SharePoint 2010 or Project Server 2010 on Amazon's EC2 'Cloud' yet?Kevin Williamson, MCTS, PMP Senior Advisor Advisicon

I have a deployed cube in SSAS,

Hi,   I have a deployed cube. How i can send it to my user so that he can do analysis.   Gaurav

How to remove deployed SSIS packages to SQL Server 2005?

Hi All I need to find a way of removing all packages deployed to a SQL server - can this be done?   Thanks   Big Gopher

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x


I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.


but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:

It means that I can not process the cube using the same method any more ?

Cannot Browse cube correctly after upgrading SQL Server 2005 to SQL Server 2008


I upgraded to SQL Server 2008 from 2005 and now when browsing my cubes only one measure displays at a time e.g. i can view two measures actual month and YTD the two displays but when i drag a dimension to the row, the actual month disappears and only YTD displays. if i remove the YTD measure the actual month shows again. Without the dimensions in the rows they both show. Does anybody have a suggestion on how to resolve this? it worked perfectly well before the upgrade.


Project Server 2007 Cube Building Error




I have no experience with MDX and it appears that during the cube building process for Project Server 2007 there seems to be some deficient MDX scripts.  I looked at the SASS logs with no luck and looked in the application logs with no luck.  I scripted out the problematic cube MSP_Portfoilio_Analyzer and found the 'Reported' syntax but don't really know how to correct or if there is even a problem.  The cube has built in the past with no problems.  Any help would be appreciated.


Server build is as follows:

Microsoft SQL Server 2005 - 9.00.3200.00 (X64)   Oct  2 2007 12:23:02   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)  


The server has both SQL Server and SSAS installed.

MSAS Cube synchronization under 10 MB/sec on one server, 36 MB/sec on other


Brief Problem Description:  MSAS Cube synchronization under 10 MB/sec.


We run more than 20 servers supporting Microsoft SQL Server and  Analysis Services.

 In all cases the operating systems is 2008 R2 enterprise.

The systems are all modern 64 bit with 64GB to 256GB of main memory.

Servers have dual “teamed” 1 Gb/s network connections.

We implement the concept of a staging server and a live server.

On the staging server  the MSAS cube is regularly updated from the local SQL Server DB. The live cube server is then synchronized from the staging cube. Users only go against the live cube.


Cube access to another user from same server

if i am trying to assign  the cube access to someone The following system error has been occured:
the trust relationship between the primary domain and the trusted domail failed.(Microsoft.AnalysisServices)

How can deploy a cube from production server to local server?



How can deploy a cube from production server to local server?

I tried to do it from BIDS, I have opened production server database from BIDS but nothing happened when I click project file.

I couldnt change default deployment

Also I have tried Wizard but couldnt find product server asdatabase

Any help will be appreciated



is it possible to process the cube using vb.net/c# which exists in the remote server?




can we process the cube exists in the remote system, using vb.net/c#


i am able to process in the same system, where analysis service available.


i couln't process this from the client system.


is there any soluctions?



WCF Problem from phone to deployed server

You cannot vote on your own post

I have a near-complete Silverlight RIA app and I am adding some features to it on the phone. What I have done so far:

1. Exposed the AuthenticationService and RIA Domain services via WCF
2. Added Service References for the Domain Services (making sure to change the Collection type of the Service Settings to Generic.List and uncheck Reuse types in referenced assemblies)
3. Updated the ServiceReferences.ClientConfig so that EnableHttpCookieContainer=true for each of the bindings and applied the cookie and saved off the authentication cookie for subsequent domain calls

The Authentication and other services are working now against the development machine. Now I want to run the phone app against the deployed server.

I deployed the Web server to my deployed machine and updated ServiceReferences.ClientConfig with the deployed server address for each EndPoint. When that failed I deleted the ServiceReferences and rebuilt them pointing to the host. No matter what I do I get an ArgumentNullException in QueryResultOfUser EndLogin and the login request never leaves the (emulated) device (according to Fiddler).

I wrote a little test WCF app

SSAS Configurations for SQL Server Database and Cube on one Server


Currently, my system has SQL Server 2008 and SSAS on one server,

and when querying is active, SSAS shows memory problems.

From the web, I found this document,

SQL Server Databases and cubes on one Server


and as the document suggests, I'd like to change memory related setting for SSAS.

But the document is based on 2005 version.

Any suggested parameter values for 2008 ?

Reports are deployed to Windows server 2008 and not running


Reports are deployed to Windows server 2008 and not running

Our reports were design in VS2005 and Reporting Services 2005 and deployed to Windows Server 2003 with SQL Server 2005. Our web application is running on Windows Server 2003 and using ReportViewer to show the data in the web.

Now we have upgraded both our Web server with IIS7 and IIS6 compatibility and database server to Windows server 2008 and installed SQL Server 2008 and Reporting Services 2008. We deployed our reports directly to this new server. When we run reports in the report manager in Reporting Services 2008 there is no problem we are able to run report but application could not run it, it times out. We are wondering if anybody had te same experience, is report viewer in VS2005 able to pull data from Reporting Services 2008? Is there any setup we need to do in web server or database server?


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.
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