on 01-03-2006 7:28 PM
I'm new with BW so forgive me if this seems naive. I have searched the various forums and have not found a solution to my problem.
I have a data source with two date dimensions, "created on" and "changed on" date. I want to select records with the criteria that EITHER the "created on" date or the "changed on" date is equal to a prompted date.
I can't seem to figure this out. Any help would be appreciated.
Hi
This can be done in a few way's.
1. Via User Exit that will take the prompted date and filter on both fields.
2. prompt both fields.
3. enable the selection for the user as free selection.
I think that option num 1 is the most suitable if you want this to happen in the background, if you want this filter to be more flexible I would use option 3 and train the users to use it.
Reg's
Edan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rick,
What Edan proposed will work as logical AND (both filters on dates will be checked simultaneously).
Here is a solution.
Youll have a user entry variable on 0CALDAY.
- Create a new variable on 0CALDAY, customer exit, mandatory, not ready for input. This variable should return the date entered in user entry variable.
- Create a structure in columns.
- New selection (lets name it chg). Put there your KF and your Change date char. Restrict it by the user entry var. Hide it.
- New selection (lets name it crt). Put there your KF and your Created on date char. Restrict it by the customer exit var. Hide it.
New formula (lets name it FilteredAmount):
( 'chg' <> 0 ) * 'chg' + ( 'crt' <> 0 ) * 'crt'
Create a condition:
FilteredAmount <> 0.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In my case it is an infoprovider that I am trying to select in the query panel based on two different date dimensions. Again I am trying to select results based on "created on date" = yesterdays date OR "changed on date" = yesterdays date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Welcome to SDN!
I guess that your words "<i>data source with two date dimensions</i>" should be treated as "infoprovider with two date dimensions"?
If yes, then there is a solution on a query designer level.
If no, please clarify the issue.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.