Access cube from Excel 2004 Macintosh

Hello, is possible to access a cube on analysis services 2005 from Excel 2004 for Macintosh?

how can access ?

thank's

I am not sure about the support for OLAP in Excel for Mac.

You should be able to access a cube, on a Mac, by a web browser that supports HTML 4.0 if you use Reporting Services 2005 as the report middleware. For authentication you will have to set up a windows account on the Windows 2003 server running Analysis services 2005, for each Mac-user.

Regards

Thomas Ivarsson

|||

thank you

sql

Access Class Library from Excel 97

Hi All, does anyone know if it's possible to utilise a .NET class
library from Excel 97 ? I've tried but receive a runtime error
-2146232576 which means nothing to me, my class is shown below, I've
placed the assembly into the GAC and registered it using RegAsm all to
no avail
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Runtime.InteropServices;
namespace CallingCSharpFromWord97
{
[ComVisible(true)]
public class PJKWordClass
{
public TextWriter tw = null;
public PJKWordClass()
{
}
public void WriteLogFile(string msg)
{
tw = new StreamWriter("c:\\PJKCalledFromWord97.log", true);
tw.WriteLine(String.Format("This file was created by C# which was
called from a COM client {0} at
{1}",msg,DateTime.Now.ToLongDateString()));
tw.Close();
}
}
}
I can reference the assembly in Excel, but when run, it bombs on the
CreateObject line ( with the error number shown above )
Dim oCSharp As CallingCSharpFromWord97.PJKWordClass
Set oCSharp = CreateObject("CallingCSharpFromWord97.PJKWordClass")
regardsPete Kane wrote:
> Hi All, does anyone know if it's possible to utilise a .NET class
> library from Excel 97 ? I've tried but receive a runtime error
> -2146232576 which means nothing to me, my class is shown below, I've
> placed the assembly into the GAC and registered it using RegAsm all to
> no avail
> using System;
> using System.Collections.Generic;
> using System.Text;
> using System.IO;
> using System.Runtime.InteropServices;
> namespace CallingCSharpFromWord97
> {
> [ComVisible(true)]
> public class PJKWordClass
> {
> public TextWriter tw = null;
> public PJKWordClass()
> {
> }
> public void WriteLogFile(string msg)
> {
> tw = new StreamWriter("c:\\PJKCalledFromWord97.log", true);
> tw.WriteLine(String.Format("This file was created by C# which was
> called from a COM client {0} at
> {1}",msg,DateTime.Now.ToLongDateString()));
> tw.Close();
> }
> }
> }
>
> I can reference the assembly in Excel, but when run, it bombs on the
> CreateObject line ( with the error number shown above )
> Dim oCSharp As CallingCSharpFromWord97.PJKWordClass
> Set oCSharp = CreateObject("CallingCSharpFromWord97.PJKWordClass")
> regards
>
Sorry posted to wrong group :-)sql

Access AS from Excel 2007 from outside the domain

I am trying to access an AS DB from outside the domain. I'm using the https://.../msmdpump.dll to specify the server name. Is there a way to qualify the specific AS DB in the supplied server name? Excel allows for both Windows authentication as well as providing username and password, which seems to be a mistake - it appears it uses the same dialog box in creating a connection to AS and DB, so provides the ability to pass l/p. Can I provide a valid Domain login in these fields for connecting to AS? My machine is of course in a different domain then AS - is there a way to pass the remote domains credentials from this machine?

Thanks

If the laptop conaining Excel 2007 is not on the same domain as SSAS or the msmdpump.dll web server, then I would suggest one of two options:

1. Launch Excel with the runas command:

Code Block

C:\WINDOWS\system32\runas.exe /net /user:SSASDomain\username "C:\program files\Microsoft Office\Office12\EXCEL.EXE"

Then connect with "Use Windows Authentication" in Excel.

2. If that's not an acceptable solution, then enable basic security on the msmdpump virtual directory (which is still secure because you're using HTTPS) and connect using "Use the following User Name and Password" in Excel. Note that their password will be stored in the xlsx in clear text and on disk elsewhere on their computer. And if these users can publish to Excel Services, there will be a bunch of other complexities to worry about. (If Excel Services publishing is needed for these users, I would suggest you have them submit their xlsx files to internal IT who can remove the basic security and flip the connections over to Integrated Security before publishing to Excel Services.)

If msmdpump.dll is not on the same server as SSAS, you may have troubles getting #1 to work since Kerberos delegation across domains starting with a connection in Excel isn't possible that I know of. But #2 should work.

As for specifying the database, I believe that is configured on the next screen in the connection wizard in Excel 2007. If you meant "can msmdpump.dll point to several servers?" I think the answer is no. There's a msmdpump.ini which controls which SSAS server it connects to. But you can certainly deploy multiple msmdpump.dll virtual directories.

Keep us posted with your progress or with other lessons learned if you run into some gotchas. Hope the above helps.

Access a previous cell in the matrix

Hi,

It's possible to access a previous cell in the matrix, like excel?

For example:

A

B

C

1

A1

2*(A1)

B1 + A1

Thank you,

Bruno Giminiani

Can you expalain indetail

Accesing offline cubes with MS Excel 2003

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

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

About loop and cells

How do i do a loop to insert excel records to new excel worksheet as i onli want a certain of the columns from the existince excel. For the existince excel mi got record of column A - M then i just need to copy data of A - L then copy from the same existince column H data to the new excel worksheet. For those who know pls put up codes for me so tat i can have a better understanding over it . THankzAre you sure you have the right forum?|||oh so sorry coz i need to do this first then i can have a standard excel to push it into mssql database. SO i need to solve this situation before i can proceed. If i really post wrong so sorry as i am new .