Accesing offline cubes with MS Excel 2003

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Help with query I'm not sure if this is the right forum but here goes: I want to make a query that selects data from multiple tables and joins it all together. I have that but what i want to do is only select the data I need. at the moment it is returning columns that are not necessary. I'm trying to do something like this: Code Snippet SELECT sysdba.OPPORTUNITY.OPPORTUNITYID AS OPPID FROM sysdba.OPPORTUNITY INNER JOIN sysdba.C_OPPTYINFO ON sysdba.OPPORTUNITY.OPPORTUNITYID = sysdba.C_OPPTYINFO.OPPORTUNITYID For some reason the Inner Join is not joining the two tables. Any one have any suggestions Thanks in advance for the help. Tag: Accesing offline cubes with MS Excel 2003
  - 2
    - Can't install sql server 2005 Did anybody get a solution on this. I am facing the same problem. I tried to open using windows explorer and it first throws javascript error and then it shows the Splash Screen on selecting install server components it throws a message saying. "Please go to Control panel to install and configure system components." Any help is appreciated. Tag: Accesing offline cubes with MS Excel 2003
  - 3
    - ReportServicesConfigUI.WMIProvider.WMIProviderException: System.Runtime.InteropServices.COMException (0x8000000A) Hi there... I did install the Sp2 to, but that didn't quite resolve everything. Know it's working fine... i had a great help in http://www.learnreportingservices.com/ It's a great place, with videos teaching us how to solve a lot of problems... Thanks Best regards Rui Tag: Accesing offline cubes with MS Excel 2003
  - 4
    - Creating a Sum for the Year Looks like you're missing the [Date] column name before the BETWEEN keyword in that second excerpt. Tag: Accesing offline cubes with MS Excel 2003
  - 5
    - New User - Unable to connect I'm getting the same problem trying to connect from my local machine - is this the right solution for me I can actually connect from code ... the following connection string works ... SSLCon = new SqlConnection ( @"Server=(local)\SSLMJ;Integrated Security = True;" + "Database=SSLTESTRESULTS" ); I can drop a sqldatasource onto my page and try to configure it - nothing in the server list ! So - my code can connect but VS can't. What am I missing Tag: Accesing offline cubes with MS Excel 2003
  - 6
    - problem deploying SSIS to another server. Hello, I am trying to deploy a SSIS package (using deployment utility create at build time) to a different server and ran into problem wonder if someone and direct me to the right path. development environment: WIN XP, SQL 2005. package is built using server buisiness intelligence. Package content: connect to a "target"SQL2005server using OLE DB using SQL Login authentication to process data. The SQL 2005 DB is on a Win 2003 server (R2) as OS platform. The package was built, install ( SQL not file system)and ran fine on the development environement; when attempt to deploy the package to the SQL 2005 server where data reside and should be processed (also install to SQL), I receive error " 0x80004005 ...description TCP Provider: No connection could be made because the target machine activily refuse it". which is an odd error since the package is on the server that it try to connect to the data base on it. If anyone can give me some hint at what cause this problem, appreciate the help. Tag: Accesing offline cubes with MS Excel 2003
  - 7
    - Check remotely if Reporting Services exist You can check using http://servername/reportserver or http://servername/reports Tag: Accesing offline cubes with MS Excel 2003
  - 8
    - File Move Component Error From what I've worked on, I've haven't had any issues with the source and destination files being named the same. There is an option to overwrite the destination file in your File Transfer component so that usually overcomes this issue. If you set this Overwrite option to True, it should solve this. Tag: Accesing offline cubes with MS Excel 2003
  - 9
    - Error deploying large Report Model Hi, I also want to know the location of web.confing if i am doing right!! on my system i have web.config and web.config.comment. and there is only MaxRequestLenght in .comment file and i updated that to 102400!! also the execution time out to 1200: the location is: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 Thanks Tag: Accesing offline cubes with MS Excel 2003
  - 10
    - Barcode doesn't print from reports server I do have the data printing in 3 columns but only if I export it to PDF first. The preview only shows one column. My alignment is off vertically. It starts out fine but after the 3rd row its off. Thanks for any help! Tag: Accesing offline cubes with MS Excel 2003
  - 11
    - Copy cube from a DB to another one I am using SSAS 2005. Can you tell me more about the "synchronize" feature. Also, is there a way using xmla scripts Cheers, Juan Tag: Accesing offline cubes with MS Excel 2003
  - 12
    - How to change the instance name? Hello DBA's I have installed SQL Server 2005 on a machine with named instance, but later I noticed that I created it with the wrong name than desired. Now I need to change the instace name of the SQL Server that I have installed. How can I do that Thanks Satya Tag: Accesing offline cubes with MS Excel 2003
  - 13
    - Database size allocation - where other than tables, logs, etc ???? I have a Db that is 1.7 gigs. The table data takes approximately 200megs. The transaction logs were truncated. Where else can this large size be coming from and how can I confirm DB is generally small. ~25 tables, 100 SPs, 10 views, etc. Note: I have 4 queues using SQL Notifications, but when selecting from them results in no data. Thanks Scott Tag: Accesing offline cubes with MS Excel 2003
  - 14
    - SSAS 2005 Connection SSAS only uses windows authentication, there is no such thing as "SQL Server Analysis Services authentication". It does not use SQL server logins, they only relate to the relational engine, not to SSAS. Your windows account needs to be in a database role that has access to the OLAP database. If you cannot connect from SSMS, there is no way your .net application will be able to connect This article is a good one for troubleshooting connection issues http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx Tag: Accesing offline cubes with MS Excel 2003
  - 15
    - How to run DTS package/upgrade in SQL 2005. Thank you for quick response. When Open or Import package by right clicking on "DTS 2000 Packages" folder, it throws "Could not load or assembly Microsoft.SqlServer.Dts80,......." error. I have installed June CTP. I tried installing on another computer, I get same error. Thx, Satish Patil Tag: Accesing offline cubes with MS Excel 2003
  - 16
    - TSQL Challenge Views do not allow the "DECLARE" keyword. When the amendment is effective the data from the amendments table will be selected instead of the contract data . Amendments table preserve the historical changes of the Contract. It should have 2 outputs, 1 view and 1 stored procedure. View: Current_Contracts - This is the list of contracts on its current state(with effective amendment). Stored Proc.: GetContractByDate(Date) - This is the current contract on the time of the given date. Tag: Accesing offline cubes with MS Excel 2003
