.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

I can't configure SSAS for PPS

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
I don't know how to connect to SSAS in PPS. And I was trying to run Analysis Services Deployment Wizard, but I don't understand what database file I must choose

View Complete Post

More Related Resource Links

How to configure IIS 7.0 for ASP.NET Web Pages Razor


I'm working on a blog framework using ASP.NET Web Pages with Razor Syntax and I'm having some trouble with URL rewrites. My server is a Windows Server 2008, which runs IIS 7.0. WebMatrix is already installed on the server and .cshtml pages runs without problems, as long as they are named "index.cshtml" I don't have to supply the extension.

What does not work, is when I have URLs that does not correspond to physical files, e.g. website/post/why where the only physical file I have is post.cshtml. With IIS Express, the post.cshtml file is execute but on IIS 7.0 I get a 404 error.

Should I install the URL Rewrite for IIS 7.0? What configuration changes is required?

Configure Datasource using gridview problem


Hi i  have one asp.net textbox control..

and one dropdownlist inside gridview itemtemplate textbox..

what my problem..?

A Textbox36 has values some thing like this A1','A2','A3

i wirte this below query in sqldatasource1 and this sqldarasource1 is binded to gridview ItemTemplate Dropdownlist..

Select ItemName from Table1 where code in (@C)

Here @C im refering to Textbox36..

It show me the record if it has one value if its multiple like A1','A2','A3 it not showing/filtering ItemName data..

Whatz the probel?

Configuring website to ASP.NET 2.0 failed. You may need to manually configure this site for ASP.NET


I am trying to create a new website project in Visual Studio 2005, the website is an IIS website (ie. http://localhost/website1) and i get the following error message;

Configuring website to ASP.NET 2.0 failed. You may need to manually configure this site for ASP.NET 2.0 in order for your site to run correctly.

then when i try to debug the project i get the following error;

Unable to start debugging on the web server. The server does not support debugging of ASP.net or ATL server applications.

I am running Windows XP professional, with .NET 2.0 installed, and IIS V5.1

How can i get a simple website to debug on my machine?

Configure This: Parameterize Your Apps Using XML Configuration In The .NET Framework 2.0


There are a number of ways to configure an application in the .NET Framework 2.0. This article explores the classes of the revamped System.Configuration namespace and explains how to use XML configuration files for your app configuration settings.

Bryan Porter

MSDN Magazine June 2006

Configure a module through IIS Manager?


I've developed a custom module with a custom configuration section.  Is there a way to create a plug-in or module so IIS Manager can manage the module?  I'm looking for the ability to enable or disable it by site as well as setup various configuration properties.

Configure My Site for Microsoft Office Pop up

I saw this on another post, but it still doesn't seem to have been resolved.

How do you disable this pop-up that reads

"Microsoft Office can remember your My Site to synchronize documents stored here in Outlook and to show it when opening and saving files. Do you want Office to remember this site (http://xxx/)? Only select 'yes' if you trust this site."

It stops appearing on certain pages, but for example this appears every time you click 'Add Colleagues' link in Colleagues.

Any help?

Cannot locate Tsneu.xml to Configure SharePoint Treasure (Synonym) In MOSS 2007


Hi all,

I wanna follow this article -> http://www.codeproject.com/Articles/36203/How-to-Configure-SharePoint-Treasure-Synonym-In-MO.aspx?msg=3038555 

to figure SharePoint Treasure (Synonym) In MOSS 2007.


I created the SSP for searching file, and my SSP guid is 7xxxxxx-xx etc., but in my MOSS 2007 server,  

I have this folder -> "Drive:\Program Files\Microsoft Office Servers\12.0\Data",

but no I haven't "Drive:\Program Files\Microsoft Office Servers\12.0\Data\Applications\" folder, so I cannot locate Tsneu.xml as above article.


I can find "tsneu.xml" file in following 4 folders, I don't know which file I should modify... 


Kerberos between MOSS 2007 and SSAS 2005


I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.

We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail.  We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work.  We've used other materials we have on kerberos here.  But the end result is that the double hop is not happening.  We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services).  In every case the connection is not happening.

Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message).  Excel services works fine if I use the unattended service account, but when I switch the odc file to windows (should cause kerberos to kick in) it fails.  When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.

