Post reply

Report models for Ad Hoc reports

  • April 21, 2011 at 1:54 pm

    #235204

    I'm looking for insight into best practices for creating report models. I have created views for the main tables in our database, each for specific reports. In creating my model, would I be better served to use the views already created or just add the base tables? Which would give the most flexibility? Any guidance and tips would be greatly appreciated.

    Thanks.

  • April 26, 2011 at 5:53 pm

    #1316329

    dougsto (4/21/2011)

    I'm looking for insight into best practices for creating report models. I have created views for the main tables in our database, each for specific reports. In creating my model, would I be better served to use the views already created or just add the base tables? Which would give the most flexibility? Any guidance and tips would be greatly appreciated.

    Thanks.

    Views are preferred because those are queries so you can define your needs of the expected result which is not possible when you are pulling a table as your data source.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply