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


Post New Web Links

"PivotTable.DisplayEmptyRows = false " in Excel pulling from Analysis Server 2008, doesn't work.

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

We display financial information, using Excel pulling from Analysis Server 2008.

 

In vba,  "ptTemp.DisplayEmptyRow = false" works fine for hiding empty rows of data on most pivot tables, but if the "account numbers" parent/child dimension is in the row fields, it doesn't.

 

The row Dimension look like this:

 

Balance Sheet

Assets

Current Assets

Cash

Total Balance Sheet

 

Income Statement

Gross Profit

Revenue

Item A

….

Total Income Statement


View Complete Post


More Related Resource Links

64 bit Windows 7 + Excel 2010 beta + SQL Server 2008 Enterprise SP1 = My DM Add-in does not work

  
I'm running W7 + Excel 2010 beta + SQL Server 2008 Enterprise on a full 64-bit PC.  My SQL Server 2008 DM Add-in installs properly (throws no errors), but neither the Data Mining nor Table Analyzer tabs show up on the Excel ribbon & are not available in the Add-in dialog box.  I also have all of the above on a 32-bit laptop, and both DM tabs ARE available on the Excel ribbon and seem to function properly.

As a test I uninstalled the add-in from both machines and reinstalled.  The issue was the same; the add-in shows up on Excel running in the 32-bit environment but not on the 64-bit environment. 

Question:  Is this problem due to the 64-bit environment, or could it be something else?

AsyncPostBackTrigger doesn't work on server..

  

Hi, 
 I am new to asp.net and ajax. I have a problem while using update panel.
I have a tabcontainer with 3-4 tab panels. Inside one tab panel there is a cancel button. What i want to do is to when i hit cancel button in code behind i change active tab index to 0 so that tabcontainer shows first tab panel. I have update panel around tab container. This works at my localhost. But on server its behavior is very random. Sometimes it works sometime it doesn't. Unfortunately I am not able to debug it also. I don't know how to debug code on server. As on localhost it works correctly so I am kind of stuck. 

Will the old Excel 2007 Datamining Solution Work With SQL 2008 Express?

  
Or does it need the full version?  Is there a new version of the Datamining add-in for 2008 Thanks Peter

Import Excel data into SQL Server express 2008

  
I have recently installed SQL express 08 and created a table to import excel data into.  Im running on a windows 7 64 bit OS i5 processor.  I've disabled the firewall (temporarily) and will set the necessary ports once this is working. I run the following query:  (which i found from multiple sources on the net) Select   * From OPENROWSET ( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\Public\lenovoBkup\contacts\outlookFiles\noib2a.xls', 'Select * From [sheet1$]' )  and receive the following message: Msg 7308, Level 16, State 1, Line 1                                                                                  OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.  (how did they know i was single and living in an apartment? lol) so after research of the following message i restarted the system and relaunched man

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

SQL Server 2005 Analysis Services - Performance of Excel Pivot Tables

  
Hi, I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk. The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has only one processor (there are 8...) at 100%... Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes... Thanks in advance Hugo

Is it possible to access an Analysis Server with Excel via http?

  
Hi, in our scenario we want to give another company access to out analysis server via web, their front end should be Excel. So first of all I made a setup like descriped here http://technet.microsoft.com/de-de/library/cc917711(en-us).aspx (but I have really no idea how to test it in an easy way because using MDX sample application ends up every time in "The connection either timed out or was lost.") But apart of that, is it possible to access an analysis server with Excel via http? I did not found any possibility to use a http-adresse in Excel as server path. Any ideas? Thanks and regards Peter  

XML for Analysis Parser; The restriction value - sql server 2005 with Excel 2010 error

  

Trying to refresh an existing pivot table that is connected to Analysis Services Sql Server 2005 database.  My excel 2010  gets the eroor:\

XML for Analysis parser:  The restriction value provided by the consumer either does not match other restrictions or refers to an unknown object.

I already tried the pivot table patch and I am still experiencing the error.  I also tried starting a new excel spreadshsst and connecting to two other sql servers of newer verions and was succesful.


New SQL server 2008 connectioin will not work using hostname

  