In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer.  I have no problems connecting to the cube directly through excel, so the security at that end passes t

Configure BDC column to have multiple values selected


How do I Configure BDC column to have multiple values selected and make multiple entities data available in the same column.  Currently it supports only single value for an item.  This requirement is crucial need some solution immediately.

SSAS logistic regression vs. vanilla logistic regression

I recently ran the same data set through the SSAS logistic regression (Neural network - Hidden layer disabled) as well as a vanilla logistic regression procedure. I am aware that different processes are followed in order to obtain the resulting co-efficients, however, has anyone got further information as to how close the results of the SSAS logistic regression equation are in comparison to logistic regression equations contained in other statistical packages such as SAS or SPSS? I do understand that the respective procedures are dependant on the quality of the data that they are applied to. I assume that the SSAS logistic regression may perform more favourably on one dataset in comparison to a vanilla logistic regression and vice versa. I am aware of the following post however it does not go into much detail concerning the results of the comparison. http://social.msdn.microsoft.com/Forums/en/sqldatamining/thread/4f381c6b-2471-4d4c-a022-316a1073184d Further info would certainly be appreciated.

how ssas generate sql queries when processing dimensions and partitions?

hi all, how does ssas2008 generate sql queries to read data from the source, where processing dimensions and partitions? is there any reading meterial that clearly explains how the sql queries are constructed according to properties of dsv, dimensions and measures and partitions.   thanks in advance.Andrew Chen Interested in BI related technologies

how to move SSAS applications between windows servers

Hi All, We have separate windows servers hosting production and development environments.  Each environment consists of MS SQL Server and SSAS, studios, etc.  What would be the best way to move MS SQL Server databases and SSAS objects from one server to another?  I have been looking for some import/export applications but have not been able to find anything. Thanks for any help, Thanks, Roscoe

Java Hibernate and OLAP(SSAS)

I am trying to create hibernate connection using olap4j driver I am getting this error- java.lang.IllegalAccessException: Class org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection can not access a member of class org.olap4j.driver.xmla.XmlaOlap4jDriver with modifiers "protected"     at sun.reflect.Reflection.ensureMemberAccess(Reflection.java:65)     at java.lang.Class.newInstance0(Class.java:349)     at java.lang.Class.newInstance(Class.java:308)     at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:205)     at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)     at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)     at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72)     at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:53)     at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)     at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(Connectio


I want to develop one report for that I connected cube from the Excel, my requirement is I want to show data BSM wise, ASM wise, FO wise, Distributor wise, Sales man wise nothing but it is salesman hierarchy. monthly retailing Quantity and retailing value. April 10, may10,june 10 and July10 for the following products No1 90 g all variants,Nupur,Expert,Haircolour,Cinthol How to achieve this plz give suggestion it is an urgent requirement    

DR Setup for SSAS 2008

Hello Guru's, I'm new to SSAS env. and want to set up its DR env. Can anybody guide me with any good strategis and implementation practices. We are using SSAS 2008 on 2 node Cluster Server. Thank you in Advance.- Nilesh

Query Performance & Overall Design - SSAS MDX WCF

Hi All, We have a Cube which is to be queried by the Online system , using WCF service. Peroformance of the queries running on the Cube is not really very good , as we have to calculate various percentile (which are all calculated members) on the cube, this howver works well within limits of 5-6 secs for small sample size. But this goes beyond the threshold of 30 secs when the record counts increases. What we have is our SSAS Cubes , and we have WCF Service querying the Cube using ADOMD.NET. This may not be one of the best way to achieve this requirement , but we are kind of completed with development and it may not be feasible to work on another approach, what we are looking for is optimize this design and make it work with in expected time limits of 5-8 secs. Kindly let me know, if i am not clear or if you need any more info to suggest something ! Thanks a lot for your help !   Kindly

Determining the status os the Batch job that process SSAS Cubes

Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701
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