I need to write and modify some comments in a report developed with SSRS 2005.
The data model it’s a classic star schema.
I have a dimension with 3 hierarchical levels that we can group at all levels and some values in the fact table.
The user can write a comment in one, some or all rows of this report before print the report in PDF format. This comments don’t exists
in the source system.
My first idea it’s an exception to good practices of data warehousing (in the DW we can’t write extra data with forms ) and
I want to create a table that contains a key to join the correct row of report to the comment and a form to write this comments in the table. The report, after this update, can to be refreshed from data mart in join with my new table.
I hope to be clear in my explanation and sorry for my horrible English. Other ideas?
View Complete Post