Hello,
Am new to Cognos Analytics and am trying to create a data module by using an existing data package as the source. I want only the last one month of data in my data module so I want to use a dynamic date filter to fetch data from the package. Please provide steps on how to achieve this.
Regards
Anand
A module does not store data; it is a query planning model.
You would need to have a better idea about what exactly you want to do. That would help me suggest approaches to the matter.
Modules support relative time filters.
You could create views from objects in the FM package and set up the relative time for whatever measures you want.
If you are looking to "store" a minimum amount of data created by some dynamic filtering, I suggest you look at Data Sets rather than Data Modules.
As previously stated, Data Modules do not store the data whereas a Data Set will allow you to store a subset of data that you can refresh on an as needed basis.
You can then build reports and dashboards over that Data Set.
Hope that helps,
Adam.
Thank bus_pass_man. For now, I will continue to create my dashboard by uploading the dataset file to my content and replacing the file to refresh the data in the dashboard. If I create views from objects in the FM package and set up the relative time for whatever measures I want, can I use the view as the source to the dashboard? if so please let me know how to do that.
Quote from: bus_pass_man on 15 Jan 2021 12:39:58 PM
A module does not store data; it is a query planning model.
You would need to have a better idea about what exactly you want to do. That would help me suggest approaches to the matter.
Modules support relative time filters.
You could create views from objects in the FM package and set up the relative time for whatever measures you want.
Thank you adam_mc
Quote from: adam_mc on 15 Jan 2021 01:22:01 PM
If you are looking to "store" a minimum amount of data created by some dynamic filtering, I suggest you look at Data Sets rather than Data Modules.
As previously stated, Data Modules do not store the data whereas a Data Set will allow you to store a subset of data that you can refresh on an as needed basis.
You can then build reports and dashboards over that Data Set.
Hope that helps,
Adam.