Error loading metadata....PLZZ HELP!!

My Analysis Service has this strange errors....

My Calculation tabs, KPI tabs, Action tabs....all showing this error message at it's Calculation Tools metadata tab....

"Error loading metadata: The cube could not be retrieved from the server. Verify that the server is running and that cube is processed."

previously i even had the problem of running the script organizer for the Calculation tabs.....after installing the SP2, it's fixed, but the metadata error still there.....

i tried on my friends PC and it works fine and deploy successfully whereas mine cannot at all with all kind of errors.....

Hello. I would recommend you to uninstall BIDS on you machine and reinstall it again with SP2.

Since you have a deployed cube you can always reverse engineer it to a project in BIDS when it is working.

Regards

Thomas Ivarsson

Error in sql profiler for analysis srevices 2005

Hi,

I am new to MS Analysis server technologies.
I environment consists of:
Server: windows 2003 server, Sql server 2005, analysis server 2005
client: windows xp

As given by Microsoft, I configured the server for HTTP access. When I try to browse to msmdpump.dll by giving the path "http://ServerName/olap/msmdpump.dll" both in server and client systems I get the HTTP 500 Internal server error.
I also did a right-click->browse from the inetmgr in the server. still I am getting the same error.

Should I not be getting some response when i browse to the msmdpump.dll?

Please do help me.
Is there something else that I have to do.

Regards
Vijay R

You cannot use IE. You should try and use client side application: One like MDXSample app shipped with AS2000 to browse AS2005 cubes.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks for the reply. I did that and with a bith of tweaking and minor re-coding I am able to run the sample.net windows application.

Next I tried to create a simple asp.net application similar to the code in the sample.net .The sample was in vb.net and I have coded in c#.

I now get the following error when I run and try to send a simple "Discover" request. The error i get is:

<code>

SoapException: The Session element at line 1, column 547 (namespace urn:schemas-microsoft-com:xml-analysis) cannot appear under Envelope/Body.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1503
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
OlapApp.XMLA.MsXmlAnalysis.Discover(Discover Discover1, Session& Session, BeginSession BeginSession, EndSession EndSession) in z:\olapapp\web references\xmla\reference.cs:47
OlapApp.TestForm1.btnRequest_Click(Object sender, EventArgs e) in z:\olapapp\testform1.aspx.cs:130
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

</code>

In my code I am doing the following:

I created a web reference to the msmdpump.dll (discover, execute - webservice) using the vs.wsdl in visual studio.

My page has a button and a drop down list, the drop down list enables the user to select the "RequestType" for the discover request. like catalog, cube, dimension....etc

on click, I set the properties of the discovery object and pass it to the webservice with the other parameters.

Here is my code:

<code>

