.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

Connecting PPS to Service Analysis Cubes

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

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?

View Complete Post

More Related Resource Links

Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Learn how to create a BCS external content type for Office 2010 based on a Windows Communication Foundation (WCF) service.

Video: Connecting to a WCF Service Using Business Connectivity Services in Office 2010

Watch this video as you learn to create a BCS external content type for Office 2010 based on a Windows Communication Foundation (WCF) service.

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

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

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.

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

What are layers in Analysis Service?

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

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


Problems with connecting to a WCF Service


I'm going through the learning curve with WPF in VS2010 (.NET 4.0) at the moment. I created a simple WPF Forms project and put a reference to an exisiting WCF service. Everything worked fine. I then created a WPF Browser project and put a reference to the same WCF service in it. I now get this:

Request for the permission of type 'System.Net.WebPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
The service is normally used in an ASP 4.0 web site with no problem. What do I need to configure to avoid this problem in the WPF browser project?

Exporting analysis service project


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

Do i need to set special settings?

Deplying SQL Analysis service database using script problem with Impersonation


I have a problem with deploying SQL Analysis database from dev server to production , because I do not have an admin privileges , I cannot use Create script

The only action that I have , is to execute Alter Script against Any Empty database,


However I cannot use ImpersonateServiceAccount because it needs  Admin privileges

So, I always use ImpersonateCurrentUser as you know, I have to supply my credential.


are there any way that I can Deploy the db to the production  with the same impersonation type ImpersonateServiceAccount

as it was before?


thank you

Error connecting to Web Service in C#


I am trying to access a web service and calling a method to pass my request parameters. I am programmatically setting my credentials, using:

service.Credentials = 
new NetworkCredential("username", "password", "domain_url");

When in the above code, I pass domain_url, I get this Web Exception in dialogue box while debugging.

Unable to automatically step into the server. Connecting to the server machine "ServerUrl" failed. Invalid access to memory location.

In the message property of the web exception I get "The request failed with HTTP status 401: Unauthorized."

And when I do not pass domain_url, that is,

service.Credentials = new NetworkCredential("username", "password");

It does not

analysis service shutting down


I have SSAS 2008 R2 installed on window 2003 .. and it oftens shutdown  with .NET runtime error.. any idea what is happening and how can I fix this?

there are no detailed error log.. just says fatal error occurs .. .net runtime..../.

Error while creating Analysis services cubes


I am getting the error "The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later" when i try to trigger Cube builder job. The datasource to which i am connecting is Netezza Database.

Jothi S

Give a limit for Memory Analysis service


Dear All,

example : my server'spesification is like this.. : Windows server 2008 R2 data center 64 bit with memory 8 giga.

and then i want to give a limit of memory that used for sql analysis service until 6 giga.. is that possible ??



Aditya Christian.

does analysis service recycle cache/memory?


hi all,

i executed an MDX query  which i executed yesterday,it still took me such a long time that i guess it did NOT benefit from yesterday's execution. while i executed it again, the result returned almost immediately, as expected.

so i wonder whether AS2008 performs regular recycling?

anyone gets a certain answer?


Andrew Chen
BI, Data Mining, Analytical CRM
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