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

To pull distinct values for a filter inside a dashboard

Started by asmfloyd, 20 Aug 2021 10:18:09 AM

Previous topic - Next topic

asmfloyd

Hello,
   I am keeping a couple of filters in my dashboard --year and fund.
Somehow my fund filter has same values but coded in different ways across various years. (Ex: Bofa coded uniquely as "Bofa", "BankofA"; "BankAme" in different years.). How can I ensure my "fund" filter pulls only unique values; when a particular year is chosen from the year filter?

While creating reports, we accomplish this (prompt) by keeping year as a parameter in the query and a dummy column as filter (Ex: Fact_createdate>'01-01-1753') so that it connects to fact and pull that year value only. How do we do this type filter(prompt) in dashboard?

Thanks,