In Bex Designer how to restrict date characteristic for NULL value.

[Former Member]

Hi

In BI BEx Designer, i want to have a restriction on a date (PO Promise date) that would cause not to display the data which have no promise date.

Could u pls let me know how to restrict the date characteristic for NULL value.

Thanks...

[former_member189638 · Accepted solution]

Create a Formula variable of type replacement path type and replace it with Promise Date.

Include this Formula variable in a formula key figure

Now create a condition where the Forumla Key Figure > 0.

[Former Member · Accepted solution]

Thanks Rakesh for solving my issue. I assigned u the full points.

In your statement u mentioned: "Include this Formula variable in a formula key figure"

just wanted to ask is this matter whether i create formula KF or Calculated KF?

I think it wont, I think why u said is formula KF would local to teh query whereas Calculated KF would be global And why to make global un-necessarily, Right?

Tahnks

[former_member189638 · Accepted solution]

Hi Harpal,

That is correct...if you are gonna use this in other queries as well then u can defenitely create a Calculated Key Figure. or else forumla Key Figure if it is only in one query

[Former Member · Accepted solution]

I realized that. Thanks Rakesh for helping me out...

[Former Member · Accepted solution]

Hi Rakesh,

I have similar problem and I have implemented your solution as you suggested to Mr Harpal Singh but still my query out put shows # in date where there is not date.

solution which you provided:

Create a Formula variable of type replacement path type and replace it with Promise Date.

Include this Formula variable in a formula key figure

Now create a condition where the Forumla Key Figure > 0.

Need your help.

Points will be assign.

Thanks

Ansh

[Former Member · Accepted solution]

Hi Harpal Singh,

I am facing the same issue which you have faced would need your expert help in resolving my issue also. I have tried Rakesh solution but still i can see null records where there is not date in my date object.

kindly please suggest how you resolved your issue.

Thanks

Ansh

[Former Member]

We have option to create exception in BEx query. In that you can restrict your data to the values that you want to see. There you can define that your field is not equal to null.

This way it would only show the data that do not have date field blank.