private void btnRequest_Click(object sender, System.EventArgs e){

if(RequestType.Equals("DISCOVER_DATASOURCES"))

{Restrictions = "";

Properties = "<Format>Tabular</Format>";}

if(Restrictions != "")

{ string strRestrictionXml = "<RestrictionList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Restrictions + "</RestrictionList>";

RestrictionsXml.LoadXml(strRestrictionXml);}

if(Properties != "")

{string strPropertiesXml = "<PropertyList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Properties + "</PropertyList>";

PropertiesXml.LoadXml(strPropertiesXml);}

//main code is here--

XMLA.Discover XMLAdiscRequest = new OlapApp.XMLA.Discover();

XMLAdiscRequest.RequestType = RequestType;

XMLAdiscRequest.Properties = (System.Xml.XmlElement)PropertiesXml.FirstChild;

XMLAdiscRequest.Restrictions = (System.Xml.XmlElement)RestrictionsXml.FirstChild;

XMLA.Session XMLARequestSession = new OlapApp.XMLA.Session();

XMLA.MsXmlAnalysis DiscoverWS = new OlapApp.XMLA.MsXmlAnalysis();

DiscoverWS.Url = ServerURL;

DiscoverWS.Credentials = CredentialCache.DefaultCredentials;

ResponseXml = DiscoverWS.Discover(XMLAdiscRequest,ref XMLARequestSession,null,null).@.return;

lblResultant.Visible = true;

lblResultant.Text = ResponseXml.OuterXml;

<\code>

sorry for the lengthy code. can anybody tell me where I am doing wrong? if not can anybody give some sample code?

thanks and regards

Vijay R

|||

The error indicates that your request is not constructed correctly.

Try and run SQL Profiler connect to Analysis Services and see how well-formed requests look like when connecting from MDXSample app or SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks I found out the error. I was creating an object of the session.

Now it is returning a response for the "DISCOVER_DATASOURCES" discover request.

but when I am trying to discover the catalogs in the datasource, It is only returning the schema but no catalog rows.

It is the same code used for discover of datasources, except I changed the RequestType to "DBSCHEMA_CATALOGS" and the Properties to :

<DataSourceInfo>myDataSourceName</DataSourceInfo>
<Format>Tabular</Format>

Please tell me what is the reason for this?

Also, The above error is in an asp.net application. I then created a small windows application in C# .net. there it is returning me the correct response for the Dbschema_catalogs request.

What is the error? what should I be doing?

Thanks and Regards

Vijay R

|||

Hi,

wanetd to tell one more thing that I noticed. I had the sql profiler for ssas 2005 open.

All requests made by me (both win app and asp.net app) have a "0" (zero) in the error column for the event subclass "Server state Discover End".

what is this error? how do i solve it?

Thanks and Regards

Vijay R

|||

Try and see what is the user your asp application is running under. This could be just matter of access permission.

Error = 0 means the operation completed successfully.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi ,

Thanks,

That helped. I just added the Impersonate user in the web.config of the file.

I have another problem today.

Please do see my other post

thanks again

regards

Vijay R

Error in sql profiler for analysis srevices 2005

Hi,

I am new to MS Analysis server technologies.
I environment consists of:
Server: windows 2003 server, Sql server 2005, analysis server 2005
client: windows xp

As given by Microsoft, I configured the server for HTTP access. When I try to browse to msmdpump.dll by giving the path "http://ServerName/olap/msmdpump.dll" both in server and client systems I get the HTTP 500 Internal server error.
I also did a right-click->browse from the inetmgr in the server. still I am getting the same error.

Should I not be getting some response when i browse to the msmdpump.dll?

Please do help me.
Is there something else that I have to do.

Regards
Vijay R

You cannot use IE. You should try and use client side application: One like MDXSample app shipped with AS2000 to browse AS2005 cubes.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks for the reply. I did that and with a bith of tweaking and minor re-coding I am able to run the sample.net windows application.

Next I tried to create a simple asp.net application similar to the code in the sample.net .The sample was in vb.net and I have coded in c#.

I now get the following error when I run and try to send a simple "Discover" request. The error i get is:

<code>

SoapException: The Session element at line 1, column 547 (namespace urn:schemas-microsoft-com:xml-analysis) cannot appear under Envelope/Body.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1503
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
OlapApp.XMLA.MsXmlAnalysis.Discover(Discover Discover1, Session& Session, BeginSession BeginSession, EndSession EndSession) in z:\olapapp\web references\xmla\reference.cs:47
OlapApp.TestForm1.btnRequest_Click(Object sender, EventArgs e) in z:\olapapp\testform1.aspx.cs:130
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

</code>

In my code I am doing the following:

I created a web reference to the msmdpump.dll (discover, execute - webservice) using the vs.wsdl in visual studio.

My page has a button and a drop down list, the drop down list enables the user to select the "RequestType" for the discover request. like catalog, cube, dimension....etc

on click, I set the properties of the discovery object and pass it to the webservice with the other parameters.

Here is my code:

<code>

private void btnRequest_Click(object sender, System.EventArgs e){

if(RequestType.Equals("DISCOVER_DATASOURCES"))

{Restrictions = "";

Properties = "<Format>Tabular</Format>";}

if(Restrictions != "")

{ string strRestrictionXml = "<RestrictionList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Restrictions + "</RestrictionList>";

RestrictionsXml.LoadXml(strRestrictionXml);}

if(Properties != "")

{string strPropertiesXml = "<PropertyList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Properties + "</PropertyList>";

PropertiesXml.LoadXml(strPropertiesXml);}

//main code is here--

XMLA.Discover XMLAdiscRequest = new OlapApp.XMLA.Discover();

XMLAdiscRequest.RequestType = RequestType;

XMLAdiscRequest.Properties = (System.Xml.XmlElement)PropertiesXml.FirstChild;

XMLAdiscRequest.Restrictions = (System.Xml.XmlElement)RestrictionsXml.FirstChild;

XMLA.Session XMLARequestSession = new OlapApp.XMLA.Session();

XMLA.MsXmlAnalysis DiscoverWS = new OlapApp.XMLA.MsXmlAnalysis();

DiscoverWS.Url = ServerURL;

DiscoverWS.Credentials = CredentialCache.DefaultCredentials;

ResponseXml = DiscoverWS.Discover(XMLAdiscRequest,ref XMLARequestSession,null,null).@.return;

lblResultant.Visible = true;

lblResultant.Text = ResponseXml.OuterXml;

<\code>

sorry for the lengthy code. can anybody tell me where I am doing wrong? if not can anybody give some sample code?

thanks and regards

Vijay R

|||

The error indicates that your request is not constructed correctly.

Try and run SQL Profiler connect to Analysis Services and see how well-formed requests look like when connecting from MDXSample app or SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks I found out the error. I was creating an object of the session.

Now it is returning a response for the "DISCOVER_DATASOURCES" discover request.

but when I am trying to discover the catalogs in the datasource, It is only returning the schema but no catalog rows.

It is the same code used for discover of datasources, except I changed the RequestType to "DBSCHEMA_CATALOGS" and the Properties to :

<DataSourceInfo>myDataSourceName</DataSourceInfo>
<Format>Tabular</Format>

Please tell me what is the reason for this?

Also, The above error is in an asp.net application. I then created a small windows application in C# .net. there it is returning me the correct response for the Dbschema_catalogs request.

What is the error? what should I be doing?

Thanks and Regards

Vijay R

|||

Hi,

wanetd to tell one more thing that I noticed. I had the sql profiler for ssas 2005 open.

All requests made by me (both win app and asp.net app) have a "0" (zero) in the error column for the event subclass "Server state Discover End".

what is this error? how do i solve it?

Thanks and Regards

Vijay R

|||

Try and see what is the user your asp application is running under. This could be just matter of access permission.

Error = 0 means the operation completed successfully.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi ,

Thanks,

That helped. I just added the Impersonate user in the web.config of the file.

I have another problem today.

Please do see my other post

thanks again

regards

Vijay R

Error in Processing Cube (Microsoft Analysis Services)

Hi,
I am processing one cube using Full Process option and it's giving
following error.

Analysis Server Error: Internal error [Object does not exist] '11948' ;
Time:1/8/2004 6:11:11 PM

Error(-2147221421): Internal error (Internal error [Object does not
exist] '11948' ); Time:1/8/2004 6:11:11 PM

Can anyone help me on this.If you are using shared dims, process your dimensions, then the cube and see if that fixes it.

GO COLTS!!

HTH

Error in olap report

I am trying to write an olap report using RS2005. I created a datasource
with type "Microsoft Analysis Services" then added a report and defined
measures and dimensions in the query builder. Report is working fine but if
I make any modification, I will not be able to save the report and as soon
as I switch to any other tab (for example click on Preview tab or Data tab)
I will get the error "Microsoft Visual Studio has encountered a problem and
needs to close." I tried same senario by using "Analysis Services Toturial"
cube and I got same result.
Any idea?
Thanks.Actually, I'm used to getting this if I stress my development computer too
much... For bigger reports based on OLAP cubes, I just don't use the preview
function. I tweak my MDX query to just return enough data for the fields to
fill up right, and then I just save as quickly as possible. If you just add
a =" to the beginning of your query and a " at the end and make it be one
long string (no new lines), you will be able to save without the report
going to pieces. Remeber to use the "Save all" button after having added a
new report to your solution, or it will not be saved with your solution.
(But it will be available through "Add existing item".)
Not sure if this is what you wanted to hear, but it might save you from some
frustration.
Kaisa
"Tooraj" <abc@.abc.com> wrote in message
news:uEmibczBGHA.984@.tk2msftngp13.phx.gbl...
>I am trying to write an olap report using RS2005. I created a datasource
>with type "Microsoft Analysis Services" then added a report and defined
>measures and dimensions in the query builder. Report is working fine but if
>I make any modification, I will not be able to save the report and as soon
>as I switch to any other tab (for example click on Preview tab or Data tab)
>I will get the error "Microsoft Visual Studio has encountered a problem and
>needs to close." I tried same senario by using "Analysis Services Toturial"
>cube and I got same result.
> Any idea?
> Thanks.
>

Error in migrating from AS2000 to 2005

Hi all,

I have an analysis server database in AS2000. I want to migrate the same to 2005 analysis services.while doing that I am getting an error of following.

"Source server: No error message available, result code: E_FAIL(0x80004005)."

My AS2000 is in windows server 2000 with SP4 of SQL server.

My client is in windows XP and having SQL server 2005 with SP1.

Can anybody has suggestion on it?

Thanks in advance,

Vinod

It it is possible your AS 2000 server is not setup to be administered remotely. Books online should provide sufficient information on how to setup your machine to enable remote administration for AS2000.

Alternatively, try installing AS2005 as named instance on your AS2000 box. Or you can install AS2000 on AS2005 box and then migrate you databases.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error in metadata manager processing sample database/cubes

I've just installed SQL Server 2005 with Analysis Services and the sample AdventureWorks databases. When I try to process the database via SQL Server Management Studio, I get the following error - see below. I did check the xml file referenced by the name of the error and I do see the dimension listed Order Date key but not any attribute called Name of Date. Is there any workaround to enable processing of the database and cubes?

I did bump up to Sp1 and this did not fix my problem. I also tried installing the samples from the downloads section of microsoft.com. Alas, no success.

Any help appreciated,

Mairead

Errors in the metadata manager. The dimension with ID of 'Order Date Key - Dim Time', Name of 'Date' referenced by the 'Adventure Works' cube, does not exist.
Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.CDataContainer.Init(XmlDocument doc, IServiceProvider site)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDataContainer(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

Here is simple way out of your situation

1. Stop Analysis Service.
2. Delete everything in your D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db folder.
3. Start the service
4. Re-deploy your sample project.

Hope that helps

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I finally did get everything working again by completely uninstalling/reinstalling and redeploying the samples again. I did try your workaround but still could not get the samples processed successfully.

Mairead

Error in Deployment SSAS Project

Hi all,

I am getting an error while deploying an Analysis services project to my local server.

The error is as follows:

"Internal error: An unexpected exception occured."

I have no idea what this error refers to.....

Regards...

Girija Shankar

Hi,

I encountered this error before.

you should be able to see the detailed erroe message which you can discover from 'Event Viewer'.

Probably you have not started up your Analysis services server (you may want to look at if your analysis services has started up and if not, restart it and deploy your cube again).

Hope it helps.

With best regards,

Yours sincerely,

Error in Deploying an Analysis Services Project

Hi,

I am trying to deploy an Analysis Project and I get the error:

Error 1 The Description element at line 292, column 29 (namespace http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Cubes/Cube/Dimensions/Dimension. 0 0

Any idea?

Thanks in advance,

--Dimitris Doukas

Hi,

This is a defect that will be addressed in the service pack(s); meanwhile, to work around it, please do the followings:

- open each cube editor and, in the first tab (Cube Structure), check each cube dimension if it has a Description set

- remove all those Descriptions (by just specifying an empty string there) and then re-deploy

Adrian.

|||

Hi Adrian,

Thanks for the hint. Actually I had to edit the XML file to erase the description clause. If you just empty the string from the BI Studio if doesn't work.

Regards,

--DImitris Doukas

Error in creating a simple asp.net app similar to sample.net (as2000 samples)

Hi,

I am new to MS Analysis server technologies.
I environment consists of:
Server: windows 2003 server, Sql server 2005, analysis server 2005
client: windows xp

As given by Microsoft, I configured the server for HTTP access. When I try to browse to msmdpump.dll by giving the path "http://ServerName/olap/msmdpump.dll" both in server and client systems I get the HTTP 500 Internal server error.
I also did a right-click->browse from the inetmgr in the server. still I am getting the same error.

Should I not be getting some response when i browse to the msmdpump.dll?

Please do help me.
Is there something else that I have to do.

Regards
Vijay R

You cannot use IE. You should try and use client side application: One like MDXSample app shipped with AS2000 to browse AS2005 cubes.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks for the reply. I did that and with a bith of tweaking and minor re-coding I am able to run the sample.net windows application.

Next I tried to create a simple asp.net application similar to the code in the sample.net .The sample was in vb.net and I have coded in c#.

I now get the following error when I run and try to send a simple "Discover" request. The error i get is:

<code>

SoapException: The Session element at line 1, column 547 (namespace urn:schemas-microsoft-com:xml-analysis) cannot appear under Envelope/Body.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1503
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
OlapApp.XMLA.MsXmlAnalysis.Discover(Discover Discover1, Session& Session, BeginSession BeginSession, EndSession EndSession) in z:\olapapp\web references\xmla\reference.cs:47
OlapApp.TestForm1.btnRequest_Click(Object sender, EventArgs e) in z:\olapapp\testform1.aspx.cs:130
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

</code>

In my code I am doing the following:

I created a web reference to the msmdpump.dll (discover, execute - webservice) using the vs.wsdl in visual studio.

My page has a button and a drop down list, the drop down list enables the user to select the "RequestType" for the discover request. like catalog, cube, dimension....etc

on click, I set the properties of the discovery object and pass it to the webservice with the other parameters.

Here is my code:

<code>

private void btnRequest_Click(object sender, System.EventArgs e){

if(RequestType.Equals("DISCOVER_DATASOURCES"))

{Restrictions = "";

Properties = "<Format>Tabular</Format>";}

if(Restrictions != "")

{ string strRestrictionXml = "<RestrictionList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Restrictions + "</RestrictionList>";

RestrictionsXml.LoadXml(strRestrictionXml);}

if(Properties != "")

{string strPropertiesXml = "<PropertyList xmlns=" + '"' + "urn:schemas-microsoft-com:xml-analysis" + '"' + ">" + Properties + "</PropertyList>";

PropertiesXml.LoadXml(strPropertiesXml);}

//main code is here--

XMLA.Discover XMLAdiscRequest = new OlapApp.XMLA.Discover();

XMLAdiscRequest.RequestType = RequestType;

XMLAdiscRequest.Properties = (System.Xml.XmlElement)PropertiesXml.FirstChild;

XMLAdiscRequest.Restrictions = (System.Xml.XmlElement)RestrictionsXml.FirstChild;

XMLA.Session XMLARequestSession = new OlapApp.XMLA.Session();

XMLA.MsXmlAnalysis DiscoverWS = new OlapApp.XMLA.MsXmlAnalysis();

DiscoverWS.Url = ServerURL;

DiscoverWS.Credentials = CredentialCache.DefaultCredentials;

ResponseXml = DiscoverWS.Discover(XMLAdiscRequest,ref XMLARequestSession,null,null).@.return;

lblResultant.Visible = true;

lblResultant.Text = ResponseXml.OuterXml;

<\code>

sorry for the lengthy code. can anybody tell me where I am doing wrong? if not can anybody give some sample code?

thanks and regards

Vijay R

|||

The error indicates that your request is not constructed correctly.

Try and run SQL Profiler connect to Analysis Services and see how well-formed requests look like when connecting from MDXSample app or SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Thanks I found out the error. I was creating an object of the session.

Now it is returning a response for the "DISCOVER_DATASOURCES" discover request.

but when I am trying to discover the catalogs in the datasource, It is only returning the schema but no catalog rows.

It is the same code used for discover of datasources, except I changed the RequestType to "DBSCHEMA_CATALOGS" and the Properties to :

<DataSourceInfo>myDataSourceName</DataSourceInfo>
<Format>Tabular</Format>

Please tell me what is the reason for this?

Also, The above error is in an asp.net application. I then created a small windows application in C# .net. there it is returning me the correct response for the Dbschema_catalogs request.

What is the error? what should I be doing?

Thanks and Regards

Vijay R

|||

Hi,

wanetd to tell one more thing that I noticed. I had the sql profiler for ssas 2005 open.

All requests made by me (both win app and asp.net app) have a "0" (zero) in the error column for the event subclass "Server state Discover End".

what is this error? how do i solve it?

Thanks and Regards

Vijay R

|||

Try and see what is the user your asp application is running under. This could be just matter of access permission.

Error = 0 means the operation completed successfully.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi ,

Thanks,

That helped. I just added the Impersonate user in the web.config of the file.

I have another problem today.

Please do see my other post

thanks again

regards

Vijay R

error in calculated member

hi,

i want to create a calculated field in Analysis Services. But when I click on the Calculations tab, I get an error "Unexpected error occurred: 'Error in the application".

What seems to be the problem?

cherrie

Check the Calculate Script is properly there.

/*-- Aggregate leaf data --*/
Calculate

Thanks
Imran|||

hi,

sorry im new to this, how do i check that...

thanks!

cherrie

|||

Dear Friend,

Do you still have the error?

Regards!

|||

Hi,

Solved already.just versioning on dll.

Thanks!

|||

Cherriesh,

When you resolve your problem with or without support of the comunity, always check the answer as resolved!

Thanks and I happy that you get it!

Regards!!

Error in Analysis Services

I am getting an error while I try to browse data in a Cube. I have installed SQL 2000 Developer version along with Analysis Services. My operationg system is Windows XP.
I have attached the error message below.
Thanks
RVCE02what is the error you are getting ?

error handling while processing a cube

hi

in analysis services when i process a cube i got an error that
data from the fact table isnt exists in the dimenstion table
for example : fact table sales has column suplier that one of its row
has data(suplier id = 170) that doesnt match with the dimension table ( in the dimension table there isnt such supier id)
how can i handle this error ?
can i insert instead someyhing else so that the proccess can continue and not failed ?

Thanks

Eyal

Ideally, you've addressed this problem in your data warehouse/data mart. I recommend to my clients they never allow NULLs in their foreign keys. This requires you to place a NULL member in each dimension -- we usually assign that member the surrogate key value of -1 -- and eliminates this issue.

It sounds like in your example, you have a valid key in your partition, so I would suggest you make sure you dimension is processed before you process your cube/partitions.

If that is not an option, you use use the UnknownMember and ErrorConfiguration properties in SSAS to handle this issue. In the dimension that is causing problems (the supplier dimension in your example?) set the UnknownMember property to either visible or hidden. It defaults to None which makes the UnknownMember inaccessible.

Then, on the measure group that points to this dimension table, change the error configuration to replace missing key values with unknown (using the KeyErrorAction and KeyNotFound properties). Be certain to also set the KeyErrorLimitAction property to Stop Logging when the max error is hit.

One important gotcha on this. If your dimension member lands in your dimensions, the facts assigned to the unknown member do not revert to your new dimension value. To line your facts up correctly with the values in your dimension, you will need to do a full reprocess of the partition.

B.