.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

What are layers in Analysis Service?

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
what is Layer and How many Layer in Analysis Services and what is each usage ? Thanks in advance

View Complete Post

More Related Resource Links

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

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

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

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

is it possible to get customer level analysis from service level fact table?


I have a service fact table

select 1 as serviceid,1 as [week],1 as gain,0 as loss,1 as onsupply UNION
select 1, 2, 0, 0, 1 UNION
select 2, 2, 1, 0, 1 UNION
select 3, 2, 1, 0, 1 UNION
select 1, 3, 0, 1, 1 UNION
select 2, 3, 0, 0, 1 UNION
select 3, 3, 0, 0, 1 UNION
select 2, 4, 0, 1, 1 UNION
select 3, 4, 0, 0, 1

each service has a related customer

select 1 as supplyid , 1 as customerid UNION
select 2,1 UNION
select 3,2


I have created a cube which allows me to product the following services analysis as an output (a service is on supply for a week it was live at any point during the week)

select 1 as week, 1 as gain, 0 as loss, 1 as supply UNION
select 2, 2, 0, 3 UNION
select 3, 0, 1, 3 UNION
select 4, 0, 1, 2 UNION
select 5, 0, 0, 1


However I would like to do a similar thing at customer level to get the following out put

select 1 as week, 1 as gain, 0 as loss, 1 as onsupply UNION
select 2, 0, 0, 1 UNION
select 3, 0, 0, 2 UNION
select 4, 0, 1, 2 UNION
select 5, 0, 0, 1

A customer is gained if a supply is created for a new customer (doesnt have any existing services). A customer is lossed if a service is a loss and the customer has no other active services. A customer is 'on supply' if he has a service active at any point in the reporting week.

Is it possible

Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.

WCF Tip: Using Properties in Service Contracts

you'll notice all of the Service Contracts are implemented with interfaces containing only methods. For the longest time I thought that's all that was supported, until I thought about it a little more. In C# land, properties are simply wrappers around a get method and set method, so why wouldn't we be able to use properties in a service contract? Well the answer is we can.

Realizing a Service-Oriented Architecture with .NET

This article is meant to be a practical discussion guide to building a .NET application in a service-oriented architecture. We will consider real-world goals, real-world obstacles, and experience-based solutions. I quickly concede the approaches discussed here are not exhaustive or infallible. This paper is focused on application development, not application integration. We will specifically consider architectural issues and component design issues.

The Potential of Web Services

Web Service for uploading documents into SharePoint

WS UploadService is a web service written for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 and is meant for uploading documents into SharePoint. I have just uploaded the zip file to GotDotNet.com so it will take some time before the zip file appears in the list of downloads. For the time being, you can download the zip file from the following location
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