Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Team System >> Team Foundation Server - Reporting & Warehouse

Unable to generate a model from the OLAP datasource

I have generated a model from the TfsReportDS datasource and I can write reports with that. If however I try to generate a model from the TfsOlapReportDS I get the following error:

SQL Server Reporting Services
Error

An error occurred while generating model. (rsModelGenerationError) Get Online Help An error occurred during the generation of semantic model : [Create mapping between cube dimensions and database dimensions]Unexpected error occurred : Schema indicates that cube dimension '[Team System].[Agent Machine]' is based on dimension 'Machine', however, the entity representing 'Machine' cannot be found..
[Create mapping between cube dimensions and database dimensions]Unexpected error occurred : Schema indicates that cube dimension '[Team System].[Agent Machine]' is based on dimension 'Machine', however, the entity representing 'Machine' cannot be found.
Unexpected error occurred : Schema indicates that cube dimension '[Team System].[Agent Machine]' is based on dimension 'Machine', however, the entity representing 'Machine' cannot be found.

That is very puzzling and means nothing to me. What is wrong here?

[1385 byte] By [BerndWechner] at [2008-2-7]
«« ReportBuilder Issues w/ Form Authentication
»» Creating an OLTP datasource for writing reports
# 1

Hi Bernd,

You must be a database admin in order to create the OLAP model. However, I would recommend that you use report designer directly against the cube to author reports against the TFS Olap Warehouse. We have seen performance impact and usability issues in using OLAP Report Builder Models on the TFS Cube, and will provide better capabilities in this space in a future release. For now, the recommendation is to use Report Designer directly against the cube.

Thanks,

tom

TomPatton at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 2

Tom,

Thanks for that! Alas having little experience and having played with Report Builder and Report Designer I can say upf ront that the former I could work with albeit with a wish for some more flexibility in end results, and the latter threw me into a fit of confusion yell "thou shalt do buckets of background reading or training to rnu this beast" at me! Let's say Report Builder is lucid and Report Designer looks powerful but incomprehensible to me.

All of which is beside the point. I really only wnated to know why I couldn't make a model and you've answered that well enough for me with the addendum that a model is highly unrecommended anyhow.

Cheers,

Bernd.

BerndWechner at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
Visual Studio Team System
Team Foundation Server - Reporting & Warehouse

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified