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

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

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
Ashok

Hi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
AshokHi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S
|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )
No need to repost. Replied in your previous thread.
David Portas
SQL Server MVP

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )No need to repost. Replied in your previous thread.
--
David Portas
SQL Server MVP
--|||i'm really sorry about this.
i was just too eager to know the answer and i thought it may be no one
seeing my answer, so i post the same question repeatedly.sorry~~~
"David Portas" wrote:
> No need to repost. Replied in your previous thread.
> --
> David Portas
> SQL Server MVP
> --
>
>

about unstructured data analysis again~~

well...actually I just want to know a brief concept about using this tool to
analyze unstructured information. Does SQL server only apply for structured
information?if not, then what advantages can we get if we use this tool to
analyze unstructured data?Thanks again for your reply : )No need to repost. Replied in your previous thread.
David Portas
SQL Server MVP
--

About Count(Distinct) in AS

Hi,
Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
"Sum(IIF())" Syntax?
If it could be, how could I open or write Count(Distinct) or Sum(IIF())
function or syntax in Cube?
As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
Thanks!You can add an MDX expression in the cube definition, then the results of
the expression will be available as a cube cell, without re building the
cube...THis can be done in the cube editor of AS.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"angi" <angi@.microsoft.com> wrote in message
news:uuY2g6nfEHA.2468@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
> "Sum(IIF())" Syntax?
> If it could be, how could I open or write Count(Distinct) or Sum(IIF())
> function or syntax in Cube?
> As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
> Thanks!
>

About Count(Distinct) in AS

Hi,
Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
"Sum(IIF())" Syntax?
If it could be, how could I open or write Count(Distinct) or Sum(IIF())
function or syntax in Cube?
As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
Thanks!
You can add an MDX expression in the cube definition, then the results of
the expression will be available as a cube cell, without re building the
cube...THis can be done in the cube editor of AS.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"angi" <angi@.microsoft.com> wrote in message
news:uuY2g6nfEHA.2468@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
> "Sum(IIF())" Syntax?
> If it could be, how could I open or write Count(Distinct) or Sum(IIF())
> function or syntax in Cube?
> As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
> Thanks!
>

About Count(Distinct) in AS

Hi,
Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
"Sum(IIF())" Syntax?
If it could be, how could I open or write Count(Distinct) or Sum(IIF())
function or syntax in Cube?
As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
Thanks!You can add an MDX expression in the cube definition, then the results of
the expression will be available as a cube cell, without re building the
cube...THis can be done in the cube editor of AS.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"angi" <angi@.microsoft.com> wrote in message
news:uuY2g6nfEHA.2468@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Could Cube or MDX in Analysis Services execute "Count(Distinct)" or
> "Sum(IIF())" Syntax?
> If it could be, how could I open or write Count(Distinct) or Sum(IIF())
> function or syntax in Cube?
> As we know, MDX could execute Sum(IIF()), and how about Count(Distinct)?
> Thanks!
>

about analysis manager data mining model

i use sql server analysis manager and build a cube,
the i right click the cube ,select new mining model,
a messege box tell me: 'unable to get list of data mining
model algorithms,object or provider is not capabel of
performing requested operation'
what shall i do? install a new service pack?Please do not post the same question to multiple groups.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"frank" <wang_jidong@.founder.com.cn> wrote in message
news:0db101c3858d$6c8d7a40$a301280a@.phx.gbl...
> i use sql server analysis manager and build a cube,
> the i right click the cube ,select new mining model,
> a messege box tell me: 'unable to get list of data mining
> model algorithms,object or provider is not capabel of
> performing requested operation'
> what shall i do? install a new service pack?