Question:
Hi
Does anyone have any ideas on the best way to do this: -
I have a payment scheme start date and an end date:
e.g
Record--------Start date-----------------------End Date
1-------------01/01/2003---------------------12/12/2003
However some times the scheme stops (Deactivation Date) for a number of reasons so it would look like this:
Record-------Start date--------End Date---------------Deactivation Date
1------------01/01/2003-------12/12/2003-------------01/09/2003
2------------01/02/2003-------15/10/2003-------------
As you can see if the plan hasnt been deactivated then the Deactivation date field is blank.
I need to only display the ones that are blank as i only want active schemes...
I dont think a filter or condition will do this,,,,does it need to be done in code etc.
thanks
BW Bill
Answer:
you talk about Bex?
why not using the filter????????
Answer:
Read what he wrote :
I dont think a filter or condition will do this,,,,does it need to be done in code etc.
I first thought that he could filter on "not assigned", but I think "not assigned" cannot be used for a date, because when you want to see the list of possible values, it shows up a calendar, you can therefore not select the "not assigned" value as for other characteristics.
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
That is correct ...the filter on date does pop up a calendar so this is not possible.
This is really bugging me and i would really like to get this solved!!
I would be happy to accept doing it the code way but i have this Credit Management guy saying
' but it would be good to have the deactivated ones available too--- for speculative reporting'
Im like 'give me a break' but what can you do....the client is always right!!!!!
any more ideas guys???
Answer:
if you are willing to do it via coding at loading time,
create an additional characteristic, and put it to X if the date is not empty;
then to create your query on blank date, you filter on this additional characteristic, restricting on "not assigned"
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Idea:
what about selecting the range of all your values in your calender and exclude this range??
does thins not work, or do i still get it wrong?
Answer:
it will work for the values in the calendar right now, but if the calendar extends (to next year, for instance) then your report is false again
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Did you try something in the restrict window like "less than '01/01/1000'" ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
CHC thats a great idea!!
Going to go for the creation of a new characteristic with an indicator in it.
This way i always get all the data over so if anyone needs to report on Deactivated ones then its there too and im not having to change the restriction date all the time either.
The restrict on 01/01/1000 seemeed agood idea too but im not too sure if this would account for a totally blank field...will investagate though!!
cheers guys
Answer:
I've also an idea to see what's in a void date : just display a record with blank date, and right-click and "filter" .... After that, just look in the Filter box interactively.
Don't hesitate to give the result of your tests, more interesting for the few nice people who make searches on the forum ...
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
"BW is like a box of chocolate; you just never know what you will get." Fred Gump.
I definitely know what I will get when I open a box of chocolates ! but perhaps does it come from my belgian nationality...
While I never know what I will get from BW !! but perhaps does it come from my belgian nationality too...
Answer:
Perhaps ...
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
CHC thats a great idea!!
Going to go for the creation of a new characteristic with an indicator in it.
But, you know, this seem like overkill to solve a problem which should not be happening in the first place. I cannot see this type of symptom ocurring in a real data warehouse. I suspect that it has something to do with the SID tables and disconnected references within them.