on 11-07-2013 7:19 PM
Hi gurus, I am not sure if WebI let the scenario be real on the tool, I am in need ot creating a measure or dimension for the below mentioned case.
Beg Date Criteria
1-if Beg End Date is empty for each Prod Order Trans of one particular Prod Order then Beg Date is Created On
2-If one specific order has more than two Prod Order and Beginning and End dates are not null then Beginning date of the subsecutive line
Please refer the picture attached.
I wonder If BO is capable of doing this achieve.
Many thanks
Eddy.
This is definitely possible..
1. for requirement 1 just create a variable using if condition something like this and use that
=IF [Beg Date] is NULL then [Created On]
For requirement 2
2. Create a variable to get the number of prod order in a order.. something like below , call it "Count prod order"
=Count([prod order]) forall ([prod order])
3. now create another variable for this
=IF [Count prod order] > 1 and [Beginning Date] is not NULL and [End dates] is not NULL then [Beg Date]
p.s. I could not understood what you meant by "Beginning date of the subsecutive line" I assume its begin date
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I thought there are two output values you are looking for and you can get try relativevalue() function for next line record... You need to make changes to the slicing dimension based on your need in relative value clause...
You can just combine them to get the one variable something like
=IF [Beg Date] is NULL then [Created On] else if
[Count prod order] > 1 and [Beginning Date] is not NULL and [End dates] is not NULL then relativevalue([Created On];([Prod order]);1)
User | Count |
---|---|
86 | |
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.