We are trying to create an ODBC connection from a terminal server running server 2008 to a SQL server 2008 (also on a server 2008). When creating the connection from a server 2003 terminal server the connection is successful and i am able to gain access to my databases. However, when trying to create the same connection from the server 2008 terminal server we get an error that the server does not exist or access is denied. We have gotten the connection to work on the server 2008 terminal server but only if we use the FQDN or the IP address. We need to be able to use the hostname to make the connection easier for users who are making connections to the SQL server using access or excel.  WE have exhausted our efforts to correct this problem. We have checked DNS records and created a service principal name (SPN) in active directory. Thank you in advance for your help in resolving this issue.


Report Model based on Analysis Services Cube doesn't work

  

Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)

Daniel

SQL Server 2008 & BIDS 2008 (Version 9.0.3x)


Unable to connect Excel 2003 from linked server in sql 2008 64 bit

  
Hi ALL,

I was unable to connect to excel 2003 with linked server created in sql server 2008 64 bit. This was working fine with sql server 2005 32 bit.

I know that there no 64 bit drivers for JET drivers, but i am looking for some alternative ways to do the same job.

I dont want to migrate to Excel 2007.

Thanks in advance for all your help.

Thanks,
Loknath

Microsoft Excel Application in DCOMCNFG in Windows Server 2008

  
Microsoft Excel Application in DCOMCNFG in Windows Server 2008 is not found. This is presnt in windows server 2003. But how to configure this in Windows Server 2008.

Kindly help me as soon as possible.

Inserting and updating 2 tables in sql server 2008 from 2 worksheets in Excel

  

hi all,

        I have an excel sheet with 2 tabs and has data in those 2 sheets(sheet1, sheet2) which correspond to different tables in the same database. This excel sheet gets updated daily, I am wiriting a console app( which will later be a batch build). I have to  insert the data from the excel sheet to corresponding tables (table1, table2,table3) in database when i run it and and also if the table has the same data already present it should ignore and if there are any modifications done the data it should update the table. I know we can do this using ado.net or LINQ, I am a little new to database based programming ..so any help is more appreciated. I have already tried googling but colud not find the perfect solution.


SQL Server 2008 R2 \ Analysis Services Purchasing

  
If a person wants to experience with Analysis Services (not as a trial) for his personal use, does it mean that the cheapest way is to purchase a "SQL Server Standard" license for $898?

http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

Another option is ($2,607.55):

http://store.microsoft.com/microsoft/SQL-Server-2008-R2-Standard-Edition-32-bit-10-Client-Access-Licenses-/product/99B2882D

Is there a way to get a cheaper version of Analysis Services + SQL Server (maybe along with free versions such as "SQL Server Compact" and "SQL Server Express")?

Thanks!

Getting SSRS 2005 to work on Server 2008 R2

  

I reinstalled SQL Server 2005 x64 Standard Edition SP3 on a Server 2008 R2 box and installed IIS and SSRS as well.  SQL runs fine. SSRS is installed all configs look good, but I cannot get it accessible via the browser (//localhost/ReportServeror //localhost/Reports). 

I have tried both 32 & 64 defaults in IIS AppPools and each gives me an error and I can't find any other resources as to what the problem is?

32-bit setting is giving me this error on /ReportServer:

Could not load file or assembly 'ReportingServicesNativeClient, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

64-bit setting is giving me this error on /ReportServer:

HTTP Error 500.0 - Internal Server Error, Error Code 0x800700c1

32 & 64-bit setting are both giving me this error on /Reports:

HTTP Error 401.2 - Unauthorized, Error Code0x80070005



SQL Server 2000 Analysis Services & Excel 2003 Add-in

  
I've been working with SQL Server 2000 AS cubes and presenting them in pivot-tables in Excel 2003 with no problems.

I was recently looking at other BI tools I could use and stumbled across the Excel Add-In for Analysis Services, which adds a Cube Analysis menu to Excel and seems to have lots of functionality I could use.

But! It's no longer supported by Microsoft.

I managed to get a download of it from www.download.com and searched for help and I have some good documents to help me understand how to use it, but my problem is that it just doesn't work! I've uninstalled and reinstalled and rebooted, but to no avail.

I can connect to my data source and cube and I can view the dimensions and measures, but when I click apply on them and select the area of the report to put them into, they just don't appear. I can briefly see an EMBED command appear in the formula bar and then disappear, but nothing happens!

I've been through all the trouble-shooting and checked the settings of Excel as requested, but nothing works. 

Has anyone else had this problem or have any suggestions as to how to fix it?

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