locked
Report Model - int fields missing from model yet they are in Data View. How do i add a new field? RRS feed

  • Question

  • I have a dat amodel derived from the Team Foundation Server data warehouse database (TFSWarehouse).

    I added the [Current Work Items] table to the data view, and then clicked the button to "Add Related Tables".  This included the [Microsoft VSTS Common Priority] table. 

    After auto-generating the report model, I find that the Priority field is missing from the model.  Only the aggregate expressions are included.   It seems that the model decided that int fields should only appear as aggregates.


    My question is:

    ---------------------------------------------------
    HOW DO I ADD THE PRIORITY FIELD TO THE MODEL?
    ---------------------------------------------------


    Any ideas would be greatly appreciated.


    Tuesday, December 6, 2005 7:14 AM

Answers

  • Hi,

    Adding a "column" (a field in SMDL terminology) is easy, you only need to double check if it works with your datasource.

    To add a field:

    - Select your entity
    - Right click and choose "New" and "Source Field"
    - An entry with the name "New attribute" will appear in the Fields list (at the end)
    - Select that attribute and show its properties
    - Look for the "Binding" property. This property tells SMDL which "table" column in the DSV corresponds to the field (or the field is bind to).
    - Edit other properties at your will (Name and so on).

    Hope this helps,

    Jordi Rambla
    SQL Server MVP (Reporting Services)
    SolidQualityLearning
    Tuesday, December 6, 2005 8:48 AM