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

DMR compare dates from different time hierarchy

Started by Wild Klaus, 11 May 2015 09:17:17 AM

Previous topic - Next topic

Wild Klaus

Hi All!
I need to add a filter to a query in which the date of payment (payment for orders> Payments> Payment Date) is less than the date of delivery (Delivery Order> shipping> delivery date).
How to compare dates from different time hierarchy?

And another question. How to add a filter in which the delivery date is not later than the 10th day of the month following chosen in the parameter (P_MONTH)?
Thanks!

Francis aka khayman

check this out: http://cognosm.fm3online.com

look for the topic about searching dimension with value from another dimension.