XMLA for retrieving a list of reports.
Hello Gentleman, 
 
I am searching for a way to get a list of all available reports within a 
 
data-warehouse. As I know, XMLA offers a way to query a multidimensional 
 
data source and retrieve dimensions and measures. I would like to find 
 
out in which reports are what measures and dimensions used. 
 
Help is very much appreciated. 
 
Cheers 
 
Glenn
Read Entire Conversation

'System.Web.Services.Protocols.SoapException: An error occurred while processing the request
Hi, 
 
I am trying to setup an XMLA connection to the foodmart 2000 sample 
 
dbase. 
 
But the following error is generated: 
 
'System.Web.Services.Protocols.SoapException: An error occurred while 
 
processing the request. 
 
at 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage 
 
message, WebResponse response, Stream responseStream, Boolean 
 
asyncCall) 
 
at 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String 
 
methodName, Object[] pa ...
Read Entire Conversation

Buy 2nd handphone for India market
Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri
Read Entire Conversation

What restrictions on MDSCHEMA_ACTIONS to get drillthrough actions?
Does anyone have an example of the restrictions which would get the 
 
drillthrough actions for Adventure Works 
 
Thanks 
 
--Chris Harrington 
 
Active Interface, Inc. 
 
http://www.activeinterface.com
Read Entire Conversation

XMLA with .NET Framework 2.0
Hi, 
 
I'm looking for some guidance for using XMLA with .NET Framework 2.0. 
 
We developed some applications which use the XMLA SDK 1.1 to query 
 
AS2000.  These work very well, but recently we've converted the 
 
application to VS2005 and .NET Framework 2.0 and the XMLA has stopped 
 
working.  We are still querying AS2000 and the XMLA dll gives the 
 
expected response when viewing through IE. 
 
As I've got a new laptop the other day I also re-downloaded from 
 
Microsoft the XMLA 1.1 SDK  ...
Read Entire Conversation

Latin characteres within XMLA
Hi, we are using SSAS 2005 SP 1 though msmdpump, but when text values contain 
 
latin characters (such as: áéíóú) the XML contains double question marks "??". 
 
We tried connecting from Excel through OLEDB for Analysis Services, and it 
 
works fine. 
 
Thanks
Read Entire Conversation

Listing Attribute Hierarchy Display Folders with XMLA
Does anyone know how to list "Attribute Hierarchy" "Display Folder" in AS 
 
2005 with XMLA? 
 
MDSCHEMA_MEASUREGROUPS lists Measure Groups .  It seems that there must be a 
 
way to do the same with display folders.
Read Entire Conversation

SSAS with an Instance name
Hi, we are using a SSAS with a named instance (SQL2K5) and just configured 
 
XMLA 1.1, but it brings an error: Datasource Local Analysis Server not found 
 
where "Local Analysis Server" is the DataSourceName and my 
 
<DataSourceInfo>Provider=MSOLAP.2;Data Source=mypc\sqk2k5</DataSourceInfo> 
 
Is there a problem with the named instance? 
 
Thanks,
Read Entire Conversation

How To Pick Winning Stocks
To pick winning stocks, you need the tools to separate 
 
the companies with superior sales and profit growth from 
 
the ones who are just making a lot of noise. Besides 
 
choosing the right companies to invest in, you must 
 
learn how to read the market's trend so that your timing 
 
is right. 
 
And picking the next big winner based on the news is not 
 
as likely as picking the next big loser. The news media's 
 
time-frame is usually very short, sometimes just that 
 
particular day! 
 
f ...
Read Entire Conversation

recordset.recordcount
I use recordset.recordcount when I am trying to find out how many records I 
 
have in a Microsoft XML object. I get the correct answer on windows XP but I 
 
always get 0 on any machines which run Windows 2000. Any ideas would be 
 
greatfully received.
Read Entire Conversation

Web Success
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
 
<html> 
 
<head> 
 
<title>Income For Life ™ - MY.WS</title> 
 
<link href="http://images.website.ws/kvmlm2/my_new.css" rel=stylesheet type=text/css> 
 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
 
<script type="text/javascript"> 
 
<!-- 
 
function Popup( url, name, opts) 
 
{ 
 
if (name == 'OF') 
 
{ 
 
parent.document.location.hr ...
Read Entire Conversation

Connecting to Analysis Services using Java - the solution!
Some time ago I posted regarding problems connecting to Analysis Services 
 
using Java. Many thanks to posters who replied but I never got it to 
 
work... until now. For the record and future developers with the same 
 
problem this is how I did it: 
 
I used REX - a brilliant set classes complete with front-end by Igor 
 
Ludi to browse AS cubes. I did not use the GUI front-end, but just the 
 
classes and methods for connecting to AS. These took care of a lot of the 
 
guesswork and ambiguit ...
Read Entire Conversation

Read cube from excel by XML For Analysis SDK Web service
Hi all, 
 
I configured correctly this web service, when I try to call it by IE I 
 
receive correct message. But when I try to call it from excel it gives me 
 
"server error". 
 
For this test I used driver OLAP 8.0 for create a pivot table from excel. 
 
Have you got any idea?
Read Entire Conversation

whether a cube is write enabled or not
How can I find whether a cube is write enabled or not using xmla.
Read Entire Conversation

SessionID
Hello, 
 
I have a question. I don't know how to use SessionID property of the 
 
AdomdConnection. 
 
I thought that once I open connection, I can get it and then after 
 
disconnecting, use it to connect to the same session. This way I wanted to 
 
implement connection pooling. 
 
My code looks like this: 
 
AdomdConnection connection=new AdomdConnection(...); 
 
connection.Open(); 
 
string sessionID = connection.SessionID; 
 
.... 
 
connection.Close(false); 
 
..... 
 
connection.SessionID = ...
Read Entire Conversation

EndSession is throwing an error
I recently upgraded to SqlServer 2005 and VS .Net 2005.  I'm using XML for 
 
Analysis.  I used vs.wsdl to generate stubs using gSoap. 
 
I'm ab;e to send the begin session request and it worked successfully. 
 
When I try to end session, I get an error.  See the following begin session 
 
request, response, end session request and error; 
 
<?xml version="1.0" encoding="UTF-8"?> 
 
<SOAP-ENV:Envelope 
 
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" 
 
xmlns:SOAP-ENC="http://s ...
Read Entire Conversation