I have a build a dashboard in reporting based on a package, but I was not satisfied with the performance.
So I decided to base this report/dashboard on a datamodule to boost the performance.
I created a Dataset per visual with aggregated data, so only filtering one some columns from the prompts would be applied.
Currently there are 6 datasets, and 1 dataset has about 2500 rows and the others less than 1000 rows.
These datasets are stored in a Datamodule. When I base the report on this Datamodule the performance is dissapointing.
Even slower than using the package version which fires SQL statements to the database.
Then this datamodule is combined with the organisation datamodule which contains all the facts and dimensions.
The organisation datamodule is based on a dataserver connection. So the result is a datanodule with 1 linked table (from the organisation datamodule) joined to all the datasets.
This linking is necessary because eventually the security filter should be applied, so users should only see customer data which they have autorisation for.
But even without the security filter applied, the performance is less than only using the datasets.
What can I try to have a better performance?
------------------------------
Thomas van der Meer
------------------------------
#CognosAnalyticswithWatson