View Complete Post
We display financial information, using Excel pulling from Analysis Server 2008.
"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:
Total Balance Sheet
Total Income Statement
I installed Sql Server 2008 Express and there is not a Solution Explorer. I go to Microsoft SQL Server Management Studio -> FIle -> New and my only options are (1) Query with Current Connection (2) Database Engine Query (3) SQL Server Compact Query
(4) Policy. I have tried CTL-ALT-L. VIEW does not have a Solution Explorer. And when I got to TOOLS -> Customize, there is no Solution Explorer.
What do I have to install to get Solution Explorer? Would I have to uninstall my current SQL Server or will it just overlay or co-exist?
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2009-02-28 20:08:46
End time: 2009-02-28 20:09:33
Requested action: &n
Hi all. I have a question regarding offline cubes (offline data files) in Excel 2007/2010 connecting to SSAS 2008 R2. When I try to make an offline data file in Excel
I get a OLE DB error. The server I am trying to connect to is at a hosting partner on a different (but trusted) domain but I have admin rights on it. I then took a copy of the SSAS database and moved it to my own pc and could then create offline data file.
I thought it might be a firewall issue on the server and tried turning it off, but the OLE DB error came again. I therefore think that there is something that happens over the network and is blocked by the hosting partner. I probably should tell that I am
also SSAS admin, so it is not because of lack of rights on the SSAS that I get the error.
What I like to know if there is anyone who knows this problem or knows what happens when you try to create offline data file against SSAS in Excel? Specifically what
is transferred between the client and the server, what ports and are there any programs run or code executed to create the offline cube on the client that might be blocked by typical network/domain settings/rules?
Hello All !
I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS as a
'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance. A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'
In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?
Is there a program that I can download that aids in converting an access (accdb) file to sql express 2008 R2?
Hi! I did a quick test to dump data into an Excel spreadsheet. Everything worked fine, but when I created a job to do this for me and then run it, I get this error:
DateÃÂ ÃÂ 10/8/2008 4:24:25 PMLogÃÂ ÃÂ Job History (ExportClientInfoToSpreadsheet)
Step IDÃÂ ÃÂ 1ServerÃÂ ÃÂ OHI0056Job NameÃÂ ÃÂ ExportClientInfoToSpreadsheetStep NameÃÂ ÃÂ CreateExcelClientExportDurationÃÂ ÃÂ 00:00:00Sql SeverityÃÂ ÃÂ 0Sql Message IDÃÂ ÃÂ 0Operator EmailedÃÂ ÃÂ Operator Net sentÃÂ ÃÂ Operator PagedÃÂ ÃÂ Retries AttemptedÃÂ ÃÂ 0
MessageExecuted as user: OHI0056\SYSTEM. Microsoft (R) SQL Server Execute Package UtilityÃÂ Version 10.0.1600.22 for 64-bitÃÂ Copyright (C) Microsoft Corp 1984-2005. All rights reserved.ÃÂ ÃÂ ÃÂ Option "12.0;HDR=YES;" is not valid.ÃÂ The command line parameters are invalid.ÃÂ The step failed.
Here is the script of the job. Any ideas what is going on?
/****** Object: Job [ExportClientInfoT
My problem sounds like that:
I have some cube created with SSAS 2008 and I'm using Excel 2007 as browser to view cube data.
I made pivot table with nessesary data, everything works fine till I save excel file and sent it to my client.
When client uses some filter, some row measures disapear. Dimension data are shown, measures are blank cells, but calculations from those measures is filled.
e.g. I see difference of sales between years in percent, but I can't see measures, which were used to count that difference, because in excel I see blank cells.
I am using the version of Solution Generator installed with VSeWSS 1.2. I have VSTS2008 and WSS3 installed on a Win2k3 box, which we use for development. The solution generator works perfectly on
the local instance of WSS, but if I try and make a solution a any sites hosted on a remote box, I get the 'No SharePoint site exists at the specified location' error message. Does the solution generator only work on local sites?
The account I am using is a domain admin and a farm / site collection administrator and SQL sysadmin on both boxes hosting SharePoint. I'm trying to generate solutions from a live site to put into
source control. I don't really want to install visual studio on the live server as I am only intending to use it there for this one-time generation job.