- Next
  - 1
    - Disaster Recovery - How to verify my 2005 standard databases using 2005 express Do a live.com search on "SQL Server Orphaned Accounts". Tag: Accesing offline cubes with MS Excel 2003
  - 2
    - How can we create cubs in sql server 2005 BI The link is correct. Data source views are a feature only in Analysis Services 2005. Here is the link to all articles about Analysis Services. http://www.databasejournal.com/features/article.php/3593466 Look for the writer William E. Pearson Here is the link to Books On Line Analysis Services 2005 tutorials: http://msdn2.microsoft.com/en-us/library/ms170208.aspx Regards Thomas Ivarsson Tag: Accesing offline cubes with MS Excel 2003
  - 3
    - Can't Get SQL Authentication to work With XP Pro SP2 in very simple test case I think there was something in the decision tree that I missed... As I am gradually putting this together, it looks like the first choice is "1 server => windows authentication" vs "multiple servers (plus some other cases) => sql authentication" After that, everything that is written about sql authentication seems to assume a level of professional expertise which is appropriately associated with a multi-server environment. Which probably means that the developers may have XP on their desks, but that they're logging into an W2003 development environment...so they never get exposed to this problem (or are aware of it and bypass it). If you miss the first branch in the decision tree, this is never mentioned...it's all about encrypting web.config and guarding against sql injection by limiting table access, clever ways to use trusted this and that....but never "maybe you should just use Windows Authentication, if it's a single server app." Long way to the first u-turn....hazards of being a newbit! Tag: Accesing offline cubes with MS Excel 2003
  - 4
    - Using Array Variable in ForEach Loop Container Hery Susanto WR wrote: Thanks Ravi, it helped me so much, now I know what the "Traverse subfolders" is for :) Is to get to the subfolders; in your case that is required as SSIS needs to go all branch_nm subfolders. Hery Susanto WR wrote: One more question Ravi, when I put the value into variable, can I get that value inside Script Component my plan is establish the flat file connection inside Script Component and get the data row by row using Synchronous method and push it into database. Is that a problem You could; but the dataflow has already all that functionality built-in. Inside of the ForEach loop container, place a dataflow. Then in the dataflow, use a flat file source component and the required destination component. The trick is to use an expression in I have an example that shows how to do it for excel files. See an example here: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx Tag: Accesing offline cubes with MS Excel 2003
  - 5
    - Database corrupt on power loss Ilya, I disabled the cache write for the drive. I will restart test and hopefuly this is the solution. Thanks again! Tag: Accesing offline cubes with MS Excel 2003
  - 6
    - tfs installation issue !!!!!!!!1 i had SP1 of visual studio and TFS installed on my server but it didnt work and i had a server failure, so i removed the SP1 after doing this i had this error: " Team Foundation Server does not exist or is not accessible at this time. Technical information (for administrator): HTTP code 503: TF30059: Fatal error while initializing web service " after searching on line i found that there is problem in version number of Microsoft.TeamFoundation.VersionControl.Server.dll file so i changed it to be compatible with TFS version number. by dowing this the following erro appeared " Please contact your administrator. There was an error contacting the server. Technical information (for administrator): HTTP code 500: Internal Server Error " after that i removed the TFS and tried to reinstall it on the same server, here i had the following error: "Error 28922.TFServerStatusValidator: ErrorConnectingToDatabaseWhenImpersonated - Most likely the service account doesn't have permission to access TFS database (because the tool succeeded connecting to the TFS database as the current user - user running setup)" and here im totaly stuck , coz the user of services can connect to sql server , i used the sevice account to connect to sql server and connection was established successfully. Tag: Accesing offline cubes with MS Excel 2003
  - 7
    - Connection Error from ASP.Net under IIS: provider: Named Pipes Provider, error: 40 Does your connection string like "servername\instancename" or something else The TCP failure indicates either the server TCP listener is not up or client uses different TCP port to connect. So please check whether the TCP is enabled or not. Restart the server after the configuration change. Then check if the connection string has instancename specified. Once you find out which port the server is listening on, you can also use "tcp ervername,port" to connection to the server. Tag: Accesing offline cubes with MS Excel 2003
  - 8
    - Cant restore the database backup in SQL server 2005? Hi, System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 83679641600 additional free bytes, while only 46151348224 bytes are available. (Microsoft.SqlServer.Smo) Thanks, S.Shyam. Tag: Accesing offline cubes with MS Excel 2003
  - 9
    - How to move Full Text Catalog SQL 2005??? You can find the answer here: http://msdn2.microsoft.com/en-us/library/ms345483.aspx Just scroll down to the section regarding "Moving Full-Text Catalogs" Good luck! Tag: Accesing offline cubes with MS Excel 2003
  - 10
    - How to programmatically set column mappings of a simple data flow task? Donny Ma wrote: Thanks, Jamie, that helped a lot. I have a further question, though. I want to make a script task that will programmatically set the mappings in the subsequent data flow task. Can't be done. Period. Read more from the father of SSIS, Kirk Haselden: Self Modifying Packages in SSIS ( http://sqljunkies.com/WebLog/knight_reign/comments/17731.aspx ) -Jamie Tag: Accesing offline cubes with MS Excel 2003
  - 11
    - suggestions sureshv wrote: yep i did try data flow task.And in dataflow i used conditional split,lookups etc...but do they transform data using set based or row based..how do i transform data set based Maybe its just me being stupid but I still don't understand. What do you mean you want to transform data "set-based" Can you give an example -Jamie Tag: Accesing offline cubes with MS Excel 2003
  - 12
    - Cannot get SSCE 3.5 beta 2 to work This DLL is not a COM object or .NET assembly so it can't be added as reference and it should not be. It should be simply located in your %WINDIR%\System32 or in your application folder. Also make sure to mark your application as x86 (platform target in project properties or you won't be able to use SQL CE in 64 bit OS. Tag: Accesing offline cubes with MS Excel 2003
  - 13
    - Database Mail Command Not Supported - Again Have you tried sending mails from outlook or any vbs script to send the mail using the exchange server Can you able to ping the exchange server Tag: Accesing offline cubes with MS Excel 2003
  - 14
    - Generate a cube in Standard Edition I do not know if there is a difference in programatically creating a cube between Standard and Enterprise, but look here: http://technet.microsoft.com/en-us/library/ms345091.aspx Tag: Accesing offline cubes with MS Excel 2003
  - 15
    - SQL Server 2000 - Generating new field containing the sum of other rows I can't answer that question without knowing the structure of your table, the data in your table and exactly what operation you are trying to perform. This code will createa running total for any column. I created a small table and inserted data so you could run the same code on your computer and uncerstand the concept. Tag: Accesing offline cubes with MS Excel 2003
  - 16
    - Checking Job Status using T-SQL by the way.... What is meant by JOB STATUS Tag: Accesing offline cubes with MS Excel 2003

MatoK

Hi,

I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source".

I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures.

I have MS Excel 2003 (11.8146.6568) SP2, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft Core XML Services (MSXML) 6.0 instaled.

Thanks for help,

Martin

Top

Re: Accesing offline cubes with MS Excel 2003

Thomas Ivarsson

Hello! This is only from what I have read.

To create local cubes you can write XMLA commands in Management Studio or write code by using the SSAS2005 object model called AMO.

I do not think that these two possibilities are part of Excel 2003.

HTH

Thomas Ivarsson

Top