If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating Data Module from Data Package

Started by Anandkittu, 15 Jan 2021 08:12:51 AM

Previous topic - Next topic

Anandkittu

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

bus_pass_man


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.



adam_mc

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.

Anandkittu

#3
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.




Anandkittu

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.