Where to do SQL-Calculations

[wernmatt]

Hi there,

I need to import data from a MS SQL 2008 Express into Cognos to get some reports. I started by creating a new framework, creating a data source and importing the tables. Afterwards I created and published a package including all the tables. Everything works fine so far.

Now I need to do some calculation, just two examples:

- I need to replace the foreign keys by the text from the joined tabled

- I need to calculate some values

My question would be, where is the best place to do so?

Would you rather use the framework manager and create some new tables containing the needed values. Or would you prefer to do those calculations in report studio? What would be there differences?

 

[blom0344]

It depends. If you can do it in the model, then all reports can benefit from the added objects in the model.
Replacing 'foreign keys by the text' has nothing to do with calculations. The keys themselves usually have no reporting purpose. You can even set is hidden to 'true' to remove them from the reporting perspective.

In the end all calculations (but some) are transferred to the generated SQL. The exception are running-xxx measures. These are generated on the server itself.

Ties Blom