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

RESOLVED: DMR - Age Bucket Filters

Started by Cognos91, 12 Jul 2017 11:04:33 PM

Previous topic - Next topic

Cognos91

I need to create an age bucket standalone filter for DMR model. The date field (Order Date) is an attribute of the dimension. It currently resides as an attribute (no role defined) of the lowest level of the hierarchy in the dimension.
The standalone age bucket requirement is 30/60/90, based on current date.
Logic = Order Date > Current Date and Order Date < (Current Date + 30).

Standalone filters are easily created in relational as logic is straightforward.
For DMR, I tried using the following:
filter(Order Date , _days_between ( Order Date ,current_date ) < 90)
I either received the following error XQE PLN 0093 / XQE PLN 0264.

What would be the correct way of retrieving the dates for the correct age bucket?
The Order Date in my case, is a pure attribute of the lowest level of a given dimension.

Thanks

Cognos91

Issue Resolved:

Since the 4 dates were defined only as member property of the lowest level in the dimension (hierarchy), the date function worked as adding filter.
days_between (Order Date, _add_days(Current Date, 90)) between 0 and  30, and so on.