Error Opening Report in Report Builder

I try to open an existing report definition like "Bug Rates" (or any other ones for that matter) and always recieve an error with this: "Server data sources do not match RDL". Has anyone experienced this or know of a way to fix this?It appears your report has multiple data sources in it, which means you probably built the report in Report Designer. Report Builder expects the report to have exactly one data source -- a report model. It has many other limitations as well, so opening an arbitrary RD report in RB is generally not supported (although vice-versa is fine).|||

I too get this error. These are not reports that have been created in Report Builder by us, but are part of the MSF Agile process template with Team Foundation Server.

A range of standard reports are loaded when a new Team Project is created. It seems impossible to edit these using Report Builder.

There are two data sources defined in the standard TFS installation: TfsOlapReportDS and TfsReportDS. These both seem present in the reports if you go in to Properties -> Data Sources.

If this is the problem, and Report Builder has this limitation, how are we meant to amend the Team Foundation Server default reports?

This is obvious "as intended" from the TFS guys, and obviously SQL Reporting Services copes with multiple data sources as viewing the reports are fine.

But editing these without resorting to getting highly confused in manually editing the RDL is achieved how?

Many thanks,

Jonathan

|||We resorted to writing our own reports based on creating a model from TFSReportDS using the basic report builder. It isn't too difficult but take some getting used to. My boss has messed around with the more elaborate report editing that you can use via IDE extensions and was able to open the pre-baked report though he couldn't really make heads or tails of the underlying queries (and there are usually many) needed for what seemed to be a basic report. So far the feeling we have, is keep it basic or you need an incredible amount of OLAP related querying understanding to extend the reports.

Error Opening Report in Report Builder

I try to open an existing report definition like "Bug Rates" (or any other ones for that matter) and always recieve an error with this: "Server data sources do not match RDL". Has anyone experienced this or know of a way to fix this?It appears your report has multiple data sources in it, which means you probably built the report in Report Designer. Report Builder expects the report to have exactly one data source -- a report model. It has many other limitations as well, so opening an arbitrary RD report in RB is generally not supported (although vice-versa is fine).|||

I too get this error. These are not reports that have been created in Report Builder by us, but are part of the MSF Agile process template with Team Foundation Server.

A range of standard reports are loaded when a new Team Project is created. It seems impossible to edit these using Report Builder.

There are two data sources defined in the standard TFS installation: TfsOlapReportDS and TfsReportDS. These both seem present in the reports if you go in to Properties -> Data Sources.

If this is the problem, and Report Builder has this limitation, how are we meant to amend the Team Foundation Server default reports?

This is obvious "as intended" from the TFS guys, and obviously SQL Reporting Services copes with multiple data sources as viewing the reports are fine.

But editing these without resorting to getting highly confused in manually editing the RDL is achieved how?

Many thanks,

Jonathan

|||We resorted to writing our own reports based on creating a model from TFSReportDS using the basic report builder. It isn't too difficult but take some getting used to. My boss has messed around with the more elaborate report editing that you can use via IDE extensions and was able to open the pre-baked report though he couldn't really make heads or tails of the underlying queries (and there are usually many) needed for what seemed to be a basic report. So far the feeling we have, is keep it basic or you need an incredible amount of OLAP related querying understanding to extend the reports.

Error message: Data mining Query builder cannot....

Hello,

I wrote a data mining plug-in algorithm in SSAS and now I am trying to view the lift chart in Management Studio. The studio gives the following error:

"The Data Mining Query builder control cannot be initialized due to the following problem:
Deserialization failed: Multiple definition of element 'Column12' causes the content model to become ambigious. A content model must be formed such that during validation of an element information item sequence, the particle contained directly, indirectly or implicitly therein with which to attempt to validate each item in the sequence in turn can be uniquely determined without examining the content or attributes of that item, and without any information about the items in the remainder of the sequence."

I really do not understand what i did wrong. Can anybody help me?

Thanks, Joris

Can you describe the model you built and list the steps you went through to get the lift chart?

Also, what type of algorithm does your plug-in provide? Does it support discrete or continuous predictable columns?

|||

My algorithm is a support vector machine and the predictable columns are only discrete. The dataset i used is the wdbc dataset of the UCI repository.

I tried to get the lift chart by right-clicking on the build model in SQL Server Management Studio and select "View Lift Chart". When I try to get the lift chart in VS Business Intelligence Studio, VS BI shows the lift chart.

|||

What version of SQL Server 2005 are you running? (check the version for SQL Server Management Studio under the Help->About in Mgmt Studio's file menu). Did you install a CTP build of SP2?

Would you be able to send your plug-in algorithm .exe as well as the model definition to raman.iyer at microsoft.com? We might need to reproduce your problem to investigate this further.

|||

The version of SQL Server Management Studio i am running is:

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I installed SP2, but the specific build, i cannot remember. But as far as I can see in my control panel it is not a CTP build.

I have to discuss whether I can send my plug-in algorithm with Avanade Netherlands. I will let you know.

Error message: Data mining Query builder cannot....

Hello,

I wrote a data mining plug-in algorithm in SSAS and now I am trying to view the lift chart in Management Studio. The studio gives the following error:

"The Data Mining Query builder control cannot be initialized due to the following problem:
Deserialization failed: Multiple definition of element 'Column12' causes the content model to become ambigious. A content model must be formed such that during validation of an element information item sequence, the particle contained directly, indirectly or implicitly therein with which to attempt to validate each item in the sequence in turn can be uniquely determined without examining the content or attributes of that item, and without any information about the items in the remainder of the sequence."

I really do not understand what i did wrong. Can anybody help me?

Thanks, Joris

Can you describe the model you built and list the steps you went through to get the lift chart?

Also, what type of algorithm does your plug-in provide? Does it support discrete or continuous predictable columns?

|||

My algorithm is a support vector machine and the predictable columns are only discrete. The dataset i used is the wdbc dataset of the UCI repository.

I tried to get the lift chart by right-clicking on the build model in SQL Server Management Studio and select "View Lift Chart". When I try to get the lift chart in VS Business Intelligence Studio, VS BI shows the lift chart.

|||

What version of SQL Server 2005 are you running? (check the version for SQL Server Management Studio under the Help->About in Mgmt Studio's file menu). Did you install a CTP build of SP2?

Would you be able to send your plug-in algorithm .exe as well as the model definition to raman.iyer at microsoft.com? We might need to reproduce your problem to investigate this further.

|||

The version of SQL Server Management Studio i am running is:

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I installed SP2, but the specific build, i cannot remember. But as far as I can see in my control panel it is not a CTP build.

I have to discuss whether I can send my plug-in algorithm with Avanade Netherlands. I will let you know.