Hey all,  I am currently starting to evaluate heading towards developing Data Modules.  In 11.1.5 I am currently building a Data Module and using the Relative Time feature.  I have used it against a few measures and it's great because it does all the YTD, CY, PY, measures quickly.

What I have noticed though is on the Current Year measure, I get an error:

XQE-PLN-0095 A null value cannot be used with the comparison operator 'LessThan'.

I'm not sure how to resolve this, or where I can fix this.  The relative time is a look up so when the measures are generated they can't be modified.  And it appears I can't just remove it.

Any help on this would be much appreciated.

Thanks!

Could you provide more context about where you encountered the problem please.

Where do you get this error?
Is this in a filter expression?

Obviously I've moved on to testing primarily in the stream which is currently under development but I did not encounter problems similar to what you report

I've attempted some tests in R5 just now but was not able to trigger an error

For example ,this filter works.
SLS_SALES_FACT.QUANTITY.Current_Year in_range {:20}

I tried that because there was a bug logged which mentions the xqe error, and it used that operator, that you mention but it was closed as not being reproducible.

Hey all,  I am currently starting to evaluate heading towards developing Data Modules.  In 11.1.5 I am currently building a Data Module and using the Relative Time feature.  I have used it against a few measures and it's great because it does all the YTD, CY, PY, measures quickly.

What I have noticed though is on the Current Year measure, I get an error:

XQE-PLN-0095 A null value cannot be used with the comparison operator 'LessThan'.

I'm not sure how to resolve this, or where I can fix this.  The relative time is a look up so when the measures are generated they can't be modified.  And it appears I can't just remove it.

Any help on this would be much appreciated.

Thanks!

Could you provide more context about where you encountered the problem please.

Where do you get this error?
Is this in a filter expression?

Obviously I've moved on to testing primarily in the stream which is currently under development but I did not encounter problems similar to what you report

I've attempted some tests in R5 just now but was not able to trigger an error

For example ,this filter works.
SLS_SALES_FACT.QUANTITY.Current_Year in_range {:20}

I tried that because there was a bug logged which mentions the xqe error, and it used that operator, that you mention but it was closed as not being reproducible.

Hey all,  I am currently starting to evaluate heading towards developing Data Modules.  In 11.1.5 I am currently building a Data Module and using the Relative Time feature.  I have used it against a few measures and it's great because it does all the YTD, CY, PY, measures quickly.

What I have noticed though is on the Current Year measure, I get an error:

XQE-PLN-0095 A null value cannot be used with the comparison operator 'LessThan'.

I'm not sure how to resolve this, or where I can fix this.  The relative time is a look up so when the measures are generated they can't be modified.  And it appears I can't just remove it.

Any help on this would be much appreciated.

Thanks!

I created a new cm data base for my 11.1.5 server, imported the samples deployment, and imported a deployment which contains some of my test modules, which use relative time.

I created a report and dashboard for a module and used current year. I did not get an error.

I took one of the sample modules, banking events, and imported the Gregorian calendar and set up relative time for all the measures.

I created a report and dashboard for this module and used current year.  I did not get an error.

I even put my measures into a folder for the sample module. (Funnily enough they are in a folder in my test module).

This would suggest that your report is slightly more complex and, somewhere in that extra complexity, something is generating the problem you see.

Could you provide more context about where you encountered the problem please.

Where do you get this error?
Is this in a filter expression?

Obviously I've moved on to testing primarily in the stream which is currently under development but I did not encounter problems similar to what you report

I've attempted some tests in R5 just now but was not able to trigger an error

For example ,this filter works.
SLS_SALES_FACT.QUANTITY.Current_Year in_range {:20}

I tried that because there was a bug logged which mentions the xqe error, and it used that operator, that you mention but it was closed as not being reproducible.

Hey all,  I am currently starting to evaluate heading towards developing Data Modules.  In 11.1.5 I am currently building a Data Module and using the Relative Time feature.  I have used it against a few measures and it's great because it does all the YTD, CY, PY, measures quickly.

What I have noticed though is on the Current Year measure, I get an error:

XQE-PLN-0095 A null value cannot be used with the comparison operator 'LessThan'.

I'm not sure how to resolve this, or where I can fix this.  The relative time is a look up so when the measures are generated they can't be modified.  And it appears I can't just remove it.

Any help on this would be much appreciated.

Thanks!